One of the great new features of SSMS 2008 is the new debug facility. Query Analyzer had a stored procedure debug facility in SQL Server 2000 but it was not transferred when SQL Server 2005 combined ...
Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your ...