admin

TwitterFacebook
Get flash to fully experience Pearltrees
How do you know when a table is fragmented? Poor query performance over time. More disk activity.

How to Detect Table Fragmentation in SQL Server 2000 and 2005

http://www.sql-server-performance.com/2006/detect-fragmentation-sql2000-sql2005/
SQL Query Optimization FAQ Part 1 (The SQL Plan) 1) Introduction and Goal 2) What is a SQL execution Plan? 3) Can we understand step by step how SQL Query plan is created and executed? 4) Ok, so where do I start from? 5) What is a Table Scan (Operator number 1)? 6) Can performance increase by adding a unique key for table scans?

SQL Query Optimization FAQ Part 1 (With video explanation)

http://www.codeproject.com/Articles/55505/SQL-Query-Optimization-FAQ-Part-1-With-video-expla