Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am a fresh DBA just being promoted, I am looking for few good sites which constains T-sql Scripts for DBA tasks. Is there a common place from where you can get a collection scripts to perform operation like tuning, re-indexing, DMV, restore, mirror etc.

regards Thanks for listening

share|improve this question

closed as off-topic by Jon Seigel, Mark Storey-Smith, Michael - sqlbot, Paul White, Mat Jul 31 '13 at 4:51

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Jon Seigel, Mark Storey-Smith, Michael - sqlbot, Paul White, Mat
If this question can be reworded to fit the rules in the help center, please edit the question.

3 Answers 3

This might be a good start: http://www.sqlservercentral.com/Scripts/

share|improve this answer

I tend to favor Google or Bing as my script repository.

A few folks also have dedicated scripts that are used for mutliple things when it comes to DBA tasks. One is Adam Machanic and his sp_whoisactive. Then there is Ola Hallengren and his maitenance script. Both of these are probably the most used tools a SQL Server DBA can have available. They are both kept up-to-date with each release of SQL Server as well.

share|improve this answer

Another good place would be SQLServerPedia's TSQL Library (now migrated to a new domain).

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.