Year: 2012

Cannot resolve the collation conflict

One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation It is recommended that the collation of your database match the collation TempDB.   It is possible

Posted in TSQL Tagged with: , ,

Sessions submitted to SQL Saturday Vancouver BC

I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run Faster” Switch The NO_LOCK hint is often believed to be the “Run Faster” switch, but

Posted in CTE, SQL Saturday Tagged with: , , , , , , , , ,


After writing a recent blog post on Are you wasting half the capacity of IDENTITY, I started thinking about how much is too big for an BIGINT IDENTITY. If you don’t know about, you can get Are you wasting half the capacity

Posted in SQL 2008, SQL 2012 Tagged with: , , ,

Are you wasting half the capacity of IDENTITY?

When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer data type category, except for the bit data type, or decimal data type.  So how

Posted in Database Health Tagged with: , , , , , , , ,

Muda – or the 7 Deadly Wastes

In the manufacturing world it is referred to the 7 wastes, or the Japanese term Muda.  How does this apply to software development. THE 7 WASTES OR MUDA ARE: Transportation Inventory Motion Waiting Over-Processing Over-Production Defects These all apply to

Posted in LEAN Tagged with: , ,

Database Health Version 3.1 So Soon After Beta 3

Today I release Beta 3.1 of the Database Health Reports. Immediately after the release of Beta 3, there were 3 bugs reported that were very quick to fix.  I was able to get these fixed, along with one other bug

Posted in Database Health Tagged with: ,

Beta 3 is Now Available.

One big new feature in Beta 3 of the Database Health Reports, the historic monitoring. The way that the historic monitoring works is that it continuously monitors your SQL Server database and logs the details around queries that are causing

Posted in Database Health Tagged with: , , , , , , ,

Beta 3 of the Database Health Reports will be launched tomorrow.

Finally after a month and a half of preparation on Beta 3 of the Database Health Reports, it will be released tomorrow. The biggest feature in Beta 3 is the historic monitoring.  This process installs a small database to track

Posted in Database Health Tagged with:


Coding on the Database Health Reports project, making notes in my Quest Software notebook, with a pencil from Redgate SQL in the City, wearing my Confio t-shirt, refilling my SQLSentry plastic pint glass with a Nalgene bottle from Quest Software,

Posted in SQL Saturday Tagged with: ,

Temp Table vs Table Variable vs CTE and the use of TEMPDB.

For more information on Common Table Expessions and performance, take a look at my book at Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs There are

Posted in CTE, Performance Tagged with: , , , , , , , ,