Try something like this:

WHERE ChkDate LIKE 'Jan  6 2004%'

This is a good book:

http://msdn.microsoft.com/library/en-us/dnnetsec/html/secnetlpMSDN.asp

See Books OnLine: Database Object Owner.  If a third user also created a table named Customers, which would you have the system automagically use?

You are looking at cumulative counts for a process that has been running since the Agent service was started.  I doubt this is relevant to system performance.

UPDATE o SET Status = 'SO'

FROM Orders o JOIN

(SELECT DISTINCT OrderId

 FROM OrderLines l

 WHERE NOT EXISTS

 (SELECT *

  FROM OrderLines

  WHERE OrderId = l.OrderId

  AND Status <> 'SO')) d ON o.OrderId = d.OrderId

WHERE Status <> 'SO'

Simply turn on Query|Show Execution Plan in QA, run both queries in the same batch, and then compare the relative times in the Execution Plan window.  Try my variant with...

Okay, I see why that "correlated derived table" works.  It doesn't need to be a derived table, and the query optimizer automatically reduces it to a simple correlated subquery. 

SELECT @EndDate = MAX([Date])

FROM Table1;

Yes, if you mean your queries are timing out, then use the Timeout property of the command object.  If you set this to 0 (the default in Query Analyzer), there...

http://support.microsoft.com/?id=281574

I'm with you.  Having the model as Full allows you to make a tran log backup when disaster strikes and be a hero by recovering more than just the previous...

Could you post the example of the correlated subquery used as a derived table?  I thought derived tables are not evaluated dependently...  The only time...

Yes, you do need a self-join.  Something like this:

SELECT LTRIM(a.ID) + '-' + a.Descr AS ID_Desc, LTRIM(b.ID) + '-' + b.Descr AS Parent_Desc

FROM YourTableName a JOIN YourTableName b on b.ID =...

It looks like the sort of bug where the parser designers never tested a correlated derived table in a select list used with...

Well, I wouldn't use this, so treat it as an example:

Sub AlterProcs(sDatabase As String, sOldColName As String, sNewColName As String)

  Dim objServer...