2017-01-30 (first published: 2017-01-26)
15,073 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)
16,064 reads
2010-09-08 (first published: 2010-09-02)
2,330 reads
2008-08-06 (first published: 2008-06-16)
2,256 reads
Blogs
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Forums
How to organize your wardrobe and make it maximum effective?
When I thought about how to organize my wardrobe, I couldn’t even think that...
How can you have a good rest?
To be honest, usually the ndb contains the amount that must be deposited. But,...
post steps for Table PARTIONING
Any one did Table partitioning in Prod, please list steps here. we have a...
Ask SSC