Currently browsing category

Performance Tuning, Page 2

SQL Server Resource Governor

Microsoft has introduced an interesting and exciting new feature in SQL Server 2008; it is named the Resource Governor. It allows the …

SQL Server Memory

SQL Server divides the total memory dedicated to it into two parts referred to as Buffer Pool and Memory to Leave. Buffer …

SQL Server Tempdb Management

Some Facts about TempDB The tempdb is a temporary workspace which is normally used for: • Storage of explicitly created temporary tables. …

SQL Server Optimistic Concurrency

SQL Server Concurrency Terminology Optimistic concurrency control inside the SQL Server 2005/2008 database engine technically means that row versioning is used instead …