Sp_MSForEachDB is a great procedure coming with MS SQL Server even though it is un-documented. It eases some of the complex operations that we mostly do by using CURSORS.
CTEs are one of the beautiful and the most powerful feature of SQL Server. It is introduced in SQL Server 2005 and I guess is one of the best things in SQL Server. This not only simplifies most of the complex and impossible queries in T-SQL, but also provides one medium to deal with recursive queries. Moreover, I can say it is mainly for recursive queries. It can be used in replacement of derived tables (sub queries), temp tables, table variables, inline user-defined functions etc.
Business Analyst as per Wikipedia, “A Business Analyst (BA) analyzes the organization and design of businesses, government departments, and non-profit organizations; they also assess business models and their integration with technology.” and so much that really bounce over my head. Although it’s very true whatever is written over there as a professionalism of a Business Analyst.
But today I would like to tell you something really very interesting about the work of a Business Analyst. I worked with a team of completely experienced and talented people who, to be honest, knew a lot more than I did as per business perspective. I learned a lot and luckily I had some really great people to learn from. A business analyst is someone who always takes care of the clients, their problems, their requirements, who delights clients with the trust that whatever he will suggest to them is more than good what the client expects.
Throughout my experience I come across so many database designing problems. And today I want to share some of the common influences and impacts of most common designing mistakes that bring big disaster to the whole project.
One of the most common designing mistakes is the “Poor Planning / Architecture” of the database or mart.