Have you tried playing with fn_dblog (or ::fn_dblog)?

For log shipping, perhaps cut over to a manual agent job methodology, and have your "up to date" table updated as part and...

RBarryYoung (9/15/2010)

---

Nadrek (9/13/2010)

---

Jeff Moden (9/12/2010)

---

Be very careful about the functionality of the procedure as your procedure should return the same results after tuning as before. It is not enough that...

Jeff Moden (9/12/2010)

---

Be very careful about the functionality of the procedure as your procedure should return the same results after tuning as before. It is not enough that SSMS is...

+1 to the prior poster.

I use multiple instances to use one physical machine and OSE (Operating System Environment) to serve up multiple copies of "the same" application database for different...

Same here; but I've...

I believe that the true beginner's tuning guide boils down to:

A) Pop open Profiler with CPU, Reads, Writes, and Duration on the SQL:BatchCompleted event filtered for the SPID of your...

Nice overview; I'd like to encourage the addition of looking at SQL Profiler CPU, Reads, Writes, and Duration columns on SQL:BatchCompleted events.

Not only do these show aggregates, if you do...

Revenant (9/7/2010)

---

The correct way is to celebrate a Feb 29th birthday on the 28th, that's how the Roman (Catholic) calendar does it. In fact, it is not the 29th...

sku370870 (9/7/2010)

---

I'm sure lots of people would like to know exactly what needs to be done to prevent SQL injection.

I generally build web apps. For my part I:

Prevent anyone from...

For extra credit, first define your Leap Day Baby rule, and then implement it correctly. For instance, the rule I most commonly use is Feb 29th birthdays fall on...

Personally, I wouldn't write scripts that depend on anything other than the backup files themselves; using msdb to figure out which files and which order fails completely if msdb isn't...

Profiler results (Reads, Writes, CPU, Duration) are superior to STATISTICS IO results; they're more comprehensive.

CPU or Reads+Writes being more important depends a lot; are you IO constrained (perfmon avg sec/Read...

Can you get data and logs on different racks, if each rack is a stripe set/raidgroup?

Basically, have a meeting with the SAN folks and explain what your big operations (historical...

Feel free to use the alterations I posts on Page 1; they properly handle trust/untrust and enabled/disabled, using the best of your code from Check and FK constraints.

Hmmm; I'm testing on SQL 2008 R2 Enterprise Edition.