Регламентные операции на уровне СУБД для MS SQL Server. How to Detect Table Fragmentation in SQL Server 2000 and 2005. How do you know when a table is fragmented?
Poor query performance over time. More disk activity. SQL Query Optimization FAQ Part 1 (With video explanation) SQL Query Optimization FAQ Part 1 (The SQL Plan) Introduction and Goal In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan.
As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc.