Look, also, for "triangular joins" especially in correlated sub-queries (which can be a RBAR load all by themselves).  An example of a "triangualar join" might be something like the classic...

Well, well, well... I wondered where I saw that lick of code before... Welcome aboard, Josh!

THAT is very true... there's a hot fix for it (although I don't remember the #, check the MS website).  In fact, if parallelism is spawned and you don't have...

Very nicely done and very neat idea, Harry... gotta couple of rhetorical questions and a tip or two...

1.  It would appear that ProcFinish and ProcFiledate will always have the same...

Ah... I get it.  The W3Schools website does have both "equi-joins" (joins in the WHERE Clause) and ANSI Joins (INNER JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER, CROSS, etc) with...

The real problem is that no matter what anyone does, you will not be able to differentiate between the two formats if both the day and month are <= 12. ...

I believe it's because some of the system owned spids are doing work in the background.  On a dead quiet system, SQL Server has a "heartbeat" that occurs about once...

Thanks for the feedback, Gabor.  Yep, I found the same thing and more... I'm not sure what I was thinking of before.  Must'a been some bad coffee of something...

Gabor, I admittedly need to do a little more research but considering that the "Reorganize data and index pages" option actually moves data from the end of the physical file to...

Agreed.  I don't know why 3rd part vendors do that to us.   In those cases, though, I'll still do bulk processing to fill a staging...

Diagnostic Manager... Now THAT's useful and I understand what you mean, now!  That kind of monitoring tool can be priceless!  Thanks for the info, Colin.

If it's a gotta-have-it now type of thing, look at the proc and see if it uses GETDATE() to update any columns in tables... you might have to do a...

Bulk Insert does not necessarily require field separators if you use a format file.  Or, just use Bulk Insert to import to a single column tables and then use SUBSTRING...

Totally untested... should be nasty fast if the ID and StartTimeColumns are indexed.

 SELECT tc.ID,

        tc.StartTime,

        tc.StopTime,

        d.MinStopTime AS OriginalStopTime

   FROM dbo.TimeClock tc WITH (NOLOCK),

       ...

If you want strictly ANSI 92 compliant stuff, there's no need for a book on T-SQL...

Try http://www.w3schools.com

For the record, if you're one of those folks that insists on writing...