Reports on Disk Space and Space in Files

Previously I have blogged about how to check for free space in a database at a file level; a file for a database can be very large, but the...

A Rickety Stairway to SQL Server Data Mining, Algorithm 1: Not-So-Naïve Bayes

            Thankfully, the simplest of SQL Server’s algorithms is not quite as naïve about data mining as I am.

            As mentioned...

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up
31 Days of Disaster Recovery
Here we are at day...

Row of nonclustered index page

Below is the formula of calculating the row size of non-clustered index page

so unique non-clustered index created on unique clustered index use smallest...

Speaking at SQL Saturday #183 – Albuquerque

I’ve been accepted to speak at SQL Saturday #183 in Albuquerque, NM on Feb 9, 2013. This is the first...

Reblog: December 28 to January 3

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

2012 in Review

With the year 2012 now in the rear view mirror, and while I’m still in the midst of my holiday...

SQL Server Contracting and Business Network Wales - LinkedIn Groups Updates

I have been doing some work on some LinkedIn groups that I manage and look after over the holidays. There...

What happen, If SQL Server new instance try to use exitsing named instance name?

We all know that SQL Server can have 1 default instance & many named instance.
But I want to check, How SQL...

When is a whitespace not a whitespace ?

As I'm sure I must have mentioned in the past, I’m presently involved in a large ALM project at a...