Preview of the Table Size Advisor
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
August 2012
Should I Use A Unique Identifier As A Primary Key?
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?
TSQL to Determine Plan Cache Size
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
Index Defragementation and Management
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