As I more or less alluded to above, this isn't for peformance reasons. I work for a mega-company and as such a lot of our ancillary processes are farmed...

Regarding the request for a new thread instead of resurrecting an old one... Noted. It won't happen again. I happened across the thread after an unrelated Google search, and...

I've read in various places that rebuilding indexes will update your statistics. This makes sense all of the data gets 'touched' in the rebuild.

However, I can't find any Microsoft site...

Lynn,

I don't know if I'd go so far as to say 'extensive', but yes there are two cursors used in the code. I know they need to be removed, however,...

I tried, nothing worth noting changed. There's nothing abnormal about the IDContract value.

When I run IO statistics I get the following lines which seem troubling: [lob truncated as it's...

ha ha

Hey, I said september! So I off by a year. 🙂

Too bad CRICHARDSONS last reply was in September.

This sounds related to a problem I've having w/ SQL 2008. We upgraded last month (Db > 1TB).

A query that used to take...

More info:

I rebuilt statistics on the three tables referenced in the original post.

I recreated a duplicate proc except without assigning the parameters to local variables. Both queries...

Here's the code.

Done.

Ahh... the "it depends." One of my favorite answers with "well.... yes.... and no" being a close second. 🙂

I've read the first two Blogs, will get to the...

GilaMonster (12/10/2009)

---

Parameter sniffing - http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

(it's a 3-part blog series)

By using variables, you've got a different form of parameter sniffing, more accurately, a lack thereof. The optimiser can't see the value...

Full SQL Plan uploaded.

Thanks.

Bob McC

Jack,

Thanks for the quick response. The UPDATE STATISTICS are completed on the one table. Based on row count, I estimate the next table to take about half...

Thanks Bitbucket,

But I also saw this:

Microsoft SQL Server Management Studio Express (SSMSE) provides a graphical management tool for SQL Server 2008 Express (SQL Server Express), SQL Server 2008 Express...