Thanks Ken and Guru.  You're right about the datatype.  This is legacy code and has been that way for quite a while, and I never noticed the mismatch.  The server...

I ran just this portion of the original query; it selects data that is then inserted into a table.  It runs in 3 min. 24 sec.

SELECT i.MEDICAL_GROUP

, t.POST_PD

, i.PROV

, SUM(t.PAY_AMT)...

"Your credibility is shot with me"

There you go Steve.  Now the Mac fanboys will place a fatwa on you.

John, all good suggestions.  On that execution plan, bad news: there's no test DB.  We are poor like churchmice, and only have the production database.  The indexes on both tables...

We have six production databases on that server and run DBCC CheckDB each Wednesday evening on them, with no errors, so I don't see how the database could be corrupted. ...

Matt, I did what you suggest, using an indexed temp table, and it didn't seem to make a difference in the run time.  I could try it with a base table,...

This database actually has 8 filegroups.  The filegroup where these tables resides is Primary, which has two files.  Primary1 has 91GB, Primary2 has 49GB.  They are set for 10% incremental...

File sized appropriately?  The short answer is no, with growth set to 10% increment.

The defragmenter report shows under 1000 fragments for the most fragmented files (33 files) on this drive,...

I took off the group by on the join between invoice and transac tables and it still took over 9 minutes on a quiet server.  My index strategy I think is...

Lynn, thanks, but there are no parameters involved in this proc.  The proc runs and joins tables, that's all.

I don't think bonding will help a company find trustworthy workers.  It's just a form of insurance.  Worse, as a contractor, who pays for the bond?  For my last few...

Thanks John.  These deadlocks happen during a maintenance job that runs once a week.  If I read the article correctly, once I enable the trace flags, they will only write...

What's your budget for training, books, conferences, etc?

If they are not on the latest version of your favorite tool (VB6!), what's their plan for moving up to the latest and...

If I am connected to the database with a username 'Dave' and execute this statement in QA:

CREATE TABLE MyTab

(Record_ID int,

TransactionLinkID INT)

I am really creating a table named Dave.MyTab.  That's a SS2K thing.

If...

We finally got through to the right network guy who figured out the login attempts were coming from the PC in the next cube.  We haven't figured out what software on there...