More new functionalities coming along with SQL Server 2016, this time I’ve been playing with COMPRESS and DECOMPRESS One of the most exciting things for me in this new version of SQL Server…
Etiqueta: Storage Engine
The Mysterious Case of the Missing Default Value
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why. *First published @ www.SQLServerCentral.com (2015/12/01) Once upon a time, there was a…
Clustered index row order
How rows are physically stored is well known and sometimes very misunderstood, let me show you something might not be as you expect One of the basic (and well used during interviews) questions…