Latest SQLComics

Nested Loops

on March 24, 2024

Nested loop join operators tend to look quite innocent in an estimated query execution plan. But life ain’t always so simple.

LOOK HERE

Meet the SQL Server Query Optimizer

on March 11, 2024

Thanks to Erik Darling for pointing out that it needed a little teeth.

LOOK HERE

Plan Caching in SQL Server v1

on March 4, 2024

I drew out a first visualization of how the shared plan cache in SQL Server is used when you run a query. I’m pretty sure I’ll refine and and elaborate on this in the future, so let’s call this the v1.

LOOK HERE

Compare SQL Server Isolation levels

on February 17, 2024

Most modern hardware supports RCSI and Snapshot isolation beautifully.

LOOK HERE

Latest blog posts

24 Hours of Rad: 24HOP Spring 2011 Recap

on March 18, 2011

This past Tuesday and Wednesday (March 15-16) were 24Hours of SQL PASS.

Continue reading

Be My Date Next Tuesday, March 15 at 24 Hours of PASS

on March 10, 2011

Next week the Professional Association for SQL Server will be providing 24 hours of free, online training on SQL Server.

Come get your learn on.

Continue reading

How To: Automate Continuous SQLServer Activity with Stored Procedures and Powershell Jobs

on March 2, 2011

It’s often useful to be able to run a bunch of stored procedures in the background over a period of time against a test instance.

Continue reading

The Magic of the Self-Assigned Lab (SQLSkills Immersion Training Days 2 and 3)

on February 24, 2011

Today, more blog from SQLSkills Immersion Training on Internals and Performance in Dallas, TX. For more about the training, see my prior post.

Continue reading