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

Category: Articles

Articles mostly focused on SQL Server technologies

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…

Update Statistics Misconception

Posted on Wednesday June 22nd, 2016

Having statistics up to date is important to get good query plans, but sometimes how to get it might be misunderstood On the 15th of June I made my first presentation at my…

Database design matters, seriously

Posted on Thursday June 16th, 2016

All those rules and best practices about database design exist for a reason. Today I want to show you something very simple for you to see how a good design might improve…

Extended Events File Target Reader

Posted on Tuesday May 31st, 2016

Getting useful information from Extended Event files is sometimes very tedious as you have to use XML queries and even PIVOT, what can be a better plan? It’s been some time since I…

TRUNCATE TABLE misconceptions

Posted on Wednesday May 25th, 2016

There is a number misconceptions around TRUNCATE TABLE which have been around for too long that people take them as the real truth, let’s debunk some of those TRUNCATE TABLE in SQL Server…

Index fun, disabling the Clustered Index

Posted on Wednesday May 18th, 2016

Disabling an index is always fun, but disabling the clustered index is even funnier, but probably not for your users, let me show you what can happen. Following a conversation with my junior…

Successful Anti-Patterns, Key Lookup VS RID Lookup

Posted on Tuesday May 10th, 2016

This post wants to show some performance improvements we may have by doing things the way we’ve been told not to When it comes to technical subjects like databases, we must always look…

Shrinking large half-empty MDF

Posted on Tuesday April 26th, 2016

Shrinking your database is not a best practice (sometimes can be acceptable) but it might be trickier than you expect Once again I’ve found my inspiration browsing linkedin SQL Server groups. Love it!…

Back To Basics, Lock Escalation in SQL Server

Posted on Friday April 15th, 2016

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

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…

Posts navigation

Previous 1 … 4 5 6 7 Next
  • 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
©2025 SQLDoubleG | Design: Newspaperly WordPress Theme