This course brings together two of my courses on the Udemy platform which are :
- SQL server : Configuring and modifying a database on SQL Server
- SQL server : The complete course on Indexes (4 h of class)
The first chapter will talk about the index :
You have problems of slowness on your SQL servers, and you suspect the implementation of your indexes?
You haven’t set up indexes on your tables, because you don’t know the differences between a clustered and a non-clustered index?
In this first chapter, come and discover the importance of a good index setup on your tables, don’t go on a spending spree buying disk storage, when it may be the index setup that is wrong!
It’s simple, indexes are the first reason, of your performance improvements on a SQL server.
The training in detail:
- The structure of a clustered and a non-clustered index.
- The Table SCAN and the Table SEEK
- The covering index and Why you should not index the whole table (Over indexing).
- Remove duplicate indexes, and see the definition of a SINGLE index.
- Remember to consolidate indexes, and the columnstore index.
- Beware of filtered indexes and their associated cache plan, and see what is the term SARGABLE?
- How to choose the right Clustered Index
- Why fragmentation is important, and how to remove it
- Tracking page splits and the FILLFACTOR definition
- Rebuild Index Vs REORGANIZE and the ABORT_AFTER_WAIT option