Ever wonder about the exact difference between data types in SQl Server? This handy reference explains and gives some advice on their use.
I hadn't realized that SQL Server will create GUIDs with the "uniqueidentifier" type before. That's what I get for using O/R mapping abstraction layers all the time. Speaking of that, I've been using the Wilson ORMapper lately and really like it.