DELETE TOP x rows with an ORDER BY
This was an interesting question that I was asked yesterday and something that I’d never really thought of before. Can you delete the top x number of rows based...
2022-09-30 (first published: 2022-09-15)
713 reads
Attach All SQL Datafiles in a Directory
Have you ever had the need to attach a large number of database in one go? There’s no way to attach multiple databases in SSMS or via script, so...
2022-08-24 (first published: 2022-08-15)
235 reads
Opening your SQL Backup Folder using Powershell
Sometimes I find remembering where a particular server sends its backups to a nightmare. You might have servers backing up to different locations, you might have different locations for...
2022-06-16
17 reads
Resource Hog! What’s my busiest database?
Imagine that we’re seeing very heavy load on our SQL server, be it CPU or IO and we need to find out which database is the driver. I’m sure...
2022-05-11 (first published: 2022-05-03)
500 reads
BlitzBlockingChain, Getting Blocking Chains from sp_BlitzWho
I’m going to assume that most people will have at least heard of Brent Ozar’s brilliant First Responder Kit. If you haven’t then you’ve been missing out on some...
2022-02-09
47 reads
Which Processes are waiting on a Spinlock?
Spinlock contention is always a real headache to deal with. I recently saw an issue when spinlock contention on SOS_CACHESTORE was making the server virtually unresponsive. The issue was...
2021-11-15 (first published: 2021-11-03)
274 reads
External Temp Tables Preventing Plan Reuse in Stored Procedures
Here’s an interesting issue that recently came up. We were seeing very high compilations and recompilations on a server to the point that it started causing us some very...
2021-10-29 (first published: 2021-10-19)
306 reads
sp_RestoreScript 1.9 – a dirty little bug squished!
It look like we had a little bug in sp_RestoreScript that was putting a rogue 0 after the backup file name. That’s now been fixed in 1.9. For information...
2021-09-16
24 reads
My Application is Getting SQL Timeout Errors, But What Query is the Problem?
This is something that comes up time and time again. A developer or member of the service desk comes up to me and says “SQL’s timing out, you see...
2021-07-27
36 reads
Inspector V2.6 now available
As always the code can be found here in our github repoWe updated our sample report here We forgot to mention V2.5! We added the ability to add Thresholds...
2021-07-23
78 reads
Blogs
Restore HEADERONLY and FILELISTONLY
By gbargsley
Good day reader. This post is coming to you from a busy week in...
DevOps From Redgate
In a few weeks at the PASS Data Community Summit, I’ll be joining several...
Daily Coping 4 Oct
By Steve Jones
Today’s coping tip is to free up time by canceling any unnecessary plans. I....
Forums
Bệnh thủy đậu: Nguyên nhân, triệu chứng, biến chứng và cách điều trị
Bệnh thủy đậu là bệnh lành tính, không có triệu chứng nặng nề ngoài...
Where to Buy Sugilite Gemstone for Spiritual healing powers
Sugilite Gemstone Bertoua Savanna Local Miners (BSLMgold), Sugilite is one of the major love...
How to buy diseased free Ox/Cow Cattle Gallstone
Bertoua Savanna Local Miners (BSLMgold) After extracting the gallstones from the cattle's intestines they...
Ask SSC