background preloader

Admin

Facebook Twitter

Регламентные операции на уровне СУБД для MS SQL Server. How to Detect Table Fragmentation in SQL Server 2000 and 2005. How do you know when a table is fragmented?

How to Detect Table Fragmentation in SQL Server 2000 and 2005

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.

SQL Query Optimization FAQ Part 1 (With video explanation)

As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc.