You do have a covering index for all the tables, 1 to 4, for the column tid

How many records, in each table, 1 to 4

http://www.x-sql.com/

How many virtual drinks per comment!

See BOL 2000: Using Startup Options

/Ttrace# Indicates that an instance of SQL Server should be started with a specified trace flag (trace#) in effect. Trace flags...

With the mother of all SELECTs and maybe a few CASE statements.

Need more info.

Can use DMO to generate the script

Some interesting info in the Information Schema Views

Select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE

Where TABLE_NAME='MyTable' And 

CONSTRAINT_NAME=

(Select CONSTRAINT_NAME From INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Where...

Have a look at the end of this article at

http://www.learnasp.com/learn/dbpooling.asp

See article at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

What if you script the job, deleted it and recreate it with the script. Should refresh all possible references

Have a look at BOL 2000: Resetting the Suspect Status

Q: MSDB Database won't restore.

A: Make sure the SQLSERVERAGENT service is not started.

Problems may arise trying to restore the msdb database if the SQLSERVERAGENT service is started. The MSDB database...

Does the app keep a connection open all the time or connect / disconnect.

Can count the number of connection to a specific database for a specific hostname with a sp.

Have a look at auto update statistics, auto create statistics SQL Server Books Online.

Another one at

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=5965&FORUM_ID=5&CAT_ID=1&Topic_Title=dbcc+shrinkfile+does+not+shrink+mdf&Forum_Title=Administration

Article by Brian Morgan, SQL Server Magazine of Aug 2003

quote:

---

Why Do Similar Queries Have Different Execution Plans?

---

September 7, 2003 at 7:50 pm