Skip to content
SQLDoubleG
Menu
  • Home
  • Articles
  • SQL-G Hacks
  • Language: English
    • English English
    • Español Español
Menu

Month: March 2016

Index Creation VS SSMS Query

Posted on Thursday March 31st, 2016

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

Posted on Thursday March 24th, 2016

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

Posted on Monday March 14th, 2016

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

Posted on Thursday March 10th, 2016

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

Posted on Thursday March 3rd, 2016

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…

  • About this blog
  • Articles
  • Development
  • Free Training
  • Security
  • SQL Server 2016
  • SQL-G Hacks
  • T-SQL Tuesday

Latest Posts

  • T-SQL Tuesday #158, Implementing Worst Practices
  • T-SQL Tuesday #155 –The Dynamic Code Invitation
  • FillFactor, the Untold Story
  • How I Compared 1000’s of database’s schemas at once
  • How to Update SQL Server Stats The Right Way
©2023 SQLDoubleG | Design: Newspaperly WordPress Theme