As for the square brackets, I have gotten in the habit of using them more.  And, since I write a lot of dynamic SQL, I have made it even more important to use them in the dynamic code.  Some of it is due to column names used in quite a few tables.  Some weren't reserved words back in SQL Server 2005 but are now.  But more importantly are the bizarre names that I have found for some indexes that were created elsewhere and some of code that worked perfectly fine suddenly failed.  Imagine an index name in production that looks something like this: <index_name, sysname, ind_test>.