Viewing 7 posts - 1 through 7 (of 7 total)
opc.three (3/27/2012)
ALTER INDEX index_name ON schema_name.table_name DISABLE ;-- Rebuilding the index re-enables it
ALTER INDEX index_name ON schema_name.table_name REBUILD;
How long should disable and rebuild take? In SSMS, they appear to...
March 28, 2012 at 11:27 am
Right. I was hoping for a "WITHOUT" or "IGNORE" kind of option (Google showed me that MySQL has an IGNORE option). That would let me more directly compare...
March 27, 2012 at 2:13 pm
How about this?
select col1, col2 from table1
except
select null, null
November 1, 2011 at 11:38 am
Currently the tables run around 100MB. As we add additional channels this may grow to as much as 500MB.
One other plus for the process is that it leaves the...
June 2, 2011 at 8:45 am
Thanks. There will be some minor updating of the operational tables. The reload/update work tables step would ensure that the work tables are in the same state as...
June 1, 2011 at 9:03 pm
Sorry, I didn't read your original post well enough. You were asking if the internal rollback would cause the external transaction to rollback as well. As you...
January 28, 2010 at 11:08 am
Books Online: Nested Transactions
Committing inner transactions is ignored by Microsoft® SQL Server™. The transaction is either committed or rolled back based on the action taken at the end of the...
January 28, 2010 at 9:45 am
Viewing 7 posts - 1 through 7 (of 7 total)