SQL Server Performance Tuning Part 1 of 2
  • DOWNLOAD APPLICATIONS
  • SQL Performance Tuning Part 1
  • CREATE A VIRTUAL MACHINE
  • CONFIGURING WINDOWS SERVER
  • INSTALLING SQL SERVER 2016 PART 1
  • INSTALLING SQL SERVER 2016 PART 2
  • INSTALLING SSMS
  • RESTORING DATABASE
  • WHAT IS SQL PERFORMANCE TUNING
  • HARDWARE
  • DETAIL KNOWLEDGE OF PARTS
  • AUTOGROWTH SETTING AND QUIZ 1
  • INDEXES
  • WHAT IS INDEXING
  • CREATE A CLUSTERED INDEX WITH PK
  • NON CLUSTERED INDEX
  • B TREE
  • B TREE NON CLUSTER INDEX
  • ANATOMY OF SQL PAGE
  • CAUSING A PAGE SPLIT
  • TYPES OF INDEXES
  • WHAT IS THE QUERY OPTIMIZER
  • OPERATORS
  • TABLE SCAN
  • NON CLUSTERED INDEX PART 1 AND QUIZ 2
  • NON CLUSTERED INDEX PART 2
  • ORDER OF COLUMN IN NON CLUSTERED INDEX
  • FILTER NON CLUSTERED INDEX
  • SORT OPERATOR
  • JOIN OPERATORS
  • STATISTICS
  • What is Locking?
  • What is blocking?
  • DEADLOCKS
  • WAIT STATISTICS
  • RECOMPILATIONS
  • TEMPDB AND QUIZ 3