SELECT * FROM Posts WHERE Tags IN ('Storage Engine')
One of the most exciting things for me in this new version of SQL Server is inclusion of native gzip compression into the, I guess, storage engine functionalities. I know you can implement your own CLR version of…
*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…
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….