I have no idea when we'll get there, but I have no doubt we will, though I truely suspect we will see a return to dumb terminals and huge servers,...

We audit all user editable data. I use a trigger to simply add a complete copy of the record being inserted/updated/deleted to a duplicate (non-indexed), table. I have...

Nice article, thanks for the explanation and great examples. I'm quite tempted to change from my current auditng techniques to this as it would be much more efficient, however...

It was bound to happen, when things are tight, the squeeze is passed down, the folks at the top of the food chain are going to look out for their...

Dave provided the simplest (and best) answer for question asked, however if you are interested in exploring alternative methods of arriving at the same answer you could try:

with cte1 as...

I'm adverse to hard physical labor. I learned at a young age (by doing it) that I'd rather have a job that required difficult mental labor than physical labor...

Paul, Thanks for the example that recreates the problem in miniture and with my own tables. Quite helpful in seeing that the problem lies with the function and...

I have a work around using a temp table the returns the results I require in less than a second, though I still don't understand what is causing the problem....

Yes my original post was the estimate. I'll try to clean up some disk space (only got 15 gb free) and see if I can get it to finish...

Gail, I did read your link on how to post performance problems. Thanks for that article it was very informative, fortunately I've not had to many performance issues...

I appreciate you all taking a look. Sorry I couldn't post this last night (technical issues 🙂

I'm attaching The table/function definitions along with the query plan

I had forgotten...

After cooresponding with mcerkez88 I took his idea and implemented it using triggers. Attached is a text file that contains the DDL to create the "Audit" table, a trigger...

mcerkez88 (7/30/2010)

---

In our system we audit everything by storing a new state of table row into audit log as xml record along with the info who and when made the...

We audit select "tables". I have a generic trigger I apply to all tables of interest which simply makes a copy of an existing row before it is changed/deleted...

I found the solution in another post: http://www.sqlservercentral.com/Forums/Topic506723-357-1.aspx

Here is my implementation -

declare @FileName_ varchar(100)

declare @RestoreFile_ varchar(200)

declare @Path_ varchar(1000)

...