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...

Just to make sure I understood the Intersect/Except operators, I tried a variation of the examples from BOL. I put debug(s) around it all just to run various tests without...

I found a bug listing on Microsoft Connect (ID 515132) similar to the issue I was experiencing. I put my comments in the bug and voted on it. Anyone experiencing...

No updates. When the problem first occurred there were no postings on the subject related to SQL Server 2008... I am beginning to see some now, but no answers on...

This is an older post (I was researching a similar issue). Check the following URL:

http://qa.sqlservercentral.com/blogs/sql_performance/archive/2010/2/5/microsoft-sql-server-2005-cpu-scheduler-id-is-not-synchronized-with-other-cpus.aspx

Ok... found a temporary solution to the problem, but still not understanding why it is happening.... played with firewall settings (Windows Server 2008 has multiple firewalls).

Used the ipaddress,port (for...

Just to see what would happen, I did try and use a remote desktop connection to the server and it worked fine! Dealing with a few other issues now too......

I am just completing a migration from SQL 2005/Win2003 to SQL 2008/Win2008. Here are some links to review:

1) Review this forum entry: http://qa.sqlservercentral.com/Forums/Topic843135-1550-1.aspx

2) Here is a good...