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…
Tag: Performance Tuning
Spring cleanup, LOB considerations
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
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
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?
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
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…