We use snapshots extensively in development and they have been a godsend there; they have saved us untold hours. However, for our production systems we avoid snapshots except as...

Thomas Keller (6/10/2008)

---

In my case, it was necessary not only to show that a certain user ran a certain query at a certain time (as the trace would do), it...

Eric, that's a good point about 2000. Traces in SQL 2005 have been significantly improved in several ways including making them generally less expensive. I just assumed that...

Jack Corbett (6/10/2008)

---

Therein lies the rub, I think. A trace used for...

GSquared (6/10/2008)

---

DCPeterson, on the subject of a "server side trace". I'm not clear on what you mean by that. Are you talking about something outside the database, or...

Jack Corbett (6/10/2008)

---

DCPeterson (6/10/2008)

---

The most common problem I've seen when it comes to audit logs is that the requirements aren't well defined so you get something like this: "well, we...

Jack Corbett (6/10/2008)

---

This is why I did...

These were a pretty good basic overview of two of the options available. I think there is one option that was left out that offers much more flexibility than...

Sir Slicendice (5/2/2008)

---

Interesting article, but I think you (and to be fair, lots of others) have missed one of the most valuable benefits of XML:

The standardized hierarchical nature makes it...

Thanks for thinking! That was my main goal, to get people to THINK instead of just accepting what vendors were feeding us.

One quick correction if I may:...

Someguy (5/2/2008)

---

Hmnn...

By the time I'm getting here, we're on 12 pages of replies. Admitting that only a handful of people will read this far, I might as well throw in...

There's a much simpler way to do this:

select ServerUptimeInHrs = datediff(hh, Login_time, current_timestamp)

from sys.dm_exec_sessions

where session_id = 1

That gives you the hours, obviously days, minutes or whatever are just as easy...

I don't tend to make extensive use of views. Most of the time they are used to simplify query writing, or to provide an abstraction layer between users and...

No, the discussion is not "off topic" because the original article, and many of the earlier posts are informed by the pay gap myth. My posts were merely to...

Thank you, I figured I was doing something stupid like that, I just couldn't see it for anything.