SQL Authority News – Training SQL Server Query Optimization And Performance Tuning

Earlier this year we had offered Query Optimization course and it was sold out in minutes. Due to popular demand we are offering the same course in the very first week of next year. The title of the course is ‘MS SQL Server Query Optimization And Performance Tuning‘.

This three day course is an intensive course designed to give attendees an in-depth look at the query optimization and performance tuning concepts and methods found in SQL Server. This course is designed to prepare the SQL Server developers and administrators for a transition to SQL Server while discussing best practices for a variety of topics.

Day 1 : Strengthen the basics along with SQL Server New Features

Module 01: Subqueries, Ranking Functions, Joins and Set Operations
Module 02: Table Expressions
Module 03: TOP and APPLY
Module 04: SQL Server 2008 Enhancements

Day 2: Query Optimization & Performance Tuning 1

Module 05: Logical Query Processing
Module 06: Query Tuning
Module 07:  Introduction to the Query Processor
Module 08:  Review of common query coding, which causes poor performance

Day 3: Query Optimization & Performance Tuning 2

Module 09:  SQL Server Indexing and index maintenance
Module 10:  Plan Guides, query hints, UDFs, and Computed Columns
Module 11:  Understanding SQL Server Execution Plans
Module 12: Real World Index and Optimization Tips

The space is limited and I encourage you to register as soon as possible.

If due to any reason, you cannot attend this course, please call or email on details above for future schedule for the course and location.

If you call and find whole course is sold out do contact me and I will try to get your space for sure.

We do plan to offer this course in other cities. Keep checking this blog.

SQL Authority News - Training SQL Server Query Optimization And Performance Tuning MSQOPT1

Do reach out to me if you need any further help on this subject.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Scripts, SQL Server, SQL Training
Previous Post
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
Next Post
SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction

Related Posts

13 Comments. Leave new

  • Wow its Great News , I hope u`ll com to banglore Surely and We ppl Join Us.
    thx in advance
    with regards

  • Will you be able to arrange sessions in Chennai…?

  • Hi Pinal,

    Very much happy to see the long awaited info about the session.

    The course days are from Monday to Wednesday. Would be very difficult for us, the longing working aspirants, to get leaves during the start of the new year, when by then all our clients would be back after their christmas holidays.

    I can understand, your schedule also would be too tight. Any chance to have a session along a weekend, would be a blessing for us.


  • I have a column ShiftId in ShiftMaster table with identity on. Another column ShiftName is unique. If we try to insert duplicate Shift Name, it throws error… obviously. But Identity is incremented at the same time. I want identity to be incremented only if record is inserted. Like if i have generated ShiftId from 1 to 5 and then on 6th record insertion error occurred and on next record insertion identity value will be 7 but i wish it to be 6.

    • Hi Awadesh,
      Normal behavior of identity columns:
      Failed statements and transactions can change the current identity for a table and create gaps in the identity column values. The identity value is never rolled back even though the transaction that tried to insert the value into the table is not committed. For example, if an INSERT statement fails because of an violation, the current identity value for the table is still incremented.

      One way you can control this behavior to use the
      SET IDENTITY_INSERT dbo.Tablename ON, this way you can control the insert of identity values and make sure that there are no gaps.

    • Hi Awadhesh,

      Check the Shiftname using IF EXISTS clause before inserting a new record.

      Pinal Dave

  • Can you please post the content of the presentation.

  • If it is possible! Can you arrange sessions in Hyderabad.

  • Sir,
    when are you planning a session in Bangalore?


  • Many queries are there to catch-up SQL Server with SolidQ in Bangalore and I am happily joining them. Had some words with SolidQ folks earlier and they says plans are in pipeline to xecute. Hope to catch you in Blore soon !

  • Dear Pinal Dave,

    Is there any other training that you are conducting in bangalore locations kindly let me know

    Thanks & Regards

    Prakash babu

  • Balasubramaniyam.G
    February 24, 2010 11:45 pm

    Dear Pinal dave,

    Great news. I have been looking for this class. But great miss.. when can it happen again. I am waiting eagerly..

    Thanks & Regards,

  • Naresh R. Shriramoju
    July 6, 2010 11:33 am

    Great course…
    When it again happen in pune…


Leave a Reply