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

Round II

    DBCC DBREINDEX

    UPDATE STATISTICS (with FULL scan)...

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

Round II

    DBCC DBREINDEX

    UPDATE STATISTICS (with FULL scan)...

My vision deterioration beganh after welding for 2 years in the late 70's. My eye stats were 20-30(R) and 20-40(L) in 1981 when I got my fort set of glasses. Add...

You are experiencing the results of 'implicit' conversion. See BOL under "implicit data type conversions".

Here's a link no DBA shoud be without:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

That referenced discussion is pretty good information.

We also did something similar way back when ... using UNC targets specified with dump devices (as opposed to files). You definitely need a...

I agree with Yelena ... after SQL installation, Service Pack installation or 'hot fix' installation I always reboot. Just a habit left over from the NT 3.5 and SQL v4.21...

In the King's English please ...

What IBM hardware are you running ? What OS and SP ? What is the type of shared disk (SAN or direct attached) ? What is the exact error that...

http://www.usps.com/ncsc/faq/

There's some pretty good info there regarding monthly changes. I'd suggest posing your question directly to the email address at the USPS for a definitive answer based on the...

It may be that the application event log has become corrupt. You've got a couple of choices. First have your Windows Admin clear the application event log. If this does...

Please do not cross post. I answered your first thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=247419

Have you executed sp_who (or sp_who2) in QA to find out wgho/what the offending connections are ? It could be you in EM monitoring things or another process. Once you...

Try using a non-clustered index. In a clustered index the leaf pages of the index are your acrual data pages whereas in a non-clustered index they are not.

As a DBA you are not as good as your last backup, but only as good as your last restore ... Good Luck !