SQL Server Performance

how to recreate sql server statistics in a different environment
HOW TO: Recreate SQL Server Statistics In a Different Environment

Did you know table and index statistics are the most important piece of metadata for your database?The reason for this has to do with how SQL Server (and other database engines) build query execution plans. The query optimizer builds an execution plan based upon the statistical data available at the...

Changing Default Database File Locations in SQL Server

When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties. You can see these properties for yourself by right-clicking on the instance name...

Doing it Wrong: Database Mirroring

Just a quick post for some Friday fun.If you want to know how to do database mirroring right, start with this MSDN link: if you are thinking of buying yourself a nice book on Christmas on database mirroring, I'd recommend this one: Pro SQL Server 2008 Mirroring...

The Five DBA Food Groups

Tomorrow is Thanksgiving here in the USA. It's a day where we are supposed to be thankful for what we have been givenĀ and instead we mostly use it as an excuse to eat obscene amounts of food, watch 10 hours of NFL action, and force retail workers to work longer...

HOW TO: Find Currently Running Long SQL Agent Jobs

A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I've been sharing some scripts recently, I decided to verify thatĀ this script still works for finding long running jobs in SQL Agent for SQL Server 2014. Why This Script Matters Because you...