Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon today. Have a great rest of the day. As promised I have posted the slides and sample TSQL queries here. If you have any questions, …
Unleashing Common Table Expressions in SQL Server – Slides and Sample Code Read more »
Coming in the next beta of the Database Health Report is a new feature called the Historic Reports which installs a small database to track database statistics over time. This has an extremely light load on the overall database performance, …
Database Health Reports – Historic Waits Report Sneak Preview Read more »
I often get asked “how do I find the contents of the SQL Server Plan Cache?” My first response is just use the Database Health Reports and you can get this through a nice user interface. But if you …
Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be overlooked when creating a table. This is actually more likely if you are inheriting a …
Finding tables that don’t have a clustered index. Read more »
Beta 2 of the Database Health Reports will be available in the next 7 to 10 days as I finish it up. There has been a good acceptance of Beta 1 so far, and with feedback here are some of …
Working on Beta 2 of the Database Health Reports Read more »
In October last year I started work on the Database Health reports project. It started out as a series of SSRS reports that I released and updated in December 2011 to March 2012. After that it became clear that the …
It is finally here. Beta 1 of the Database Health Reports for SQL Server. Read more »
Take the following sample code. Four similar tables with an INT IDENTITY, BIGINT IDENTITY, and two with UNIQUEIDENTIFIERS, one using newid() and the other with newsequentialid(). Once the tables are created and we insert 100,000 rows into each, they …
Should I Use A Unique Identifier As A Primary Key? Read more »
Originally I implemented the Database Health Reports as a series of SQL Server Reporting Services reports, which was very handy and easy to create, but hard to distribute in a way that they could be shared and customized to the needs …
There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2012, instead it has been replaced with the SQL Server Data Tools that uses the core of Visual Studio 2010, with the Report Builder and Report Designer built …
No more Business Intelligence Development Studio in SQL 2012 Read more »
In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. This report has been replaced with the Backup Report in the Database Health Project. The Backup Set …
Backup Set Report added to FREE Server Health Reports Read more »