Do you find T-SQL scripts hard to read with all the square brackets?
The T-SQL scripting tools (such as SQL Server Management Studio) provide two options for scripting names: either to quote them or to omit quotes.
If you avoid things like spaces in object names, you can mostly get away without quoting i.e.
Sales.Customers is just fine and doesn’t need to be [Sales].[Customers].
Even then, one problem that can arise is that a name you had used in your code could become a SQL reserved word. In that case, you either need to change every reference to it (painful), or quote it wherever it’s used (also painful). So quoting by default is always a safe option. However, it makes the scripts much harder to read due to visual noise.
2013-08-03