SELECT *
FROM Posts
WHERE Date_Posted = 'marzo 2016'

mar
31
2016

Index Creation VS SSMS Query

Tonight, Ladies and Gentlemen, we have one of the most expected fights in SQL Server!! Yeeeeeah!! Booooohhhh!!! (People cheering and booing) Hm, now seriously, I just read a comment in a blog…

Continue Reading »

mar
24
2016

SQL Server 2016 COMPRESS and DECOMPRESS performance

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…

Continue Reading »

mar
14
2016

The Mysterious Case of the Missing Default Value

*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…

Continue Reading »

mar
10
2016

SQL Server 2016, playing with DATABASE SCOPED CONFIGURATIONS

It’s been a few days since SQL Server…

Continue Reading »

mar
3
2016

Fast with values slow with variables

The other day I saw a thread on linkedin groups that was titled ‘Using Parameters in a Query is Killing Performance’, where the author…

Continue Reading »