Kevin E. Kline

Career and Technical Advice for the Data Professional

  • Home
  • About
    • Bibliography
    • Contact
    • Interviews & Press
  • Learning Material
    • Automation for SQL Server Databases
    • Bare Metal Tuning
    • Disk IO Tuning for Microsoft SQL Server
    • DMVs for Tuning and Troubleshooting Full-Day Seminar
    • End-to-End Troubleshooting Checklist for Microsoft SQL Server
    • High Performance DBA
    • Performance Baselining, Benchmarking, and Monitoring
    • Relational Database Design for Utter Newbies
    • Should I Virtualize SQL Server
    • SQL Server Internals and Architecture
    • Stored Procedure Best Practices
    • Surviving the Data Avalanche
    • Team Management Fundamentals
    • Technical Leadership Full-Day Seminar
    • Ten Things Every SQL Developer Should Know
    • The Ultimate Free SQL Server 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
    • End-to-End Troubleshooting for SQL Server
    • Full-Day Seminars
    • Should I Virtualize SQL Server?
    • SQL Server Internals & Architecture
    • SQL Statement Tuning with Query Optimizer Strategies
    • Surviving the Data Avalance
    • Team Management Fundamentals
    • Top 10 DBA Mistakes on SQL Server
    • Understanding and Preventing SQL Injection Attacks
You are here: Home / Abstracts / Stored Procedure Best Practices

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
  • HackerNews
  • Posterous
  • Reddit
  • Technorati
  • Tumblr

Share this:

  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to email a link to a friend (Opens in new window)

About me:

Kevin Kline

Kevin Kline

Expert and author on topics like SQL, data management, big data, IT leadership, enterprise architecture, and building technical communities. Author of "SQL in a Nutshell", popular conference speaker, blogger, magazine columnist, and world traveler.

View Full Profile →

Follow me on Twitter

My Tweets

Blogroll

  • Kevin's Column at Database Trends & Applications Magazine
  • Kevin's Column at SQL Server Professional Magazine
  • Kevin's Videos on the SSWUG.Org Data Points Briefing
  • Kevin's Videos on YouTube

Top Posts & Pages

  • SQLMag = SQL Server Pro. Goes all-digital!

Categories

Return to top of page

Copyright © 2023 · News Child Theme on Genesis Framework · WordPress · Log in