Today, we will see another interesting topic where the index affects the delete statement. Let us start watching the video Indexing for Delete.
Compressed Backup and Performance – SQL in Sixty Seconds #196
I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Backup and Performance
Query Store Interval Length: Choosing How Fine Your History Is
An hourly average can hide the slowdown users remember. Here is a small demo of Query Store interval length and how to choose it.
Agent Jobs Running Longer Than Usual: Finding Them in Job History
Find Agent jobs running longer than usual by decoding history durations, comparing current activity, and alerting against a baseline.
Find Missing Identity – SQL in Sixty Seconds #195
Today, we will discuss a very interesting topic about how to find missing identities from our database table. I have previously blogged.
Gaps in an Identity Column: Find Missing Identity Values
Gaps in an identity column come from deletes, rollbacks, failed inserts and the identity cache. This post finds them as ranges with LEAD, catches the tail with IDENT_CURRENT and lists single values with GENERATE_SERIES.
Using Stored Procedure in SELECT – SQL in Sixty Seconds #193
Today we are going to learn about how Using Stored Procedure in SELECT. However, the easiest method to run the stored procedure.