Just as a follow-up, the backups on this server were taking approximately 89 hours/week to complete over the network. Last week we moved the storage array from one server (b)...

I personally try to avoid giving access to Master, including making that the default database. I have seen a few instances (just after I arrived here) where people would accidentally...

Ok... guess this is what I get for being in a hurry and not doing my research/due diligence.

Here are some posts that answer the questions (about indexes... no comments...

Kevin,

Thanks for the post. I found the same thing elsewhere on the web about 20% for 2005 and 2008.

I found this website that needs more review:

Execution plans after updating the Statistics on InvSummary table only.

Ok... I updated the statistics for the primary key on the dbo.InvSummary...

Stefan_G (8/3/2010)

---

Hmm exactly how did you produce the "scrubbed" plans ?

Did you first execute the real query, capture the execution plan, and then perform a search & replace in the...

Query 1 took 00:24:33 (+/- 1 minute in other trials) and Query 2 took 00:00:50 (+/- 2 seconds in other trials). Both were run on the server to minimize any...

Stefan_G (8/3/2010)

---

What is the actual execution times of the two query plans you posted ?

The estimated cost for Query1 is 109.4 while the estimated cost for Query2 is 46.3

With these...

Stefan,

1) We do have constraints on the tables... here is an example:

ALTER TABLE [dbo].[Jan10] WITH NOCHECK ADD CONSTRAINT [CK_Jan10] CHECK ((datepart(month,[InvoiceDate])=(1) AND datepart(year,[InvoiceDate])=(2010)))

GO

ALTER TABLE [dbo].[Jan10]...

Thanks for the comments, Grant.

The cost threshold for parallelism option on this server is set to 5.

Window Server 2008 Standard (64-bit).

SQL Server 2008 Standard (64-bit), Version 10.0.1600.22.

Grant,

Unfortunately, "ChargeType" is actually my name for a bunch of columns added together in this particular table to list a charge. The tables (dbo.Jan10, dbo.Feb10, etc) are wide tables,...

Grant,

I agree with the previous statement (RIGHT(RTRIM(InvoiceNumber),12) is a performance issue)... the VIEW_InvoiceData table was never intended to be queried against. Unfortunately, the original architect (2007) did not do...

Ok... included are the scrubbed query plans (removing as much confidential information as possible). The query in the actual execution plans is a bit more involved than the example given...

I use to have to calculate ROI(s) for a lot of IT projects (and previous to that, Engineering projects).... it is not an easy task.

As stated before, what is...