Monthly Archives: July 2010

SQL Server 2008 Compression & Fragmentation

Few weeks back  I was evaluating implementing database compression in one of our data warehouse project. The first thought that came to my mind was how does compression impacts the fragmentations, because we had a performance issue with the index due to … Continue reading

Posted in T-SQL | 1 Comment

SQL Server: String Concatenation and Implicit Conversion

Sometimes you tend to forget the very basic thing in the heat of the moment and struggle for a while. When you realize it, you have nothing but a big grin. This happened to me few days back 🙂 One of … Continue reading

Posted in T-SQL | Leave a comment

Interesting Errors with RS.EXE

Few months back we have created a MSI using WIX, which calls the RS.EXE, to upload the RDLs into Report Server. Few days back there was a request from one fo the users that the MSI should backup the RDL … Continue reading

Posted in SSRS | 2 Comments

SSRS Report Delivery by Email failed with “Client not authenticated error”

I have SSRS 2008 intalled on my desktop. As part of testing, I had to enable a report to be delievered to a set of users by e-mail on schedule. So I tried to create a subscription. But in the … Continue reading

Posted in SSRS | 7 Comments

SSRS RDLC and Custom Code

Custom code does not work as expected when called from RDLC Group Footer Continue reading

Posted in SSRS | 1 Comment

Disabling hyperlinks when exporting SSRS Reports

There are times when we feel that the hyperlinks should be disabled when we export a SSRS report to other formats say Excel or PDF. Prior to SSRS 2008 R2 this was not possible. But in SSRS 2008 R2, this … Continue reading

Posted in SSRS | 12 Comments

Renaming sheets when exporting SSRS Report to Excel

Another frequently asked questions in many SSRS forums is How do I rename the sheets when exporting to excel? When a report is exported to excel, the excel sheets are named based on the report name, which is not a … Continue reading

Posted in SSRS | Leave a comment