2017-01-30 (first published: 2017-01-26)
5,543 reads
sp_msforeachdb
sp_msforeachdb: Improving on an Undocumented Stored Procedure
Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!
2016-04-15 (first published: 2014-12-01)
13,766 reads
2010-09-08 (first published: 2010-09-02)
2,273 reads
2008-08-06 (first published: 2008-06-16)
1,533 reads
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
Needed to find all possible Dates Overlaps from a single Table
Hi, I have the following Episode table example: Where DischDate = "2020-02-20" means - client hasn't...
Optimize Cursor
I inherited this script that has a cursor and I know this query can...
Unable to add secondary node existing node due to DCOM is unavaialble
Dear Team, This is Naveen, Hope all are doing well. I need emergency help...
Ask SSC