Day 5 of 31 Days of Disaster Recovery: Dealing With Corruption in a Nonclustered Index

31 Days of Disaster Recovery
Welcome to day 5 of my series on disaster recovery. I want to start digging...

Give the Gift of Feedback

I bet if you think about it there are lots of times when people ask what you think about a...

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...