SQL SERVER – SSMS 17.7 Observation – Two Miscellaneous Category in Database Property Options
First of all this observation is only applicable if you are using SSMS 17.7 build. It was very interesting to me that I was able to find two Miscellaneous categories in Database Property Option for SQL Server. Please note the version of SQL Server …
New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems
Continuing our series of live, online classes, Erin, Jonathan, and Kimberly will be delivering their new IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems in October! The class w …
New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning
Continuing our series of live, online classes, Kimberly will be delivering her new IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning in October! The class will be delivered live via WebEx …
New live online training class in August: Planning and Implementing an Upgrade/Migration to SQL Server 2017
Continuing our series of live, online classes, Glenn will be delivering his new IEPUM2017: Immersion Event on Planning and Implementing an Upgrade/Migration to SQL Server 2017 in August! The class will be delivered live via Web …
Building SQL ConstantCare®: Why People Aren’t Using Query Store
When Microsoft first talked about Query Store, I was wildly excited. It’s basically a black box flight data recorder for SQL Server, tracking which queries run over time, how much work they do, and how their execution plans change. And then it ca …
SQL Prompt Safety Net Features for Developers
Phil Factor describes a few common mishaps that everyone working in SSMS will have experienced a couple of times, and how SQL Prompt “Tab Magic” (now more prosaically called Tab Color and Tab History) provides ‘insurance’ agains …
Improving SQL Server 2016 Large Database Performance
This article aims to save you days or weeks of troubleshooting when using SQL Server 2016 for large databases
SQL SERVER – How to Fix CONVERT_IMPLICIT Warnings?
One of the biggest issues I see with at various of my customer who signed up at Comprehensive Database Performance Health Check is about CONVERT_IMPLICIT. As soon as I demonstrate my customer that they are not getting performance due to …
[Video] Office Hours 2018/6/6 (With Transcriptions)
This week, Brent, Erik, Tara, and Richie discuss index maintenance, stats updates, the acquisition of GitHub, using linked servers to move tables across, talking to developers as a DBA, the best cloud option, setting the number of tempdb files, and the …
How to Find Cardinality or Uniqueness for any Column? – Interview Question of the Week #177
Question: How to Find Cardinality or Uniqueness for any Column? Answer: The question was actually came up during my training SQL Server Performance Tuning Practical Workshop, while I was explaining various concepts related to cardinality esti …
SQL SERVER – Script to Identify Memory Used By Each Database
During the last SQL Server Performance Tuning Practical Workshop, I was asked a very interesting question by an attendee. The question goes like if there is any script available which users can use and figure out if how much memory used by each of …
Announcing a Very Special #SQLFamily Webcast with Dr. David DeWitt
On Thursday, June 28th, at noon Eastern (see in your local time zone), join us for a very special presentation: SQL Query Optimization. Why is it so hard to get right? The first paper on cost-based query optimization was published in 1979 by Patricia S …
Demoing Latch Waits with Stupid Tricks
Say you’ve got PAGELATCH_UP or PAGELATCH_EX waits, and you’re wondering what might be causing ’em. I’m going to keep the brutally simple approach of building a stored procedure to simply dump hard-coded values into a table at hi …
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 3
In recent past, I was assisting a client in installing SQL Server clustered instance in a Windows Cluster. There were many errors encountered and I learned a lot from this experience. In this blog, we would learn about Microsoft Cluster Service (MSCS) …
How Table Variables Mess With Parallelism
This Is A Parallel Query Hi There This Is A Temp Table CREATE TABLE #Posts (OwnerUserId INT); This Is A Parallel Insert Into A Temp Table Sort of asterisk (The Insert isn’t parallel, but the part of the plan leading up to it is) This Is A Table V …