SQL Server stored procedures

MUST READ Find size of SQL Server tables and other objects with stored procedure 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. Examples of SQL Server stored procedures and parameters TIP - Find examples of SQL Server stored procedures and parameters not documented by Microsoft. FAQ: SQL Server stored procedure how-tos 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. Stored procedure: A simple way to perform crosstab operations TIP - SQL Server crosstab operations usually involve complicated T-SQL coding. This tip explains how the process is made simple with the sp_Crosstab stored procedure. Stored procedure to monitor long-running jobs in SQL Server 2000 TIP - Get a stored procedure to monitor long-running jobs in SQL Server 2000. This T-SQL stored procedure (SP) also provides email alerts about jobs that decrease SQL Server performance.

EXPERT TECHNICAL ADVICE: 1 - 3 of 139

SQL SERVER STORED PROCEDURES EXPERTS
			Roman Rehak Senior Database Architect ASK A QUESTION		Greg Low Lead SQL Server Consultant ASK A QUESTION

	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.

	SQL Server source code analysis and management adds database security Submitted By: Kevin Beaver | 23 Apr 2008 TIP - SQL Server source code analysis and management add database security by debugging and testing SQL applications. Learn about SQL source code analysis.

	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.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER STORED PROCEDURES

REFERENCE & LEARNING: 1 - 3 of 52

	SQL and SQL Server Tutorial and Reference Guide SearchSQLServer.com | 21 Apr 2008 LEARNING GUIDE - This Back to Basics SQL tutorial and reference guide provides a great starting point and foundation for learning SQL or brushing up on your skills.

	Top 10 SQL Server development tips of 2007 SearchSQLServer.com | 28 Jan 2008 THE YEAR IN REVIEW - From writing stored procedures and creating SQL Server tables and columns, to T-SQL enhancements in SQL Server 2005, these were the topics that made you click in 2007.

	Top 10 SQL Server Tips of 2007 SearchSQLServer.com | 07 Jan 2008 THE YEAR IN REVIEW - Get the top 10 SQL Server tips of 2007 on topics of SQL Server database design and performance tuning to upgrading to SQL Server 2005 and stored procedures.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER STORED PROCEDURES

NEWS: 1 - 3 of 3

	Saying yes, no or maybe to stored procedures TheServerSide.NET | 16 Aug 2006 ARTICLE - Styles of development swing in and out of favor. Take stored procedures, which work, to some extent, and may be the shortest way to a successful project, sometimes.

	Specifying execution context for procedural code Addison-Wesley | 28 Feb 2005 ARTICLE - Learn how to specify execution context for procedural code in SQL Server 2005 in this excerpt from "A First Look at SQL Server 2005 for Developers."

	Why use stored procedures? SearchDatabase | 06 Mar 2002 ARTICLE - Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI).

	VIEW ALL NEWS ON SQL SERVER STORED PROCEDURES

DOWNLOADS: 1 - 1 of 1

	PromptSQL Published by: PromptSQL | 23 Nov 2005 DOWNLOAD - PromptSQL is an add-on application that provides auto-complete functionality as you type for programs used to create SQL statements. It works with QA, UltraEdit32, Visual Studio.NET 2003, Visual Studio 2005 and SQL Server ...

	VIEW ALL DOWNLOADS ON SQL SERVER STORED PROCEDURES

BEST WEB LINKS: 1 - 2 of 2

	SQL Server 2000 Survival Guide http://www.akadia.com/services/sqlsrv_programming.html | 22 Jul 2005 BEST WEB LINK - Here you find step-by-step resources for architecting, administering and managing SQL Server 2000.

	Microsoft SQL Server: Programming Forum http://www.tek-tips.com/ | 22 Jul 2005 BEST WEB LINK - This active forum dedicated to SQL Server will give answers to SQL Server's most difficult questions.

	VIEW ALL BEST WEB LINKS ON SQL SERVER STORED PROCEDURES

DEFINITIONS: 1 - 2 of 2

	library 27 Nov 2001 WORD - In computing, a library is a collection of similar objects that are stored for occasional use - most frequently, programs in source code or object code form, data files, scripts, templates, fonts, and physical storage units ...

	trigger 23 Mar 2001 WORD - A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm. In a database, a trigger is a set of Structured Query Language (SQL) statements that ...

	VIEW ALL DEFINITIONS ON SQL SERVER STORED PROCEDURES

	SEE ALSO - Topics Related to SQL Server stored procedures:  Web services/SOA, Visual Basic in SQL Server, XML in SQL Server, SQL/Transact SQL (T-SQL), C#, .NET development for SQL Server