RPC Completed and SQL Batch Completed should be enough. The columns you listed sound good too.

I can't find anything specific in the documentation. The step_id value is an INT though, so that implies a limit there. However, I sure wouldn't suggest you create a job...

It sure sounds like something related to parameter sniffing. Possibly it's data conversions? You're showing passing a string in one and a datetime in the one with the variable. What's...

Another vote for Minion Reindex. Absolutely worth checking out for maintaining your indexes.

That's odd behavior. Have you looked at the execution plans for both calls, the hard coded value and the variable? I'd be curious if there was a difference. I wouldn't...

Without seeing the execution plans, I'm just guessing.

First guess, these are different columns with different data and different data distributions. That's likely to result in differences in behavior. Another guess,...

Everything Eddie said is 100% correct (of course).

One concern that you should have though, if the recovery model were changed at any point, that effectively breaks the log backup chain...

j-1064772 (8/7/2015)

---

[font="Comic Sans MS"]One simple improvement would be to avoid DDL in the middle of DML statements.

Move to the top, before any DML the following:[/font]

[font="Courier New"]CREATE TABLE #results(...[/font]

[font="Comic Sans...

VERIFYONLY is a good test of a backup. However, it's an incomplete test. For it to be more complete, you must use CHECKSUM when you take the backup. Then the...

JaybeeSQL (8/7/2015)

---

GilaMonster (8/6/2015)

---

Grant, who works for Redgate, recommends distributed replay. 🙂

Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could...

The main issue is that you'll be slowing down performance of INSERT/UPDATE/DELETE queries to maintain all your indexes. The "too many" label can be hard to define. If you need,...

Let's say you have a script that creates two stored procedures....

This is really straight forward. You can use the RESTORE command and provide a new name. You just have to use the WITH MOVE options of the command in order...

Jeff Moden (8/6/2015)

---

I've got just the ride for you, Grant. I gave up on the handheld weapons. I'd like to introduce you to the new, improved THVPL (Tactical...

GilaMonster (8/6/2015)

---

Grant, who works for Redgate, recommends distributed replay. 🙂

Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could use...