Is it true that creating the index is quicker than running the query you needed it for? Let me show you the answer Tonight, Ladies and Gentlemen, we have one of the…
Month: March 2016
SQL Server 2016 COMPRESS and DECOMPRESS performance
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…
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…
SQL Server 2016, playing with DATABASE SCOPED CONFIGURATIONS
It’s been a few days since SQL Server 2016 RC0 was released and one of things people have blogged about is the new DATABASE SCOPED CONFIGURATIONS, where you can do modify certain…
Fast with values slow with variables
There is a big debate why the same query can run fast with hard coded values and slow when using variables, come see there is a reasonable explanation for all this mess. The…