We use a script which reorgs between 10-30% fragmentation and rebuilds at >30% fragmentation

I think it is from TechNet...dont know anymore but it is a script i can read and...

i would like to use a procedure which backups all databases except those in a exclusion list but i dont know how to do this + onlinecheck (like i wrote,...

the space is only needed for the reorgs, not while running productive (no auto expanding...

i liked this idea but i think i have to do one backup job for each database and i dont like to do to much "parallel" backups but still want...

i would like to do a index reorg after or before backup and in general i like the option to run commands on the machine which holds the database online...

Yep, thanks

BEGIN/END fixed the first flaw....but not the "USE" flaw for dynamic SQL i have to read much i think...saw a few articles about it ( i am not very...

or should i run all on a large array (raid 50)?

no one can give a hint on this? someone must have an opinion on this 🙂

ms sql 2008 r2 is the next release...its gone last week rtm (or 2 weeks ago?)

releasdate is the 6th may...

bteraberry (4/22/2010)

---

How many IO channels do you have?

What kind of database are you expecting to run (OLTP/OLAP/hybrid)?

How many transactions per second?

How critical is your data ... how many seconds/minutes/hours can...