First, have you checked your NIC card settings ? Particularly 'speed' and 'mode'. Not having the NIC card match the switch port can cause this type of issue. Since it's...

What is the salary range ? As to the location, are we looking at Bangalore, India ?

I've actually been a participant in 2 of the industry salary surveys for the last 3 years. I've done this for fun and to receive the "free" copy of the...

"select count(indexed_column) from table" is probably your best bet where indezxed column is the narrowest available to get a row count.

However select count(*) just prior to your actual query will...

David - one old fart to another - I have to now buy a hat just so I can take it off to you sir !

We do it for a healthcare imaging system (x-ray, mri, pet, cat scans). It's more of a migration from super fast disks to fast disks, to slow disks at present....

For tables less than one extent, 8 pages or 64 kb, improvement does not much matter. Remember SQL Server reads 'extents' and writes 'pages'.

You can change the logical names of the mdf and ldf files as well too to be consistant. You'll need to do this right after the restore with this little...

master is so small, <25 Mb, and msdb is usually <50Mb. I do it daily and so should you. In this world of cheap disk and cheaper tape in the...

Words for the cynic/realist/fatalist based on your point of view or situation:

Shepkowski's Employment Credo

-- How much do I get paid ?

-- When do I get paid ?

-- What do I...

A deadlock can only involve 2 parties to the best of my knowledge. If there is a third (or more), I believe that they would be blocked. So it sounds...

I'd hold off on the memory upgrade for a bit. Just because Total and Targte Memory are the same. I'd utilize the Windows Performance Monitor a bit and start checking...

Before all is said and done I'd like to suggest that the issue may be 'blocking' not 'deadlocking'. I say this because of the lack of a mention of messages...

John is correct - your SQL Server is bahving normall in it's memory usage. I've noticed for 'standard edition' ~1.7 to 1.8 Gb used. If you go to 'enterprise edition'...

Assume nothing !!!

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all tables

    exec sp_refreshview for all views

Round II

   ...