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
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
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
Being lazy, I usually just edit such jobs and change the owner to sa.
2004-02-17
2003-08-25
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
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hello friends. I’m new here, so if this is the wrong place for my...
Hi everyone! I've been working with a Fargate app recently and I've managed to...
Comments posted to this topic are about the item Coding Magic Values