Whether it’s in our personal lives or the professional one, we do have checklists for certain tasks. On the professional level, it can be purely technical like SQL Server...
2020-09-03
16 reads
SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box...
2020-09-02
26 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-02
11 reads
The Call for Speakers for the 2020 Fall edition of GroupBy is open, but it closes in just 3 days! We’re currently using Sessionize to help us organize this...
2020-09-02
45 reads
Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....
2020-09-02 (first published: 2020-08-25)
581 reads
Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest because one of the...
2020-09-02
21 reads
Did you know it is possible for SQL Server Agent to alert you of problems if something goes haywire with your Agent? Have you ever had an issue with...
2020-09-02 (first published: 2020-08-25)
400 reads
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case. After creating Azure SQL Databases...
2020-09-01 (first published: 2020-08-21)
553 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-01
14 reads
I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast...
2020-09-01 (first published: 2020-08-20)
410 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
I need to delete rows from both the temporal main and history tables. The...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers