Please note: year old solved thread.

He did run that exact command, the results are in the third post in this very thread. If you insist on bumping every single corruption-related...

Please note: 6 year old thread (and last post fairly irrelevant anyway)

Option with a unique index. This assumes you're OK adding an extra column to the table. It's computed, so no storage, but you can't insert into it or update it.

CREATE...

You need an update trigger as well...

Have a read through this:

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

There's workarounds, they're sometimes a pain

Are there any column(s) that are guaranteed unique in that table? Can you add an identity column?

To be honest, rather don't.

What you can do is insert your logging records into a table variable and then insert the contents of the table variable into the permanent logging...

Annoyingly hard in SQL 2005, trivial in SQL 2008. 2005 doesn't have filtered indexes

Is the ID column unique? The pk?

Be careful with that. In the stats time output, some times are reported twice. The site adds them all up without deduping.

I know, because I used...

Well...

skaggs.andrew (5/14/2014)

---

Thanks for the response GilaMonster. Would you by any chance know of any article that could help me through this process? I have read about creating the...

You can partition an existing table. Not by adding partitions to it, but by rebuilding the clustered index onto a partition scheme. This will take as long as rebuilding the...

No, that would be silly. Dynamic SQL works excellently when...

I prefer splitting it into two procedures. Gives stable execution plans, doesn't need the extra CPU of recompiling on every execution.

http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/

Make sure that your Management Studio is patched to the same level as the server is.