A Self-Tuning Fill Factor Technique for SQL Server – Part 2
Introduction Fill Factor is a parameter most of us have ignored because there is no definitive way to calculate what the correct value should be. Part 1 of this series describes a new technique to dynamically determine index fill factors for all indexe …
SQLintersection Fall 2019
As we head towards our SQLintersection Fall 2019 in November (our 14th show), I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear over and over is t …
DBA Training Plan 13: Why Do Cached Plans Go Bad?
It’s a little bit of a trick question: what could make a good query plan turn bad? In the last episode, we used sp_BlitzCache to spot the most resource-intensive, longest-running query plans in your server’s cache. Go run those queries agai …
SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX
It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients on Comprehensive Database Performance Health Check. The other week, while going over the maintena …
Glenn’s Tech Insights For August 25, 2019
(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …
4 Pillars of SQL Server Monitoring
The post 4 Pillars of SQL Server Monitoring appeared first on SQLServerCentral.
Azure Stretch Database, Part I: Getting Going
Whenever you see Microsoft demonstrate any of its nifty new technologies, you would think they are so easy that a lightly-trained hamster could fire them all up in five minutes. It never turns out this way in real life. Microsoft purposefully builds de …
How to Use a CASE Statement in the WHERE Clause? – Interview Question of the Week #239
Question: How to Use a CASE statement in the WHERE Clause?Answer: First of all – CASE is not a statement but rather an expression so the right question should be How to Use a CASE expression in the WHERE Clause? In any case, let us see the answer …
SQL SERVER – Identify Read Heavy Workload or Write Heavy Workload Type by Counters
The other day I had a very interesting experience with one of my client of Comprehensive Database Performance Health Check. It is a standard process of the health check to identify the workload of the server before making the necessary changes. Let us …
Scaling SQL Monitor with your growing estate
The post Scaling SQL Monitor with your growing estate appeared first on SQLServerCentral.
Research Paper Week: Constant Time Recovery in Azure SQL DB
Let’s finish up Research Paper Week with something we’re all going to need to read over the next year or two. I know, it says Azure SQL DB, but you boxed-product folks will be interested in this one too: Constant Time Recovery in Azure …
SQL SERVER – PRINT Statement and Format of Date Datatype
I have said many times that I love my job because every single day I find something new to learn and explore. Recently while working on Comprehensive Database Performance Health Check, we took a 5 minutes coffee break and during that short time, one of …
Improve Data Quality for SQL Server Reporting
The post Improve Data Quality for SQL Server Reporting appeared first on SQLServerCentral.
Research Paper Week: In-Memory Multi-Version Concurrency Control
If you’ve been doing performance tuning for several years, or graduated from my Mastering Server Tuning class, you’ve come across Read Committed Snapshot Isolation, aka RCSI, aka multi-version concurrency control, aka MVCC, aka optimistic c …
SQL SERVER – 3 Different Ways to Explore Actual Execution Plans
In this blog post, we will explore 3 different ways to explore Actual Execution Plans. During the recent Comprehensive Database Performance Health Check, I had discussed this with clients.In SQL Server there are three primary ways you can see the actua …