SQL Server Missing Indexes Feature and Trace Flag 2392
Background Since the SQL Server 2005 release, SQL Server has had the default ability to collect metrics about what the query optimizer thinks are “missing”
Background Since the SQL Server 2005 release, SQL Server has had the default ability to collect metrics about what the query optimizer thinks are “missing”
This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. There is also
As of December 9, 2019, there have been eighteen Cumulative Updates (CU) for SQL Server 2017. There have been a large number of hotfixes in
On November 28, 2017, Microsoft released SQL Server 2017 CU2, which is build 14.0.3008.27. I count 33 hotfixes in this CU. What is interesting is
Lenovo has submitted the two most recent TPC-E OLTP benchmark results, both using SQL Server 2017 running on Windows Server 2016 Standard Edition, using 28-core
This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I often make
On October 24, 2017, Microsoft released SQL Server 2017 Cumulative Update 1, which is Build 14.0.3006.16. This CU has 68 hot fixes by my count,
This month, I have added a set of diagnostic queries for Azure SQL Database. These are very much a work in progress, and they will
Microsoft has announced a pretty big change for how they are going to service SQL Server, starting with SQL Server 2017. I am very much
On September 1, 2017, Dropbox turned off the sharing feature that I was previously using to host these scripts, which broke hundreds of existing links
On August 30, 2017, Intel released their new Intel Xeon Processor W Family of one-socket workstation processors (hence the W) based on the Skylake-SP Xeon
Another useful, if somewhat complicated, free tool from Microsoft is the Database Experimentation Assistant (DEA). Microsoft released DEA version 2.1 on July 25, 2017, with
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.