Gianluca Sartori (3/14/2012)

---

If you have enough space in the tempdb drive, you could use SORT_IN_TEMPDB.

Another option is adding temporarily a new data file in the same filegroup in a different...

Thanks for the updates/inputs! 🙂

Everything we do (queries) is very "date-centric" so Date is almost always a part of the clustered indexes on our tables, FYI.... date of a...

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