Finding the contents of the Plan Cache
I often get asked “how do I find the contents of the SQL Server Plan Cache?” My first response is just use the Database… Read More »Finding the contents of the Plan Cache
I often get asked “how do I find the contents of the SQL Server Plan Cache?” My first response is just use the Database… Read More »Finding the contents of the Plan Cache
NOTE: My opinions on Blairs have been retracted after finding out that they were a front for dealing drugs. It is not that often that… Read More »Blair’s Repairs – These guys are awesome!!!
Beta 2 of the Database Health Reports has just been released. The new Beta contains several bug fixes, and several new features. Here is a… Read More »Beta 2 of the Database Health Reports Released
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… Read More »Finding tables that don’t have a clustered index.
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… Read More »Working on Beta 2 of the Database Health Reports
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… Read More »It is finally here. Beta 1 of the Database Health Reports for SQL Server.
As I get the Database Health project ready to release as a beta, more of the components are coming together. For instance shown here is… Read More »Preview of the Table Size Advisor
Take the following sample code. Four similar tables with an INT IDENTITY, BIGINT IDENTITY, and two with UNIQUEIDENTIFIERS, one using newid() and the other… Read More »Should I Use A Unique Identifier As A Primary Key?
In SQL Server 2012, there was a change to the dynamic management view that reports on the plan cache, so the query has changed. Here… Read More »TSQL to Determine Plan Cache Size
As I have been creating the Database Health project over the last couple of months, I have discovered that my favorite part of the whole… Read More »Index Defragementation and Management