Blog do Ezequiel

SQL Server Insights

We have moved!

Thanks for visiting! This blog has now been migrated to:...

Author: Pam Lahoud Date: 03/29/2019

Developer’s Choice: Hinting Query Execution model

This is a cross post with http://aka.ms/sqlserverteam Over the years you have read a number of blogs...

Author: Pedro Lopes (PL) Date: 09/22/2018

Predicate Pushdown and why should I care?

Cross post with http://aka.ms/sqlserverteam If you follow this blog, you know that in the last...

Author: Pedro Lopes (PL) Date: 07/09/2018

More Showplan enhancements – UDFs

Cross post with http://aka.ms/sqlserverteam As I mentioned on yesterday’s post, with the recent...

Author: Pedro Lopes (PL) Date: 02/21/2018

More Showplan enhancements – Row Goal

Cross post with http://aka.ms/sqlserverteam As I shared before, we have been working for over a year...

Author: Pedro Lopes (PL) Date: 02/20/2018

Perfect statistics histogram in just few steps

Cross post with http://aka.ms/sqlserverteam A similar question about statistics came to the team...

Author: Pedro Lopes (PL) Date: 11/23/2017

Making parallelism waits actionable

Cross post with http://aka.ms/sqlserverteam During PASS we announced changes to how users will be...

Author: Pedro Lopes (PL) Date: 11/13/2017

New Showplan enhancements

Cross post with http://aka.ms/sqlserverteam If you follow this blog, you have seen that in the past...

Author: Pedro Lopes (PL) Date: 11/10/2017

Persisting statistics sampling rate

Cross post with http://aka.ms/sqlserverteam When SQL Server creates or updates statistics and a...

Author: Pedro Lopes (PL) Date: 08/12/2017

New in SSMS: Searching in Showplan

Cross post with http://aka.ms/sqlserverteam Have you ever analyzed a somewhat big plan? And while...

Author: Pedro Lopes (PL) Date: 08/08/2017

New in SSMS: Performance Dashboard built-in

Cross post with http://aka.ms/sqlserverteam Back in 2007, we released the Microsoft SQL Server 2005...

Author: Pedro Lopes (PL) Date: 08/07/2017

Correlating xEvents with DMVs

Cross post with http://aka.ms/sqlserverteam Since the inception of xEvents there has been the need...

Author: Pedro Lopes (PL) Date: 08/03/2017

SQL Server 2017 Showplan enhancements

Cross post with http://aka.ms/sqlserverteam In my previous post on Easy way to get statistics...

Author: Pedro Lopes (PL) Date: 05/12/2017

New in SSMS: Query Performance Troubleshooting made easier!

Cross post with http://aka.ms/sqlserverteam The community already uses tools that can make it easier...

Author: Pedro Lopes (PL) Date: 05/03/2017

Easy way to get statistics histogram programmatically

Cross post with http://aka.ms/sqlserverteam Statistics being the building blocks on which the Query...

Author: Pedro Lopes (PL) Date: 03/24/2017

Getting more statistics information programmatically

Cross post with http://aka.ms/sqlserverteam As the building blocks which the Query Optimizer uses to...

Author: Pedro Lopes (PL) Date: 02/19/2017

Unicode strings and implicit conversions

Cross post with http://aka.ms/sqlserverteam Recently we had an interesting customer question about a...

Author: Pedro Lopes (PL) Date: 01/24/2017

Extended per-operator level performance stats for Query Processing

Cross post with http://aka.ms/sqlserverteam Back in March we announced the availability of...

Author: Pedro Lopes (PL) Date: 12/09/2016

Query progress: anytime, anywhere

Cross post with http://aka.ms/sqlserverteam One of the most important actions when a performance...

Author: Pedro Lopes (PL) Date: 12/05/2016

Developers Choice: USE HINT query hints

Cross post with http://aka.ms/sqlserverteam The use of Trace Flags has always been understood as a...

Author: Pedro Lopes (PL) Date: 11/22/2016

Developers Choice: CREATE OR ALTER

Cross post with http://aka.ms/sqlserverteam Today we are starting a new blog post series entitled...

Author: Pedro Lopes (PL) Date: 11/18/2016

New Showplan XML properties in SSMS October Release

Cross post with http://aka.ms/sqlserverteam Back in March we announced the availability of...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) Date: 09/08/2016

Operator progress changes in LQS

Cross post with http://aka.ms/sqlserverteam EDIT (11/12/2016): With the October release of SQL...

Author: Pedro Lopes (PL) Date: 08/22/2016

Cross post with http://aka.ms/sqlserverteam Back in March I blogged about Addressing large memory...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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,...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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,...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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,...

Author: Pedro Lopes (PL) 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)...

Author: Paulo Condeça 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...

Author: Paulo Condeça 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Fernando Marçal 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...

Author: Pedro Lopes (PL) 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...

Author: Fernando Marçal 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,...

Author: Pedro Lopes (PL) 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...

Author: Pedro Lopes (PL) 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...

Author: Alexandre Mendeiros Date: 12/23/2013

Next>