Find Queries Using a Key Lookup Operator
While teaching about Extended Events and Execution Plans last week, Jason, one of the people in the class, asked: Is there a way in Extended Events to find queries...
2021-06-14
22 reads
Find Queries Using a Key Lookup Operator
While teaching about Extended Events and Execution Plans last week, Jason, one of the people in the class, asked: Is there a way in Extended Events to find queries...
2021-06-23 (first published: 2021-06-14)
475 reads
Daily Coping 14 Jun 2021
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...
2021-06-14
28 reads
Using SQL Compare for One Procedure
A customer recently was concerned about the time to run SQL Compare for a large database. They were synching with the command line, but at times they want to...
2021-06-25 (first published: 2021-06-11)
449 reads
Daily Coping 11 June 2021
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...
2021-06-11
33 reads
Azure SQL Database – Secondary Database and Tiers
On the theme of failover groups let’s do a quick recap on my environment. As shown below you can see the secondary database server called spacesql in West Europe....
2021-06-11
111 reads
Daily Coping 10 June 2021
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...
2021-06-10
41 reads
CROSS vs OUTER APPLY
I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER ... Continue reading
2021-06-21 (first published: 2021-06-10)
1,426 reads
Setting up a Full Text Index–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a question recently on Full Text...
2021-06-18 (first published: 2021-06-09)
268 reads
Setting DebugPreference for Testing–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was working on a PoSh script recently...
2021-06-09
58 reads
Blogs
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers