Can anyone share cool Scripts used for DB Administration ?

Question

Post reply

Can anyone share cool Scripts used for DB Administration ?

SqlServerLover

Ten Centuries

Points: 1348
More actions
August 13, 2010 at 5:35 pm

#226035

Hello Guys,
Can anyone be nice to me and share the scripts you use for various Databse administration purpose ?
I have some scripts which i use but different people different ideas..... more expert you are better you can extrat .
I know this website also has thousands of scripts.. but some of them are very useful but some of them are not. some of them do not even work.
Thanks in advance. I know out of millions of people in this website few are kind hearted...so i will get help...:-):-)

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

This link [/url]has almost all the scripts that a DBA ever needs.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Suresh B. SSC-Insane Points: 22986 More actions · Answer 2

Suresh B.

SSC-Insane

Points: 22986

August 15, 2010 at 10:47 pm

#1207149

This script is useful for DBAs.

jsterrett SSC-Addicted Points: 459 More actions · Answer 3

You can also try http://sqlserverpedia.com/wiki/Transact_SQL_Code_Library

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 4

Just remember... "Caveat Emptor".

Unless the code has been reviewed, tested, and approved by some authority, it could be really cruddy code or maybe even damage your data. Never use code even from sites like this one without fully testing the code on a test machine before trying the same thing on a production box.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Rick.Cornell.SME SSCrazy Eights Points: 8597 More actions · Answer 5

When all else fails try your favorite Search Engine like BING or GOOGLE! :hehe:

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 6

Wonderful resources that is constently growing:

Technet Script Center

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 7

Plenty of good scripts on the link below, especially the ones where Author = Michael Valentine Jones 😎

Script Library

http://www.sqlteam.com/forums/forum.asp?FORUM_ID=11

SqlServerLover Ten Centuries Points: 1348 More actions · Answer 8

Thanks Everyone. I appreciate your answer.

Jeff ,

Yes, you are right. I ran so many scripts from this website in our test server and our system was extremly slow.

I did not see any major reason for the slowness but there were many failure login attempts from my account and i know i did not made those.

I deleted all new procedures,views i created and sytem was alright after that. I still do not undertand why those failure login attempts were there. Thanks

mathias fatene Newbie Points: 1 More actions · Answer 9

hi,

you certainly have security policy enfocement for your logins.

Mathias

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 10

I assume you want specifics. Lots of script libraries, but here are a few I've found helpful:

Backups : http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/

Help shrink t-log: http://www.sqlservercentral.com/scripts/30026/

Monitoring http://sqlblog.com/blogs/adam_machanic/archive/2009/03/30/who-is-active-v8-40-now-with-delta-power.aspx