Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
SQL Server Insights
We have moved!
Thanks for visiting! This blog has now been migrated to:...
Date: 03/29/2019
Developer’s Choice: Hinting Query Execution model
This is a cross post with https://aka.ms/sqlserverteam Over the years you have read a number of blogs...
Date: 09/22/2018
Predicate Pushdown and why should I care?
Cross post with https://aka.ms/sqlserverteam If you follow this blog, you know that in the last...
Date: 07/09/2018
More Showplan enhancements – UDFs
Cross post with https://aka.ms/sqlserverteam As I mentioned on yesterday’s post, with the recent...
Date: 02/21/2018
More Showplan enhancements – Row Goal
Cross post with https://aka.ms/sqlserverteam As I shared before, we have been working for over a year...
Date: 02/20/2018
Perfect statistics histogram in just few steps
Cross post with https://aka.ms/sqlserverteam A similar question about statistics came to the team...
Date: 11/23/2017
Making parallelism waits actionable
Cross post with https://aka.ms/sqlserverteam During PASS we announced changes to how users will be...
Date: 11/13/2017
New Showplan enhancements
Cross post with https://aka.ms/sqlserverteam If you follow this blog, you have seen that in the past...
Date: 11/10/2017
Persisting statistics sampling rate
Cross post with https://aka.ms/sqlserverteam When SQL Server creates or updates statistics and a...
Date: 08/12/2017
New in SSMS: Searching in Showplan
Cross post with https://aka.ms/sqlserverteam Have you ever analyzed a somewhat big plan? And while...
Date: 08/08/2017
New in SSMS: Performance Dashboard built-in
Cross post with https://aka.ms/sqlserverteam Back in 2007, we released the Microsoft SQL Server 2005...
Date: 08/07/2017
Correlating xEvents with DMVs
Cross post with https://aka.ms/sqlserverteam Since the inception of xEvents there has been the need...
Date: 08/03/2017
SQL Server 2017 Showplan enhancements
Cross post with https://aka.ms/sqlserverteam In my previous post on Easy way to get statistics...
Date: 05/12/2017
New in SSMS: Query Performance Troubleshooting made easier!
Cross post with https://aka.ms/sqlserverteam The community already uses tools that can make it easier...
Date: 05/03/2017
Easy way to get statistics histogram programmatically
Cross post with https://aka.ms/sqlserverteam Statistics being the building blocks on which the Query...
Date: 03/24/2017
Getting more statistics information programmatically
Cross post with https://aka.ms/sqlserverteam As the building blocks which the Query Optimizer uses to...
Date: 02/19/2017
Unicode strings and implicit conversions
Cross post with https://aka.ms/sqlserverteam Recently we had an interesting customer question about a...
Date: 01/24/2017
Extended per-operator level performance stats for Query Processing
Cross post with https://aka.ms/sqlserverteam Back in March we announced the availability of...
Date: 12/09/2016
Query progress: anytime, anywhere
Cross post with https://aka.ms/sqlserverteam One of the most important actions when a performance...
Date: 12/05/2016
Developers Choice: USE HINT query hints
Cross post with https://aka.ms/sqlserverteam The use of Trace Flags has always been understood as a...
Date: 11/22/2016
Developers Choice: CREATE OR ALTER
Cross post with https://aka.ms/sqlserverteam Today we are starting a new blog post series entitled...
Date: 11/18/2016
New Showplan XML properties in SSMS October Release
Cross post with https://aka.ms/sqlserverteam Back in March we announced the availability of...
Date: 11/14/2016
24HOP - Portuguese Edition 2016
Hello all, if you're a Portuguese speaker, come join me on 11/16 for a 24HOP session on "Gems to...
Date: 11/07/2016
AdaptiveIndexDefrag and Maintenance Solution moved to GitHub
Hello all, While I will continue to keep the blog updated in what relates to AID and the Maintenance...
Date: 10/19/2016
Tiger speaking at PNWSQL User Group
Next September 14 (Wednesday), at 7pm, Tiger will be presenting a session to the Pacific Northwest...
Date: 09/08/2016
Operator progress changes in LQS
Cross post with https://aka.ms/sqlserverteam EDIT (11/12/2016): With the October release of SQL...
Date: 08/22/2016
Memory grant related diagnostics
Cross post with https://aka.ms/sqlserverteam Back in March I blogged about Addressing large memory...
Date: 07/17/2016
MSSQLTIGER and May PASS Virtual Conferences
Cross post with https://aka.ms/sqlserverteam Tiger is delivering another session on an upcoming...
Date: 05/17/2016
Presenting at #SQLBits XV
I’ll be doing a two-part session at #SQLBITS on Friday: Enhancements that will make your SQL...
Date: 05/05/2016
April updates to Plan Comparison Tool
Cross post with https://aka.ms/sql_server_team With the SQL Server Management Studio April update,...
Date: 04/15/2016
Added per-operator level performance stats for Query Processing
Cross post with https://aka.ms/sqlserverteam When you are troubleshooting query performance, metrics...
Date: 03/14/2016
What’s new with SSMS Plan Comparison Tool?
Cross post with https://aka.ms/sqlserverteam With the SQL Server Management Studio February update,...
Date: 03/09/2016
Addressing large memory grant requests from optimized Nested Loops
Cross post with https://aka.ms/sqlserverteam Optimized Nested Loops (or Batch Sort) is effectively...
Date: 03/08/2016
Index Usage DMV behavior updated
Cross post with https://aka.ms/sqlserverteam Up until SQL Server 2008 R2, using index usage stats...
Date: 03/07/2016
SQL Server 2016 – Added information on TempDB Spill events – xEvents
Cross post with https://aka.ms/sqlserverteam My previous post was about new information added to...
Date: 11/02/2015
SQL Server 2016 – Added information on TempDB Spill events – Showplan
Cross post with https://aka.ms/sqlserverteam For those that have some experience analyzing query...
Date: 10/28/2015
@@VERSION and SERVERPROPERTY – What changed?
Cross post with aka.ms/sqlserverteam With the recent release of SQL Server 2014 SP1 CU3 and SQL...
Date: 10/22/2015
Comparison Tool released with latest SSMS
Cross post with aka.ms/sqlserverteam The ability to compare plans is something that a lot of people...
Date: 10/12/2015
Cardinality Estimation for Correlated Columns in SQL Server 2016
Cross post with aka.ms/sqlserverteam When we introduced the new CE back in SQL Server 2014,...
Date: 10/02/2015
Ninja Troubleshooting- User Interface freezing during SQL Server database restore.
Hello world :) To sum up, i was working with one of my customers regarding the UI (User Interface)...
Date: 07/31/2015
Building elastic and fault tolerant Data Platform solutions with Azure, SQL Server and HDInsight
If you are interested on a solution that provides elastic scale, High Availability and Disaster...
Date: 06/24/2015
When do conversions generate conversion warnings? And why are these bad?
Hello, A few days ago a colleague asked me why was he seeing implicit conversions in the execution...
Date: 11/18/2014
SQL Swiss Army Knife #15 - Handling duplicate indexes
Hello all, Part of my job is to help customers find and fix performance issues, and this post comes...
Date: 11/12/2014
Have you heard of the EPM Framework?
EPM stands for Enterprise Policy Management, and it’s a framework designed with the objective of...
Date: 09/20/2014
MDS 2012/2014: Where my soft deletes at?
In Master Data Services, a soft delete is the result of removing a member via the MDS UI or the...
Date: 09/18/2014
Too many single use plans, now what?
Hello, I’ve been asked the question in title at least twice in the past month, but the...
Date: 07/30/2014
Beam me up, Azure!
I’ve decided that my next VM (hosting SQL Server 2014) was going to be built in Azure, taking...
Date: 06/02/2014
SQL Swiss Army Knife #14 - Troubleshooting with Waits and Latches
EDIT (4/12/2017): Detailed categorization of waits; added new waits; moved scripts to Github. Hello,...
Date: 04/09/2014
SQL Swiss Army Knife #13 – Exploring the plan cache – Part 2
Hello all, This is long overdue, but here it is, the follow up on plan cache exploration queries...
Date: 03/16/2014
Using DQS with SQL Server AlwaysOn AG
Hi everyone, A couple of weeks ago I presented a session on cloud IT Pro Airlift: Infrastructure...
Date: 12/23/2013