That's... a lot. I'm not going through all of it in detail. Summary: Tons of key lookup operations. Every one of those is probably hurting your performance. You need to...

SureshS_DBA (10/27/2010)

---

As per my understading when I do a backup and restore of a database, all statistics are restored as it is. So how come updating the stats helped here?...

Scroll down a little ways when...

Oh crud! I knew I was leaving one of the genuses, or is...

To the Threadizens/Threadites/Threadoids/Threadopians:

Please, make sure, if you're going to the Summit, you track me down and introduce yourself in person. Some of you I know already, Dixie,Jeff,etc., but some of...

Jeff Moden (10/26/2010)

---

Again... I was thinking the same thing about missing your session. It's a real bugger that they scheduled us at the same time. I did that...

Don't be. If I end up with only three or four...

tfifield (10/26/2010)

---

I know I'm coming in on the rather late. There have been times when I had to open the stored procedure, then copy/paste it to a new SSMS...

You can...

David Stout (10/26/2010)

---

So much for early registration guess I'll be missing out on the fun. The code was not available when I registered.

PASS and use SSC2010 as the code.

Note that...

And the Actual Execution plan (not an estimated).

Agreed.

In order to execute stored procedures you have to GRANT EXECUTE ON something to the user to enable them execution privileges. You can grant execution rights to individual procedures. Another...

krypto69 (10/25/2010)

---

for statistics - can I just run exec sp_updatestats?

not sure if this helps but I created same proc called myproc2...and ran that using same acount number and got the...

Jack Corbett (10/25/2010)

---

Grant Fritchey (10/25/2010)

---

Jack Corbett (10/25/2010)

---

So I got an email from a friend this morning asking for some SQL help. They are running a system that used to...