MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Play by Play: Pinal Dave

Course Summary

Geoffrey Grosenbach sits down with Pinal Dave to see what a SQL Server Admin does in the real world. This Play-by-Play will focus on SQL Server performance tuning. Pinal goes over optimizing queries and fine-tuning the server.

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
    ● Basic Information Gathering
        ◦ Personal History
        ◦ Basic Information Analysis
    ● Removing Performance Bottleneck
        ◦ Optimizing Parallel Queries
    ● Index Optimization
        ◦ Impact of Unused Index
        ◦ Impact of Clustered Index
        ◦ Impact of Nonclustered Index
        ◦ Create Missing Index
        ◦ Drop Unused Index
    ● Optimize Query With Re-write
        ◦ Remove Bookmark Lookup
        ◦ Create Index
        ◦ Understanding Datatype Hierarchy

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Data & Information Management and Server & Storage Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top