Optimization

Sean’s Famous Backup Tuning class!

Yes, you can tune your SQL Server backups! Have you ever gotten tired of your 1TB database taking 4+...

Have you ever wanted to be able to view instance-level stats or change certain values without having to use...

Here I show you how to turn off AutoShrink on a DB and then how to make sure it’s...

Thomas LaRock from Confio came to give us this really good talk on waits and queues. And as an...

I like this video. This is a simple example of how you can track down queries that are timing...

Paul and Kim Tripp from SQLSkills.com came to teach us their award-winning presentation on DB performance.

I’ve been getting lock timeouts on one of my systems, so I captured the timeouts in a profiler trace....

Here’s a level zero introduction to tuning queries. I go over execution plans, sp_help, and clustered primary key indexes.

server side traces, the benefits, and how to set up, edit, run, and stop a server side trace.

I’m going over the basics of how to implement data compression here. I’m not really touching on where and...

This is a nice video that discusses the basics of performance monitoring in windows. This is actually a live...

This is the continuation of the live presentation I did a couple weeks ago. This one covers disk counters,...

Moving database files is easy, but misunderstood. Here I’ll show you how to move user DB files using 2...

Disk queues are a mystery for the majority of DBAs. They may know that they need to look at...

What do you do if you have a set of data and log files you can’t attach because the...