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…
Category: Articles
Articles mostly focused on SQL Server technologies
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…
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…
Row compression, a bit of internals
Compression in SQL Server has been around for a while now, come explore how it works internally Compression in SQL Server has been around for a while now, to be precise since SQL…
SQL Server 2016CTP3 fist impressions, Installation
My first impressions using SQL Server 2016, installation It’s been very exciting time waiting to get the new release installed, in my case SQL Server 2016CTP3, a bit late because I was building…
Daylight Savings end affects not only you, but your SQL Server too
If you take log backups and you changed from summer time the last Sunday of October, your backup log chain might be broken The last weekend of October is a common date for…
Divide and Conquer Date Search Hack
Divide and Conquer Date Search Hack (because binary search sounds boring) Divide and Conquer Date Search Hack (because binary search sounds boring) This week has been an amazing experience, not only I have…
Steve Stedman’s DBCC Challenge, Week-7 Winning Solution
Week 7 of the Database Corruption Challenge (DBCC), winning solution by @SQLDoubleG *First published @ Steve Stedman’s blog (2015/06/07) The seventh week of ten in the Database Corruption Challenge went well. There were a…