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 171

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

	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.

	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.

	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.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER STORED PROCEDURES

REFERENCE & LEARNING: 1 - 3 of 54

	SQL and SQL Server Tutorial and Reference Guide SearchSQLServer.com | 31 Jul 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.

	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.

	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.

	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:  .NET development for SQL Server, Web services/SOA, Visual Basic in SQL Server, XML in SQL Server, SQL/Transact SQL (T-SQL), C#