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

Meme Monday – Horoscope

Did you know that your sign may have changed?  I didn’t – at least not until reading the meme Monday announcement....

Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac

Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Chinese Zodiac Figures by Joe Ledbetter

It’s time for July’s Meme Monday post, and...