Charley Hanania discusses consolidation and virtualization with SQL Server 2008.
Month: August 2008
Where’d Report Designer Preview go!?
If you are like me and have been toying around with Report Designer (aka Report Builder 2.0), you may have noticed that it disappeared with RC0 and RTM. Unfortunately, the RC0 version is the only version currently available and even more unfortuantely, if you haven't downloaded it already you are out of luck. I am … Continue reading Where’d Report Designer Preview go!?
Are You Sure You’re Using the Right Query?
I found a nice little feature in SQL Server Reporting Services (SSRS) today. Through the expression "=dataset!<dataset name>.commandtext" the query executed by the dataset can be returned to the report. There is also a rewrittencommandtext function but it appears to only be populated when Report Models are being used. This feature been around for a … Continue reading Are You Sure You’re Using the Right Query?
Find The Heap Indexes
I'm generally a convert to the congragation that all tables should have clustered indexes. It makes sense, helps performance, and in most cases is the best starting point for a tables. If you aren't part of the community of the faithful on clustered indexes, please read Kimberly Trip's blog on clustered indexes. There are other … Continue reading Find The Heap Indexes
Strate SQL 