Subtle Errors When Using Dates-Part 2

It’s so easy to make make mistakes with dates. Here is another one I saw recently, this one used when...

SQLSaturday #80 - Wheeling, West Virginia!

Next up, on the super SQLSaturday extravaganza, is SQLSaturday #80, in Wheeling, West Virginia!  Wheeling, known as the friendly city,...

Which database is using all my CPU #2

A few weeks back we wrote about a query to tell you which database is using up most CPU time....

Teaching Transact-SQL at University of Denver, University College

Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...

Select random records using TABLESAMPLE clause

While I was reading Martin Catherall’s post about Selecting from a table with no rows returned I remembered TABLESAMPLE function...

5 Ways to Be a More Effective DBA Today

Regular readers will now that I like to talk (quite a lot) about how we can be more effective as...

2011 SQL Rally Evaluations - Reporting Services Boot Camp

I wrote this early in June, but lost it in my blog pile again and just found it…

First and foremost,...

SQL Server Myth on Clustered Index page allocation or B-Tree formation

Here is another SQL Server myth which I realised while understanding anatomy of index pages.
For a long time I...

How to move the Master database

The catch to moving the Master database is that you must also move the Resource database.  Microsoft states that the...

Foreign Key Hierarchy Update

Today I would like to revisit a post of mine that is rather old.  More precisely, the script in that post needs revisiting.  This is one of my more...