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...

Foreign Key Hierarchy Update

Today I would like to revisit a post of mine that is rather old.  More precisely, the script in that...

Meme Monday – Horoscope

Did you know that your sign may have changed?  I didn’t – at least not until reading the meme Monday announcement.  Most people probably will see no difference in...