Thanks.  That's pretty much what I figured. 

This is probably the first thing I haven't been able to implement that I could do with Oracle. 🙂  They had "Resource Groups" ...

Another big reason for using Temp tables is to help prevent blocking and deadlock situations along with data that you need to reference multiple times throughout the code. 

Since rows...

I suspect that you are used to the same behavior that exists in Oracle for transactions.  SQL Server blocks READS.  Oracle does not.

Now you are posting to the 2005 admin...

I am confused.  You have two different issues here.  How are they related. 

1) Can't backup because the database is offline

2) Can't enable/disable Fulltext indexes on the database.

What exactly is...

You did some "Column Value Changes". 

Did the statement start with an "ALTER" or an "UPDATE"  Or did you just use the GUI?

I am assuming that you are asking to do nothing more than add

You can loop through all the table names.

SELECT

'alter table '...

First you need to make sure that all temp files are the EXACT same size.  If any one is not the same size, then it will cause issues.  That is...

It IS Oracle SQL. 

Moosamca,

As for the Cursors, their options and usage is very different in SQL Server vs Oracle, so any suggestions/comments from this group will in most cases...

Tracey,

You didn't setup the TEMPDB as specified(WITHOUT AUTOGROW).  Did you enable the 1118 trace? 

I agree with Jeff, you still have some options, but at least in this case,...

Sorry homebrew01, but I have to do this.  "I didn't do anything... But now it doesn't work"    I just hear that so often. ...

Subu,

The explanation is fine.  I am not sure that it can be written clearer.  I feel the issue is more your knowledge of English. 

"Tuning" as it implies is just...

Few things.  25%?  Seems that you are NOT parallelizing the query.  Not sure why, but I would actually expect it to spike HIGHER!  Has the time at least shortened?  You...

I came across a FEW instances where performance was negatively impacted, but I also came across instances where it was improved.  There are a lot of steps that are to...

It's been a while since I have done this type of thing.  You are probably better off posting this to a PC Admin group.  I am sure you can automate...

Noeld, why do you feel the OP should not be using Trace 3604.  I understand that trace as the option to send dbcc output to the console.  Am I mistaken,...