I don't add to each real table.  I only add them to table variables when I need to do additional work on the data.  The ORDER BY clause would work...

I never use GUID's as primary keys.  However, I have found them very useful in the following scenario.  Because the generated numbers are essentially random and unique, whenever I need...

If you want a good example, here it is.  Not having dbo. prepended to stored procedures when calling through ADO.NET, leads to placing a COMPILE lock on the stored procedure.  We...