If the Database does not allow downtime, you're hosed with the Create CI and Drop trick. (can you imagine if the table has millions of records?)

the BEST option is to...

been there done that.

I do NOT Miss "errors and omissions insurance"

and I do NOT Miss making Collections calls.

Other than that, Self Employed route can be quite nice.

GAJ

You pretty much need a clustered index.

any reason why you dont want a ci on the table ?

Greg Jackson

yes the next step depends on what you wish to do.....

Data Architect would be a good next step

Management Positions would possibly make sense

Product Management ???

Project Management ???

Sr. DBAs might be...

I agree.

All too often I see performance problems in production environments due to RAID5 or RAID6 configurations.

You will most definately want RAID 1+0 or 0+1

It's spendy, but hey....it's a production...

On another note....

Sure you should try to determine what indexes are needed up front however, index tuning is an on going task for the skilled DBA and Architect.

Dont feel that...

Sweet Script.

I used this today to help troubleshoot some production issues.

I cleaned the script up a bit in the following ways:

1. included a "USE MSDB" statement at top because...

either make the datatypes identical (The best option IMHO) or just do a CAST in your select when you retrieve the data

SELECT

Cast(ID As BigInt) As ID

FROM

...

conceptually looks good but I'd be afraid of running out of space.

You stated that your DB is ~70GB today. How fast is it growing ?

what kind of activity is on...

Thanks for the reply.

Our system is very write intensive.

Even our Reporting sprocs do tons of writes to tempTables before writing out final results.

we are working feverishly on removing all temp...

this is great info. Thanks for the reply.

GAJ

well...I dont "Know" that the location of TempDB is the problem.

I "Suspect" that it is.

I want to be able to definitively prove if my hunch is right or wrong.

The fact...

Involving them early can reduce major problems late in the game.

If dev meetings have ZERO impact on Database, then make invite optional.

gaj

Gregory A Jackson MCSD, MCT