The Seven-Day Weekend by Ricardo Semler

This great book by Ricardo Semler is something that some of my friends have been recommending me to read for...

Table Size Script Update for 2015

Newest update to the script to help discover and track object sizes within a database.
Related Posts:

Refresh SQL Modules November 9, 2018

Drop That Schema October 27, 2017

An Experiment...

Table Size Script Update for 2015

As was recently promised, I have an update to an old tried and true script for calculating the size of...

Hekaton - In Memory OLTP - Getting Started / FAQ :- 1

SQL Server 2014 introduced a major feature called "In Memory - Hekaton" Tables, in which even the fundamental concepts of SQL...

Start SQL Server in Single User Mode

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Clearing Out a Database With SQL Compare

I ran into a question recently about how to clear out a database of all objects. I assume someone was...

Using the DAC

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

SQL Server – Sparse Column Property using SELECT INTO

Hi friends, in our day to day work we used SELECT…INTO clause to create replica of a table for different...

Monday Morning SQL Break – August 3, 2015

It’s (finally) time for Monday’s weekly blog and twitter round-up for last week (it’s even on time). This post is...

Differences Between Actual & Estimated Plans

I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The...