Viewing 6 posts - 1 through 6 (of 6 total)
Sometimes I use this trick ....
Create tempTable ( the same as bigTable)
then
sp_rename bigtable, secondTableName
sp_rename tempTable, bigTable
you can do it in transaction ...
after that you have bigTable empty,...
March 6, 2013 at 11:45 am
"Drop obsolete objects" <-- I have practice to rename it first into for_delete_object_name (for objects which I'm "enough" sure, that could allways be a problem) and wait "enough" time
"enough" is...
June 15, 2012 at 4:46 am
Eugene Elutin (4/17/2012)
zojan (4/17/2012)
If you want log steps of the SP_ you can use loging into log_table....
Not good option for SQL Server as there is no direct equivalent to autonomous...
April 17, 2012 at 9:06 am
If you want log steps of the SP_ you can use loging into log_table.
You can lo step (which is executed), Getdate(),...
you can add sp_name column to log more than...
April 17, 2012 at 7:53 am
Sean Lange (4/13/2012)
jzoran (4/13/2012)
April 13, 2012 at 12:06 pm
If the request is reduce time of execution from 20 min to 20 sec the only one possibility is checking indexes (missing indexes or it could be right index but...
April 13, 2012 at 11:55 am
Viewing 6 posts - 1 through 6 (of 6 total)