SELECT *
FROM Posts
WHERE Tags IN ('Storage Engine')

Mar
14
2016

The Mysterious Case of the Missing Default Value

*First published @ www.SQLServerCentral.com (2015/12/01) Once upon a time, there was a DBA… yeah right! As probably like many SQL DBA’s, little by little I’m getting more curious about how SQL Server works internally. To…

Continue Reading »

Feb
29
2016

Clustered index row order

One of the basic (and well used during interviews) questions about SQL Server internals is how you call a table without a clustered index, and that in SQL Server is called a HEAP….

Continue Reading »