Stored Procedures

EXPERT TECHNICAL ADVICE: 1 - 3 of 47

	Check SQL Server database and log file size with this stored procedure 13 May 2008 TIP - Check the size of your SQL Server database with the undocumented stored procedure sp_SDS and get results beyond sp_spaceused. Also calculate log file size and monitor DB growth.

	Configure SQL Server Service Broker for sending stored procedure data Submitted By: Denny Cherry | 16 Apr 2008 TIP - Set up SQL Server 2005 Service Broker for a messaging platform to queue data of stored procedures and functions. Configure Service Broker with these steps.

	Find size of SQL Server tables and other objects with stored procedure Submitted By: Richard Ding | 09 Apr 2008 TIP - Check the size of SQL Server tables and other database objects with an original stored procedure, sp_SOS, that expands on sp_spaceused. Calculate space and perform more functions.

	VIEW ALL EXPERT TECHNICAL ADVICE ON STORED PROCEDURES

REFERENCE & LEARNING: 1 - 3 of 21

	Top 10 SQL Server development questions SearchSQLServer.com | 20 Jul 2007 FAQ - SQL Server development can put you in a crunch. Get solutions here when it comes to concurrency problems, stored procedure results and writing T-SQL.

	FAQ: SQL Server stored procedure how-tos SearchSQLServer.com | 17 Jun 2007 FAQ - Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines.

	Problems and justified use of cursors McGraw-Hill | 07 Feb 2007 TUTORIAL - Cursors should traditionally be avoided, however, this book excerpt outlines situations in which cursors are acceptable in T-SQL.

	VIEW ALL REFERENCE & LEARNING ON STORED PROCEDURES

	SEE ALSO - Topics Related to Stored Procedures:  Database Administrator, Data Warehousing and Business Intelligence, Microsoft SQL Server