SQL SERVER – SQL Server Performance: Indexing Basics – SQL in Sixty Seconds #006 – Video
- by pinaldave
A DBA’s role is critical, because a production environment has to run 24×7, hence maintenance, trouble shooting, and quick resolutions are the need of the hour. The first baby step into any performance tuning exercise in SQL Server involves creating, analyzing, and maintaining indexes.
Though we have learnt indexing concepts from our college…