admin
Get flash to fully experience Pearltrees
Регламентные операции на уровне СУБД для MS SQL Server
Домашняя Статьи Регламентные операции на уровне СУБД для MS SQL Server Статьи - Технология разработки 1С, обслуживаниеTable fragmentation can occur when modifying data with INSERT, UPDATE, or DELETE statements, which over time cause gaps in each page. If a query search is based on a table scan or partial table scan, then it will create overhead for the SQL Server process with additional page reads, leading to high CPU activity and unresponsiveness. Defragmentation targets logical fragmentation at the leaf level of an index, ensuring optimum performance.
How to Detect Table Fragmentation in SQL Server 2000 and 2005
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. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same. Here’s my small gift for all my .NET friends, a complete 400 pages FAQ Ebook which covers various .NET technologies like Azure, WCF, WWF, Silverlight, WPF, SharePoint and lots more from here Quick video to jump start SQL Server performance tuning
SQL Query Optimization FAQ Part 1 (With video explanation) - CodeProject