Easy way to get statistics histogram programmatically

Cross post with http://aka.ms/sqlserverteam Statistics being the building blocks on which the Query Optimizer reasons to compile a good enough plan to resolve queries, it’s very common that anyone doing query performance troubleshooting needs to use DBCC SHOW_STATISTICS to understand how statistics are being used, and how accurately they represent data distribution. Let’s see how…


Getting more statistics information programmatically

Cross post with http://aka.ms/sqlserverteam As the building blocks which the Query Optimizer uses to know data distribution on tables, statistics are one of the key aspects in calculating a good enough plan to read data. So, when engaging in query performance troubleshooting, information about statistics is something you need to look at. Let’s say we need…

0

Unicode strings and implicit conversions

Cross post with http://aka.ms/sqlserverteam Recently we had an interesting customer question about a seemingly strange behavior (and perhaps not widely known) on implicit conversions to Unicode. Imagine you declare a non-unicode string variable, and when concatenating strings that seem to fit the variable declaration, you get a result that is trimmed, although the sum of…


Query progress: anytime, anywhere

Cross post with http://aka.ms/sqlserverteam One of the most important actions when a performance issue hits, is to get precise understanding on the workload that’s executing and how resource usage is being driven. The actual execution plan is an invaluable tool for this purpose. Query completion is a prerequisite for the availability of an actual query…


Developers Choice: USE HINT query hints

Cross post with http://aka.ms/sqlserverteam The use of Trace Flags has always been understood as a sort of ‘hack’, and a solution that is hard to manage and sometimes understand (namely because it depends on a number). Over the years, users have seen several knobs added to SQL Server to influence the Query Optimizer. These trace…

0

Developers Choice: CREATE OR ALTER

Cross post with http://aka.ms/sqlserverteam Today we are starting a new blog post series entitled “Developers Choice”. In the first few posts we will be focusing on SQL Server 2016 SP1 enhancements that focus on the developer community, including all developer DBA’s. Following in the same reasoning of simplifying DDL statements that was started by the…

0

New Showplan XML properties in SSMS October Release

Cross post with http://aka.ms/sqlserverteam Back in March we announced the availability of per-operator level performance stats for Query Processing (exposed in Showplan XML) with SQL Server 2014 SP2 and SQL Server 2016. However, SQL Server Management Studio (SSMS) did not expose this information, and so users had to look in the Showplan XML, in the…

2

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 help you troubleshoot query performance”. Starts at 21h GMT or 19h BR. Description: SQL Server 2012 Service Pack 3, SQL Server 2014 Service Pack 2 and SQL Server 2016 introduced enhancements to support execution plan analysis. Join…


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 Solution, all files have moved to GitHub as part of the Tiger Toolbox (http://github.com/Microsoft/tigertoolbox), for easier management and access. Also, it’s easier submit suggestions or bugs, and to keep up with any updates by subscribing to any changes,…


Tiger speaking at PNWSQL User Group

Next September 14 (Wednesday), at 7pm, Tiger will be presenting a session to the Pacific Northwest SQL Server Users Group (PNWSQL). If you’re around Redmond, please join us. Session Title: Gems to help you troubleshoot query performance Session Description: SQL Server 2012 Service Pack 3, SQL Server 2014 Service Pack 2 and SQL Server 2016…

0