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

Tag: Performance Tuning

Here is your index, now what?

Posted on Friday February 9th, 2018

This story might sound familiar for most of the DBA’s out in the wild. Our job to keep databases up and running, and sometimes, make them to go faster (I’m not going…

Spring cleanup, LOB considerations

Posted on Wednesday March 29th, 2017

For DBA’s it is important to have the ability to recover databases quickly in case of disaster. In order to maximize the potential we need to have our databases ready but sometimes…

Not the typical story about key lookups

Posted on Wednesday March 22nd, 2017

Query plans are very useful to tune queries, but some operations are usually avoided or blamed for performance problems when not always are the culprit, let me show you one of those…

Multi-column statistics are back in SQL Server 2016

Posted on Friday September 30th, 2016

The new cardinality estimator in SQL Server 2014 brought new and improved query performance but as always there are caveats. Let’s check a specific case to see the different behaviors for the…

SQL Server 2016 Query Store, User Data or Metadata?

Posted on Wednesday July 6th, 2016

One of the newest features for SQL Server is the Query Store, let’s explore it to know a bit more about it It’s been a month since the SQL Server community has their…

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…

  • 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