Finding Checked Out Files in TFS

There may be an easier way, but this was a quick way to find ALL the checked out files in...

Fix for index corruption issue || SQL Server 2012 Service Pack 2

ISSUE : FIX for Data loss in clustered index occurs when you run online build index in SQL Server 2012
Microsoft release...

No Files For You

No Files For You is another Question Of The Day. I ended up making this one just a little more...

Partitioning Basics – Part 3 – Switching Data

This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...

PASS DBA VC Session 25th June

It’s always an honour to be able to speak at an event, but events can be expensive to attend and...

Space Used by Database Files

Retrieve data about size and space used for all the files in the current database with this script.

Some tips on...

SQL Server – Script to Configure TempDB Files per Number of Logical Processors

In order to reduce Tempdb contention one of  the best practices is to maintain multiple sized Tempdb data files, matching the...

Exploring Excel 2013 for BI Tip #15: Locking Slicer Position

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

ExpressProfiler: Yet another "when and why" story.

Core of ExpressProfiler  was born about 8 years ago when I worked for a company whose mission was the migration...

Introduction to Latches in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...