The MSDN forum has been the inspiration for most of my blogs, but in all those cases, I was sure that I could attain the end result and my blogs were usually a graphical step by step depiction of what needs to be done, so that I could post it as an answer to the question. But this blog is quite different...
We discussed in previous posts, how important to create index on your tables or views. However, next question will come to you what is number of indexes that you can create or will the be a performance decrease on number of indexes you create? In all the previous cases, we consider only SELECT statements...
Ok, this post is dedicated to all those zillion questioners asking how to use embedded images on your report based on a condition. Yet again, I will be making use of my favourite dataset from AdventureWorks – Order Count by Product (people who are following me would understand that this is the same dataset...
Master Data Services (MDS) is a new feature / application that is getting introduced in SQL Server 2008 R2. To the best of my knowledge, there is almost no reference material or books available today on the market. Whatever reference material is available is in the form of some MSDN BOL documentation...
In one of my projects, I was asked to implement a drillthrough report, which had a depth of around 6 pages. After the development, I was sitting with the user who was testing the reports and I noticed that the user was frequently shifting between the sixth and the third report to change the values. As...
In the previous workshop we examined the usage of FOR XML AUTO. Today, we will examine FOR XML RAW, which is a bit more powerful when it comes to customizing the structure of XML output. Let us start with looking into the differences between the two. To run the examples in this post, you need to create...