SQL Server Stored Procedures

MUST READ SQL Server stored procedures tutorial: Write, tune and get examples TUTORIAL - Learn how to write and tune SQL Server stored procedures in this tutorial. Also included is a collection of stored procedure examples for you to browse. 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. Stored procedure to find fragmented indexes in SQL Server TIP - Here's a stored procedure to find fragmented indexes on all servers and databases in SQL Server environments and improve application performance. 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.

EXPERT TECHNICAL ADVICE: 1 - 3 of 170

	SQL Server trigger vs. stored procedure to receive data notification 02 Oct 2008 EXPERT ANSWER - Learn why using a SQL Server stored procedures vs. a trigger can be a preferred method to retrieve data notification from a database field.

	SQL Server errors, failures and other problems fixed from the trenches Submitted By: SearchSQLServer.com | 02 Oct 2008 TIP - Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance errors and suspect data recovery problems.

	How to use SQL Server 2008 hierarchyid data type Submitted By: SearchSQLServer.com | 20 Aug 2008 TIP - Learn how the SQL Server 2008 hierarchyid data type simplifies queries when you want to store parent-child relationships in a table and represent a hierarchial SQL tree.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER STORED PROCEDURES

REFERENCE & LEARNING: 1 - 3 of 45

	Top 10 SQL Server development tips of 2008 Steve Cimino, Assistant Editor | 07 Jan 2009 THE YEAR IN REVIEW - From converting date/time values into character types to retrieving XML data values with XQuery, these were the top 10 SQL Server development topics of 2008.

	SQL Server and data manipulation in T-SQL Eric Johnson and Joshua Jones | 16 Sep 2008 BOOK EXCERPT - Learn about stored procedures, parameters, triggers and other T-SQL code functions in this book excerpt.

	SQL Server stored procedures tutorial: Write, tune and get examples SearchSQLServer.com | 21 Jul 2008 TUTORIAL - Learn how to write and tune SQL Server stored procedures in this tutorial. Also included is a collection of stored procedure examples for you to browse.

	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

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, SQL Server Database Modeling and Design, XML in SQL Server, SQL/Transact SQL (T-SQL), SQL Server Business Intelligence (BI) and Data Warehousing, .NET Development for SQL Server