Forthcoming UK SQL User Group Meetings – Leeds, Edinburgh, London

Regional Meetings of the UK SQL Server User Group coming up in the next couple of weeks:   LEEDS AREA SQL SERVER USER GROUP: THURSDAY 29TH MAY 18:30 – 21:00 : LEEDS http://sqlserverfaq.com/?eid=116   Martin Bell – Whats New in SQL Server 2008 T-SQL. Martin Will talk about some of the many new features in…

1

SQL Server Locking

Locking is a mechanism used by the Microsoft SQL Server Database Engine to synchronize access by multiple users to the same piece of data at the same time. Before a transaction acquires a dependency on the current state of a piece of data, such as by reading or modifying the data, it must protect itself…

2

SQL Server Statistics

SQL Server 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. Good statistics allow the optimizer to accurately assess the cost of different query plans, and choose a high-quality plan….

7

SQL Server and Windows Memory

SQL Server 2000 Enterprise Edition introduced support for the use of Windows 2000 Address Windowing Extensions (AWE) to address 8GB of memory on Windows 2000 Advanced Server and 32GB of memory on Windows 2000 Datacentre. With AWE, SQL Server can reserve memory not in use by other applications and the OS. Each instance must statically allocate…

2

DBCC CHECKDB

DBCC CHECKDB checks the logical and physical integrity of all objects in the specified database by performing the following: Runs DBCC CHECKALLOC on the database Runs DBCC CHECKTABLE on every table and view in the database Runs DBCC CHECKCATALOG on the database Validates the contents of every indexed view in the database Validates the service…

2

Windows Failover Clustering Overview

The host node in the failover cluster performs a “looks alive” check every 5 seconds. An IsAlive check is performed every 60 seconds using SELECT @@SERVERNAME. If this fails the IsAlive retries 5 times and then attempts to reconnect to the instance of SQL. If all fail, then the SQL Server resource fails. Depending on…

3