Sometimes something innocuous can take our application down, that’s why it’s important to get back to the basics Today at work we’ve had a very common request, no big deal, just a couple…
Index Creation VS SSMS Query
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…
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…
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…
Day 1 @ AdventureWorks, the Solutions
Solutions for Day 1 of exercises using the AdventureWorks sample database It’s been a while since I published Day 1 questions and I guess it’s time to post the answers I came up…