Day 6 of 31 Days of Disaster Recovery: Dealing With Corruption in Allocation Pages

Day 6 of 31 Days of Disaster Recovery: Dealing With Corruption in Allocation Pages
31 Days of Disaster Recovery
Yesterday, I...

Trying the Nest Thermostat

I’ve had the Nest Thermostat on my wish list for a while. It has looked like an interesting bit of...

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