How COVID-19 Affects Conferences
SQLBits just postponed their event, and I’m stepping out of SQL Saturday Iceland as well. I’ve had the unusual position of being a conference attendee, speaker, and sponsor, all at different times of my life, so I wanted to do a quick brain …
SQL SERVER – Reducing TempDB Recompilation with Fixed Plan
Recently, I had a very interesting situation while working with my client on the Comprehensive Database Performance Health Check. Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan.Real-World ScenarioOne of the large …
Things to Consider When SQL Server Asks for an Index
One of the things I love about SQL Server is that during query plan compilation, it takes a moment to consider whether an index would help the query you’re running. Regular blog readers will know that I make a lot of jokes about the quality of th …
T-SQL Tuesday #124: Using Query Store (and why you might not be…yet)
T-SQL Tuesday This month’s T-SQL Tuesday topic is courtesy of Tracy Boggiano and it’s related to using Query Store! Tracy asked people to write about their experience adopting Query Store (or not, if you haven’t tried it ye …
SQL SERVER Tools I Use and Recommend (Updated: March 2020)
One of the most popular questions I often receive during Comprehensive Database Performance Health Check is which are the third-party tools I use in my daily routine and I recommend them. Here is the updated list for March 2020 of all the tools which I …
Gap Analysis Using Algebra
Introduction This article shows how to solve a gaps and islands problem using simple algebra. No SQL Server loops or cursors are required for this solution. Problem Scheduling constraints occasionally require the presence of some “feature …
Analyze SQL Server Results in Excel with Conditional Formatting
The post Analyze SQL Server Results in Excel with Conditional Formatting appeared first on SQLServerCentral.
SQL SERVER – Msg 17177 – This Instance of SQL Server Has Been Using a Process ID of %s since %s (local) %s (UTC)
Recently I was looking at SQL Server ERRORLOG of one of my instances on my Azure VM. It was interesting to see and research the message mentioned in the subject. In this blog, I would share my understanding of the message “This instance of SQL Se …
Implementing Drill Through Actions in SSAS
Introduction As a Data Analyst, it is often essential that you dive deep into the visual metrics that are being summarized and displayed on the dashboards or reports to perform your analysis. To aid such an analysis, we need to be able to know all the …
How to Do Case Insensitive Search? – Interview Question of the Week #267
Question: How to Do Case Insensitive Search?Answer: This is a very interesting question. Most of the time, I receive a question about how to do case sensitive search and I have already previously blogged that in the following blog posts:How to Do Case …
SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period
One of the reasons, I love my job of SQL Server Performance Tuning Expert is that I get to learn every single day something new while working with my client on Comprehensive Database Performance Health Check. Recently I got a very unique situation wher …
SQL SERVER Management Studio – Rebuild All Indexes on Table
Today, we are going to see a very simple trick about SQL SERVER Management Studio (SSMS), where we will learn how to rebuild all indexes on the table with a single click. While I considered this as a very simple trick while demonstrating this to my e-c …
Meeting your CCPA needs with Data Classification and Masking
The post Meeting your CCPA needs with Data Classification and Masking appeared first on SQLServerCentral.
Making TRY_CAST and TRY_CONVERT Queries Faster with Indexed Computed Columns
I know this is gonna sound crazy, but let’s say you had a table where people stored all kinds of things in one column: dates, integers, file names, sale prices, file names, you name it. And let’s say your application frequently ran a query …
SQL SERVER – Count NULL Values From Column
The other day, I have received a very simple but interesting question by one of my earlier clients of Comprehensive Database Performance Health Check via email. The question was about how to count NULL values from the column.Honestly, this is a very si …