RonKyle (8/1/2013)
saFinance is shorter than FinanceStaging and dwKyle is much shorter than KyleDataWarehouse. The users don't see these names, so they don't have to be user friendly. I can see that some might prefer databases be grouped, in which case the suffix would be better, but I like to have my staging areas grouped together, so I need the prefix.Some would say I'm giving away my Microsoft Access roots, but no apologies for that.
Like I said, if it's working for you, great!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning