SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Takes Query Plan Analysis and Performance Monitoring to a New Level

Using sp_MSForEachDB With A Filter

A short tutorial on how to execute sp_MSForEachDB on selected databases only.

Duration:
2 mins 14 secs
Skill Level:
100
Rating:
3.66 out of 5
Publish Date:
November 20, 2009
Using sp_MSForEachDB With A Filter You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Feodor Georgiev
Schooled and worked as a .NET developer / DBA in the USA, currently working as a DBA in the Nordic countries at sqlservice.se.

References

There are no downloads or recommended reading links for this video

Comments
Robert McCormick on 11/30/2009
It's always nice to have a message at the end on where to get more information related to the current topic.

Rod Sarbo on 11/30/2009
One more example that performed a useful function would have been great.

Unknown Unknown on 11/30/2009
new to me. great.

Johs on 11/30/2009
Would like to see maintainence script demo

Feodor Georgiev on 12/1/2009
Thank you for your comments! And once again, as mentioned in the video, it is much better to use SSIS for similar tasks.

Feodor Georgiev on 12/1/2009
@Robert: since this is undocumented procedure, the information is scarce and all is up to our imagination.

rajani on 12/1/2009
hi

Jonathan on 12/1/2009
Cannot easily read the TSQL

Leandro on 12/1/2009
good video.

Patrice Rasche on 12/1/2009
It was very difficult to see the commands being executed. It could also have benefited from an explanation of the execution syntax.

D151BB6B9F on 12/1/2009
text hard to read

Jim Orten on 12/1/2009
the syntax was hard to see

Ron Sissons on 3/16/2010
Why isn't there a link to copy the code. It's very hard to read.

Jaime Maccou on 10/18/2010
It has made deploying scripts and updates across multipleand similar databases much easier.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions