Blog do Ezequiel
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