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,...

"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...

Eugene Elutin (4/17/2012)

---

Not good option for SQL Server as there is no direct equivalent to autonomous...

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...

Sean Lange (4/13/2012)

---

jzoran (4/13/2012)

---

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...

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...