Notes from SQLSaturday #168 in Tampa

I made a quick trip to Tampa for #168 this past weekend. It was a “BI Edition” and it felt...

PASS Summit 2012 Recordings Available

Did you attend PASS Summit and miss out on some sessions because there were so many or you were busy...

Top 3 Books on Writing Transact-SQL (TSQL)

This weeks blog posts have been focusing on books that I have read, like and recommend for learning SQL Server...

[video] Inside Tempdb - Bob Ward

Boris Hristov shared this with me ages ago and I still haven't watched it yet (it is a few hours...

Blogging for Beginners

Last week at the PASS Summit, I had several conversations with several different aspiring bloggers, and found myself saying the...

CTEs beyond SELECT

The other day I was writing a query to pull some DMV information and I ended up using several CTEs...

Explore file physical structure - fixed length row

1. Create sample db

use master
go
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...

Explore file physical structure - Insert Row - part 1

1. Create sample db
use master
go
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...

Explore file physical structure - Insert Row - Part 2

1. Create sample db
use master
go
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...

Explore file physical structure - variable length row

1. Create sample db
use master
go
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...