Meme Monday in July - PearlKnows All

It’s time for July’s Meme Monday, and below is my entry, Star date 07:11:11.  Started by Twitter|@SQLRockstar,  Thomas LaRock, today’s...

Meme Monday SQLstrology – Table Valued Zodiac Function

It’s Meme Monday time! Our topic is SQL Horoscopes, or more catchily, SQLStrology.
We’re going to have to figure out what astrological...

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

Misleading Error 1475 While Setting Up Database Mirroring

Misleading Error 1475 While Setting Up Database Mirroring
Wrong Way -->

I was doing some practice work yesterday testing out some mirroring...

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

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

SQLSaturday Round Table at the PASS Summit (Early Reminder)

Once again this year we’ll be holding a meeting open to all SQLSaturday event leaders and key team members (and...

Striping Backups in SQL Backup Pro

There are times you really do want to stripe backups across multiple files. If you have a short backup window,...

Subtle Errors When Using Dates-Part 1

I was reviewing some code recently that has been in production for a while and I saw something like this:
set...

The Dog Died, and The Cat's on the Roof

Despite the title, this is a serious blog entry, dedicated to all you pet lover's out there. Although, I seek to...