Thanks Gail!

I should have known that but I guess my mind was not fully in gear today! 😉

That is why I love this site... always other people with different perspectives and different ways to tackle a problem.

Thanks Ken!

Unfortunately, I cannot modify the dbo.PCList table but my...

This definitely took long enough to figure out. Apparently, the cliconfg settings for a Windows 7 64-bit or Windows 2008 64-bit system is located in two places:

C:\Windows\System32\ ---- 32-bit...

I read a number of the posts, and I guess I would approach the use of SQL Monitor and the iPad from a different standpoint?

First, when I was hired...

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: http://www.sqlstatistics.com/page/2/

I...

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.