Without seeing the actual structure and queries, these are, at best, suggestions for testing.

rhans (12/10/2015)

---

Thanks for the feedback. Looks like the advice is to create index on transaction date column....

Grant Fritchey (12/10/2015)

---

That is beautiful. The sad thing would be the people who...

Then the first index I'd put on the table is the clustered index. And, if you're going to be using this month field for lots of deletes, it might make...

You'll want to look at the WITH MOVE option if the disks are configured differently between the two servers. But yeah, a RESTORE in a situation like this is extremely...

That is beautiful. The sad thing would be the people who don't get...

Yeah, tons! Go and read the documentation. It's vital.

Steve Jones - SSC Editor (12/9/2015)

---

SQLBits is going to be iffy for me. I need to be back here on Sun, May 8, so I may have to check if...

I agree with Jayanth, for specific advice, the query and the existing execution plan.

But, general advice, yes, a non-clustered index can be used in an UPDATE statement to help the...

A single SELECT statement without any kind of filtering offers very little in the way of query tuning. A scan is the best way to access the data in this...

Take a look at the model database on the servers. I'm pretty sure that determines how things are set by default.

That's a no-go here too. I set up the test like this:

CREATE PROC dbo.ExEventTest (@ID INT)

AS

SELECT *

FROM dbo.Test1 AS t

WHERE t.ID = @ID;

GO

CREATE PROC...

It's...

SoHelpMeCod has already pointed out the issue. You don't have a defined primary key on the table.

We're all over the map here, bouncing from one thing to another. You need...

Looks like that's being called from within another procedure. Unless you also capture that procedure, I don't know of a way to do this using trace.

The one previously attached? I did look at them. You have a wild card search that will...