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
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