Platinum Sponsor

Stored procedures — facts and myths

Everybody knows that use of stored procedures offers a number of benefits over issuing T-SQL code directly from an application. In this demo heavy session I am going to explain to you: 1. Why plan caching and reuse is a good thing. 2. How to avoid unnecessary recompilations for plan stability-related reasons. 3. How to avoid unnecessary recompilations for plan optimality-related reasons. 4. When plan reusing is not a good thing and how you can deal with this “Parameter Sniffing” problem. 5. Why you should evade conditional logic inside stored procedures that do data access.
Presented by Marcin at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Marcin.png

    Professional Profile

    An independent consultant, database-centric application practitioner and architect totally focused on SQL Server. As a consultant he specializes in Microsoft DW/BI systems, especially in solving data quality issues and SQL Server Data Mining, and also in performance tuning and troubleshooting.

    Over the past three years he has been teaching and working with ISVs and Microsoft Polska premier customers. In addition to consulting and teaching advanced SQL Server classes, Marcin has been writing about SQL Server since 2003.

    Marcin has held SQL Server MVP title continuously since 2006 along with such titles as MCT, MCITPro and the newest MCSE certificate.

    Experience

    Since 2012 – Data Platform & Business Intelligence Expert at SQLExpert.pl. Beside creating and delivering dedicated SQL Server courses, experience in troubleshooting various customer’s problems related to SQL Server.

    Since 2009 – Microsoft Partner. External SQL Expert responsible for piloting proof-of-concept projects and teaching internal classes.

    Since 2008 – BETACOM S.A. – Architect, consultant and trainer involves in design solutions based on SQL Server and related Business Intelligence technologies and troubleshooting ETL and IEM solutions based on SQL Server.

    2001 – 2008 – Comp Safe Support – Microsoft Certified Trainer. Experience in conducting authorized Microsoft training since 2001. Certified training in the field of Microsoft SQL Server, ETL/EIM and BI.

    Certifications

    MCT – Microsoft Certified Trainer
    MCSE – Microsoft Certified Solutions Expert:
    - Data Platform
    MCITP – Microsoft Certified IT Professional:
    - Database Administrator SQL Server 2005
    - Database Administrator SQL Server 2008
    - Database Developer SQL Server 2005
    - Database Developer SQL Server 2008
    - Business Intelligence Developer SQL Server 2008
    - Business Intelligence Developer SQL Server 2008
    MCTS – Microsoft Certified Technology Specialist:
    - SQL Server 2005
    - SQL Server 2005, Business Intelligence Development
    - SQL Server 2008, Implementation and Maintenance
    - SQL Server 2008, Database Development
    - MCSA – Microsoft Certified Solutions Associate
    - SQL Server 2008 Core
    - SQL Server 2012

    MCSD – Microsoft Certified Solution Developer
     - For Microsoft .NET
    -  Microsoft Visual Studio 6.0

    MCSE – Microsoft Certified Systems Engineer: Security
     - Microsoft Windows Server 2003
    - Microsoft Windows 2000

    Books and Publications (selected)

    „Microsoft SQL Server. Modelowanie i eksploracja danych” - The very first Polish book (and one of very few overall) that covers the whole cycle of data mining, from framing business problems, assessing and preparing data, building and evaluating mining models, to acting on the results. This book was prepared with cooperation with Microsoft Polska and it was used to promote SQL Server 2012 Business Intelligence Edition

    „Serwer SQL 2008. Usługi biznesowe. Analiza i eksploracja danych” – 101 publication about core components of Microsoft BI platform - SSAS and Excel 2007 with Data Mining Add-in

    „Serwer SQL 2008. Administracja i programowanie” - Book written with fellows MVPs (Pawel Potasinski and Damian Widera) about administering and programming SQL Server 2008

    “Praktyczny kurs SQL” - course SQL language based on TSQL 2008

    „SQL Server 2005 Express. Skuteczne rozwiązania” - Practical guide to SQL Server 2005Express Edition

    “Transact-SQL. Czarna księga” – The ultimate Transact-SQL reference

    Avoiding Data Loss” – article answering the question Kow to prevent data lost? In order to do this one should know how SQL Server uses data and log files and hot to backup and restore databases including piecemeal and partial restore

    „Widoki dynamiczne — sposób na poznanie swoich serwerów SQL 2005 i 2008” - Dynamic management views reveal enormous amount information about SQL Servers, but many DBAs still don’t use them. Article describes 40+ DMV’s most useful queries about SQL Server and databases configuration & operational stats.

    “SQL Serve free tools that help monitoring and optimizing” - Article describes free SQL Server tools, like MSSQL Blocks, SQL Deadlock Detector, SQL Server Cache Manager, SQLDiag, Performance Analysis of Logs and RML Utilities for SQL Server

    „Monitorowanie wydajności systemu Windows i serwera SQL” - Measuring SQL Server performance could be difficult, especially if You don't have a baseline. This article explains how to monitoring server resources with System Monitor, SQL Server Profiler and Performance Analysis of Logs.

    http://sqlexpert.pl/
  • Video
    The video is not available to view online.