-->
Kevin E. Kline

Stored Procedure Best Practices

  • Pages

    • Home
    • Abstracts
      • Automation for SQL Server Databases
      • Bare Metal Tuning
      • Disaster at the Podium
      • Disk IO Tuning
      • DMVs for Tuning and Troubleshooting Full-Day Seminar
      • End-to-End Troubleshooting
      • Five Minute SQL Server Health Check
      • High Performance DBA
      • Major Myths about SQL Server
      • PBBM
      • PBBM - ILL
      • Prepping for High Availability
      • Relational Database Design for Utter Newbies
      • Should I Virtualize SQL Server
      • SQL Server 2005 Overview
      • SQL Server 2008 Worth the Wait
      • SQL Server Internals & Architecture
      • SQL Server Troubleshooting, Parts 1 - 3
      • Stored Procedure Best Practices
      • Surviving the Data Avalanche
      • Team Management Fundamentals
      • Technical Leadership Full-Day Seminar
      • Ten Things Every Developer Should Know
      • The Ultimate Free SQL Server Toolkit
      • The Ultimate SQL Server Dev-DBA Toolkit
      • Time Management for IT Pro
      • Top 10 Mistakes on SQL Server
      • Translating Procedural Code Between Oracle and SQL Server
      • Tuning with Indexing Strategies
      • Tuning with Query Optimizer Strategies
      • Tuning with SET and DBCC
      • Tuning with Showplan
      • Understanding and Preventing SQL Injection Attacks
    • Bibliography
    • Bio
    • Contact
    • Interviews & Press
    • Political Calculus - PASS Governance
    • Slides
    • Special Offers
    • Upcoming Events
  • Blogroll

    • Database Trends & Applications
    • SQLMag Blog
    • YouTube Media
  • What I'm Doing...

    • The KEK SQueaLer SQL and Data News is out! http://t.co/35BoV1D 3 hrs ago
    • The KEK SQueaLer SQL and Data News is out! http://t.co/35BoV1D 1 day ago
    • RT @mssqltips: Script to move all objects to a new schema for SQL Server : http://t.co/ndfPVsi 2 days ago
    • The KEK SQueaLer SQL and Data News is out! http://t.co/35BoV1D ▸ Top stories today via @kekline 2 days ago
    • Are you active in #sqlpass Hot debate! bit.ly/oFD9SX Another comment came in between the time I started & finished my own comment. 2 days ago
    • More updates...

    Posting tweet...

  • Tags

    Azure Backup & Recovery Best Practices Career cloud computing CodePlex Creativity DBA DBTA Developer DMV FutureWatch Goals Guest Post Humor Internals Management Monitoring MVP news analysis NoSQL Oracle Performance Plays Well With Others Professional Development Quest Software Society SQLCAT SQLMag SQLPASS SQLSaturday SQL Server 2005 SQL Server 2008 R2 Toad Tools Tools & Scripts Training Transact-SQL Programming Troubleshooting Video Virtualization Web Development Windows WorldView Writing
  • Free Downloads

  • Categories

  • Archives

    • September 2011
    • August 2011
    • July 2011
    • June 2011
    • May 2011
    • April 2011
    • March 2011
    • February 2011
    • January 2011
    • December 2010
    • November 2010
    • October 2010
    • September 2010
    • August 2010
    • July 2010
    • June 2010
    • May 2010
    • April 2010
    • March 2010
    • February 2010
    • January 2010
    • December 2009
    • November 2009
    • October 2009
    • September 2009
    • August 2009
    • July 2009
  • Badges





  • RSS Feed

Stored Procedure Best Practices

Title: Stored Procedure Best Practices

Level: 200

Abstract: Find out the tricks and techniques needed to make SQL Server stored procedures achieve top performance. Numerous tips will show you how to make your stored procedures run faster, with fewer errors, and with better reliability.  This class assumes a basic understanding of Transact-SQL. The session covers both SQL Server 2000 and Yukon.

Prerequisites: Intermediate coding skills in Transact-SQL

Rate it! Rate my session and offer feedback here.

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks
  • email
  • LinkedIn
  • Ping.fm
 
kevinekline.com      
  • Abstracts
    • Automation for SQL Server Databases
    • Bare Metal Tuning
    • Disaster at the Podium
    • Disk IO Tuning
    • DMVs for Tuning and Troubleshooting Full-Day Seminar
    • End-to-End Troubleshooting
    • Five Minute SQL Server Health Check
    • High Performance DBA
    • Major Myths about SQL Server
    • PBBM
    • PBBM – ILL
    • Prepping for High Availability
    • Relational Database Design for Utter Newbies
    • Should I Virtualize SQL Server
    • SQL Server 2005 Overview
    • SQL Server 2008 Worth the Wait
    • SQL Server Internals & Architecture
    • SQL Server Troubleshooting, Parts 1 – 3
    • Stored Procedure Best Practices
    • Surviving the Data Avalanche
    • Team Management Fundamentals
    • Technical Leadership Full-Day Seminar
    • Ten Things Every Developer Should Know
    • The Ultimate Free SQL Server Toolkit
    • The Ultimate SQL Server Dev-DBA Toolkit
    • Time Management for IT Pro
    • Top 10 Mistakes on SQL Server
    • Translating Procedural Code Between Oracle and SQL Server
    • Tuning with Indexing Strategies
    • Tuning with Query Optimizer Strategies
    • Tuning with SET and DBCC
    • Tuning with Showplan
    • Understanding and Preventing SQL Injection Attacks
  • Interviews & Press
  • Political Calculus – PASS Governance
    • Nominations, Appointments, and Elections
  • Special Offers
  • Bio
  • Upcoming Events
  • Bibliography
  • Contact
  • Slides
    • 5 Minute SQL Server Health Check
    • Disk IO Tuning for SQL Server
    • End-to-End Troubleshooting for SQL Server
    • Microsoft SQL Server 2008, Worth The Wait
    • Should I Virtualize SQL Server?
    • SQL Server Internals & Architecture
    • SQL Statement Tuning with Query Optimizer Strategies
    • Surviving the Data Avalance
    • Team Management Fundamentals
    • Top Ten Mistakes on SQL Server
    • Understanding and Preventing SQL Injection Attacks
  • Database Trends & Applications
  • SQLMag Blog
  • YouTube Media