That works well. Thanks.

Now when I add it to the actual query (I'd used a simplified query in my example), I get an error "The table 'Table_B'...

Create table case(

case_number varchar(20),

open_date datetime,

closed_date datetime,

ra_date datetime)

Need to select all datarows where the greater of the closed_date and the ra_date is greater than a inputed parameter

I have spent a lot of time trying to determine the locking architecture/logic for sql server and I am still no expert. From what I know, sql server is...

Are you using bcp? Do you have a lot of indexes that need to be built?

Deadlocks are usually caused when improper transaction locking is employed. Even if proper trans locking is used, blocks can occur. Ultimately, you will need to find the root...

I have seen a problem with profiler but nothing with em.

uninstall and reinstall making sure that if you only want to install client tools, you make sure that ent man is selected. If you are installing the full server...

try searching for isqlw.exe. In the same folder where this is installed, you will find enterprise manager. You can then create shortcuts or add them to your program...

From my experience, a table and its indexes should be on a single filegroup with multiple files. Heavily used tables should be on different filegroups and possibly on different...

From bol:

SET ARITHABORT must be ON when creating or manipulating indexes on computed columns or indexed views. If these are two settings that you need to be OFF, set up...

Do you have a lot of alerts set up or are the alerts different between your servers?

Is the app locking or are there actual db locks? You can run sp_lock while they run their processes to see.

I gained significant performance improvements by doing the following. I set up a mirrored d drive and a RAID 5 E drive(c was reserved for OS) They have...

I would agree that another gig is warrented.

You can dynamically configure minimum RAM in server properties. Is that what you meant by working set size?