Yes you're right but you're asking two questions really - I suspect using dts to recreate the tables will take longer then adding the indexes in place.

Having done this a...

You can't use the /3gb switch with sql standard - you need enterprise edition.

OK I'll ask what I always ask - big drop in performance - do you see this...

Another nice article Steve, you have a knack of picking interesting topics that provoke interest.

I worry when it seems that triggers are seen as the obvious way to resolve problems....

btw HT is allegedly correctly supported in w2k3, although I never had problems with w2k.

Yup - I understand waits - why are you posting , do you have a performance problem or do you think you have a problem after looking at wait stats?...

whilst i appreciate your request, and as I often say everyone has to start somewhere, if you're asking this question you're probably not the best person to do the job!

The...

I usually go for detach attach as one of the easiest ways, assuming I don't have lite speed to hand.

I think you'll find dts is the slowest method to...

with reagrd to dbcc and parallelism - ent edition is optimised to use multiple threads with dbcc commands - limiting the procs is akin to going back to std edition.

Agreed, iMail  ( smtp ) mail is better. You need an outlook client install to match your or setup for sql 2005 service account.

if it ain't broke don't fix it

This is the query which shows parallelism in the query plan? You should be able to see it. Just add a maxdop=1 hint in the query, this will stop the...

I'm intrigued to understand how a null varchar column can save space by placing it in another table.

sorry I typed horizontal in place of vertical in my first post .....

sounds strange to me .. you can alias an instance to a non instance name - had to do this with some third party apps - this allows connectivity by...

I thought 2005 allowed non sysadmins to use profiler, if that's the case then you would only be able to trace against databases you have access to, sure it's in...

sounds to me that your logic is flawed - try drawing a process flow diagram for your RFI to see if it makes sense.