July 2010 - Posts

29 July 2010
URLs to reports with non-default parameters
You can give somebody a hyperlink to get to a Reporting Services report and that's all they need if there are no parameters or if the default values are what they want. But how do you specify values for parameters? It turns out to be pretty simple but the documentation is a little vague on some of... Read More...
no comments
Filed under: , ,
14 July 2010
Be careful with table variables
I just looked into a poorly performing stored procedure and brought it down from over 4 minutes to under 4 seconds by making one simple change: converting a table variable into a temporary table. What's interesting is that there were only about 20,000 rows of about 1,100 bytes each in the table variable... Read More...
8 comment(s)
Filed under: ,
02 July 2010
R2 Report Pagination
I thought it was all too good to be true. We upgraded our reporting server in place from 2005 Std to 2008 R2 and we've hit a major problem. We have a few reports that are about 60 pages. On 2005 the report would render page 1 of 60 pretty quickly. Now it produces page 1 of 2 that is miles long and... Read More...
no comments
Filed under: ,
02 July 2010
R2 Collation Gotcha
On my dev machine I installed R2 alongside my existing 2005 instance and it did a funny thing with the new instance's collation. Our servers are all on Latin1_General_CI_AS, including my 2005 dev instance. But my R2 instance defaulted to SQL_Latin1_General_CI_AS and I've only just noticed, which... Read More...
no comments
Filed under: ,