Sort – Is it Really a Blocking Iterator?

SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.
A non-blocking iterator gets rows in and sends rows...

SQL Pass Summit 2014

Next week I will be in Seattle for the 2014 SQL Pass Summit event.  If you are involved in projects...

Add Database File on Database invloved in DB Mirroring

MSSQLFUN
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file...

Add Database File on Database invloved in DB Mirroring

Add Database File on Database invloved in DB Mirroring.

Add Database File on Database invloved in DB Mirroring

Add Database File on Database invloved in DB Mirroring

Add Database File on Database invloved in DB Mirroring.

Headed to the PASS Summit 2014

I can hardly believe how fast this year has flown by. My favorite SQL Server conference of the year, the...

Managing Geeks – A journey of leading by doing

I am proud to share that my good friend Andy Leonard has just released a new book. This is also...

Maximum number of rows per data page and minimal record size (SQL Server storage internals)

Maximale Anzahl Zeilen je Datenseite und minimale Datensatzgröße
(DE)
In einer meiner letzten Master-Classes tauchte die nicht ganz ernste aber dennoch...

PASS Summit 2014

Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we...