Script to check whats hogging the system
This script takes 2 samples over a 10 second period to identify what spids are using most resources. It's probably not 100% accurate but it's helped me out a few times.
2003-05-15
512 reads
Blogs
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Monday Monitor Tips: Using the PowerShell API
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Forums
SSMS gets very messy
At work we have quite a few databases that I'm frequently browsing. This is...
restore db as db_copy. resolve hardcoded references within procedures to db.
So I backup & restore db as db_copy. within both there is a proc...
Transpose sql table rows into columns
I want to transpose sql table rows to columns. I have written a query...
Question of the Day
Sparse Column Defaults
What are the restrictions for defaults on columns declared as sparse?
See possible answers