sp_MSforeachtable:Add SQL objects to multiple database on a server.
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
652 reads
sp_msforeachtable
Finding no. of Rows in all tables of a datbase in one line of script
Consider you have 100+ tables in your database, you want to find a quick way to find no. of rows in each table
2011-01-11 (first published: 2010-12-22)
2,448 reads
RE: Intermittent Error on SQL Server Agent:[SQLSTATE 42000] (Error 8198))
Being lazy, I usually just edit such jobs and change the owner to sa.
2004-02-17
2003-08-25
RE: Update Query and Joins in EM vs. Query Analyser
Here's one argument against it, for devil's advocate sake. Sometimes, when doing performance tuning there are multiple ways to refine a particular query that can lead to different execution plans. In Query By Example, how would these VERY different statements be represented? : -- LEFT JOIN syntax will do a -- MERGE JOIN if indexed […]
2003-07-24
1 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Do entry-level cloud positions exist?
Hello friends. I’m new here, so if this is the wrong place for my...
Configuring Fargate task duration
Hi everyone! I've been working with a Fargate app recently and I've managed to...
Coding Magic Values
Comments posted to this topic are about the item Coding Magic Values
Ask SSC