My current client is using schemas which is good as it provides nice seperation. However it causes me pain on a daily basis.
The reason. I can't use the built in keyboard shortcuts in SQL Server management studio.
I can't believe how painfully annoying this is. It's just madness that SQL Server's own tool doesn't support a best practice feature.
You can vote on the connect item here to get this sorted https://connect.microsoft.com/SQLServer/feedback/details/349116/keyboard-shortcut-alt-f1-sp-help-doesnt-work-for-tables-belonging-to-non-default-schemas
I've blogged about this before, but this just annoys me so much I'm posting about it again.
Surely it can't be difficult to change. The other option is to open up SSMS so we can use add-Ins. I've blogged that before and you can vote on that suggestion here https://connect.microsoft.com/SQLServer/feedback/details/265567
I've also raised a connect item to give other improvements to keyboard shortcuts https://connect.microsoft.com/SQLServer/feedback/details/390612/improvements-to-keyboard-shortcuts-in-ssms