In an earlier column, I suggested that one way to speed up your application was to reduce the trips you make to your database, specifically by avoiding calling a stored procedure multiple times.To ...

Enterprise Manager, Visual Studio, and third-party tools let you add, drop, and modify table columns in a visual, easy-to-use environment. You click on Save; then they generate and execute ...

SQL Server 2005 or later; Visual Studio 2013; ... In Visual Studio 2013, there is no excuse for not commenting your tables and columns. Table level descriptions have to be set in the properties pane.