You also don't need to drop and recreate an index when you alter a column.

A bookmark lookup occurs when SQL uses a nonclustered index to locate the rows required for a query, but the index does not contain all the columns needed by the...

This the one you're looking for? Used in a select statement, so you can check the dates of all stats in the system with a single query.

STATS_DATE

...

The SELECT returns at most a single row for every entry in the IN clause.

Yes, but how many enteries do you typically have in the IN clause? There comes a...

That's still going to give an error, from the parsing of the USE statement 

Could not locate entry in sysdatabases for database 'MyDB'. No entry found with that name....

The join order does not affect performance. The query optimiser will reorder the join to find the cheapest plan possible. I think it's been this way since SQL 7

I tried...

SELECT t0.col1,

t0.col2,

t0.col3,

t0.col4,

t0.col5,

t0.col6,

t0.col7,

t0.col8

FROM dbo.table1 t0

WHERE (t0.col8 IN (?))

That select will table scan if the number of records returned exceeds more than about 1% of the table. I can't tell whether the in...

Please don't ever run ShrinkDatabase on a production database without a very, very good reason. All you're going to achieve is to fragment all your indexes badly and force the...

Perhaps query hints are in order. I'll see what I can do.

Recomended practice is to never add query hints unless you know exactly what you're doing and why you're adding...

Sounds like your watchdog process is the problem then.

I notice that your orders table doesn't have a clustered index. Adding one may help out, especially with the reads, if it's...

Why do you want to store the code and the code ID in the billing detail table? It's poor table design. (Unless this is some form of data warehouse and...

You'll have to keep a watch on sp_lock, see if you get table locks. However in general, if you have a lot of inserts and updates to a table, then...

but u know there is an @@error global function in sql

@@Error just returns the error statement of the previous command in a TSQL batch. If the previous command executed without...

Are they very big tables?

With auto update stats, the stats get updated after a certain percentage of the table changed. With larger tables, it takes more changes to trigger the...

Steve

Tried replying to your mail on polo shirt, using email that you indicated, got user does not exist error. Is there another address I can use?