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
Thanks for visiting! This blog has now been migrated to:...
Date: 03/29/2019
This is a cross post with https://aka.ms/sqlserverteam Over the years you have read a number of blogs...
Date: 09/22/2018
Cross post with https://aka.ms/sqlserverteam If you follow this blog, you know that in the last...
Date: 07/09/2018
Cross post with https://aka.ms/sqlserverteam As I mentioned on yesterday’s post, with the recent...
Date: 02/21/2018
Cross post with https://aka.ms/sqlserverteam As I shared before, we have been working for over a year...
Date: 02/20/2018
Cross post with https://aka.ms/sqlserverteam A similar question about statistics came to the team...
Date: 11/23/2017
Cross post with https://aka.ms/sqlserverteam During PASS we announced changes to how users will be...
Date: 11/13/2017
Cross post with https://aka.ms/sqlserverteam If you follow this blog, you have seen that in the past...
Date: 11/10/2017
Cross post with https://aka.ms/sqlserverteam When SQL Server creates or updates statistics and a...
Date: 08/12/2017
Cross post with https://aka.ms/sqlserverteam Have you ever analyzed a somewhat big plan? And while...
Date: 08/08/2017
Cross post with https://aka.ms/sqlserverteam Back in 2007, we released the Microsoft SQL Server 2005...
Date: 08/07/2017
Cross post with https://aka.ms/sqlserverteam Since the inception of xEvents there has been the need...
Date: 08/03/2017
Cross post with https://aka.ms/sqlserverteam In my previous post on Easy way to get statistics...
Date: 05/12/2017
Cross post with https://aka.ms/sqlserverteam The community already uses tools that can make it easier...
Date: 05/03/2017
Cross post with https://aka.ms/sqlserverteam Statistics being the building blocks on which the Query...
Date: 03/24/2017
Cross post with https://aka.ms/sqlserverteam As the building blocks which the Query Optimizer uses to...
Date: 02/19/2017
Cross post with https://aka.ms/sqlserverteam Recently we had an interesting customer question about a...
Date: 01/24/2017
Cross post with https://aka.ms/sqlserverteam Back in March we announced the availability of...
Date: 12/09/2016
Cross post with https://aka.ms/sqlserverteam One of the most important actions when a performance...
Date: 12/05/2016
Cross post with https://aka.ms/sqlserverteam The use of Trace Flags has always been understood as a...
Date: 11/22/2016
Cross post with https://aka.ms/sqlserverteam Today we are starting a new blog post series entitled...
Date: 11/18/2016
Cross post with https://aka.ms/sqlserverteam Back in March we announced the availability of...
Date: 11/14/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
Hello all, While I will continue to keep the blog updated in what relates to AID and the Maintenance...
Date: 10/19/2016
Next September 14 (Wednesday), at 7pm, Tiger will be presenting a session to the Pacific Northwest...
Date: 09/08/2016
Cross post with https://aka.ms/sqlserverteam EDIT (11/12/2016): With the October release of SQL...
Date: 08/22/2016
Cross post with https://aka.ms/sqlserverteam Back in March I blogged about Addressing large memory...
Date: 07/17/2016
Cross post with https://aka.ms/sqlserverteam Tiger is delivering another session on an upcoming...
Date: 05/17/2016
I’ll be doing a two-part session at #SQLBITS on Friday: Enhancements that will make your SQL...
Date: 05/05/2016
Cross post with https://aka.ms/sql_server_team With the SQL Server Management Studio April update,...
Date: 04/15/2016
Cross post with https://aka.ms/sqlserverteam When you are troubleshooting query performance, metrics...
Date: 03/14/2016
Cross post with https://aka.ms/sqlserverteam With the SQL Server Management Studio February update,...
Date: 03/09/2016
Cross post with https://aka.ms/sqlserverteam Optimized Nested Loops (or Batch Sort) is effectively...
Date: 03/08/2016
Cross post with https://aka.ms/sqlserverteam Up until SQL Server 2008 R2, using index usage stats...
Date: 03/07/2016
Cross post with https://aka.ms/sqlserverteam My previous post was about new information added to...
Date: 11/02/2015
Cross post with https://aka.ms/sqlserverteam For those that have some experience analyzing query...
Date: 10/28/2015
Cross post with aka.ms/sqlserverteam With the recent release of SQL Server 2014 SP1 CU3 and SQL...
Date: 10/22/2015
Cross post with aka.ms/sqlserverteam The ability to compare plans is something that a lot of people...
Date: 10/12/2015
Cross post with aka.ms/sqlserverteam When we introduced the new CE back in SQL Server 2014,...
Date: 10/02/2015
Hello world :) To sum up, i was working with one of my customers regarding the UI (User Interface)...
Date: 07/31/2015
If you are interested on a solution that provides elastic scale, High Availability and Disaster...
Date: 06/24/2015
Hello, A few days ago a colleague asked me why was he seeing implicit conversions in the execution...
Date: 11/18/2014
Hello all, Part of my job is to help customers find and fix performance issues, and this post comes...
Date: 11/12/2014
EPM stands for Enterprise Policy Management, and it’s a framework designed with the objective of...
Date: 09/20/2014
In Master Data Services, a soft delete is the result of removing a member via the MDS UI or the...
Date: 09/18/2014
Hello, I’ve been asked the question in title at least twice in the past month, but the...
Date: 07/30/2014
I’ve decided that my next VM (hosting SQL Server 2014) was going to be built in Azure, taking...
Date: 06/02/2014
EDIT (4/12/2017): Detailed categorization of waits; added new waits; moved scripts to Github. Hello,...
Date: 04/09/2014
Hello all, This is long overdue, but here it is, the follow up on plan cache exploration queries...
Date: 03/16/2014
Hi everyone, A couple of weeks ago I presented a session on cloud IT Pro Airlift: Infrastructure...
Date: 12/23/2013