Phases of SQL Server 2012 Query Processing
The SQL Server optimizer works out the most efficient execution plan for a given query through parsing, query compilation, query optimization and query execution. Learn more.
Read MoreMost Popular
About SQL Server 2012 Replication Models
SQL Server replication models are used by a company to design its own data replication. Learn more about the options.
Read MoreSQL Server 2012 Distributed Data and Methods for Distributing
In SQL Server, you can distribute data on multiple database servers through distributed transactions or data replication. Learn which method might be best for your environment.
Read MoreSQL Server 2012 High Availability and Disaster Recovery
SQL Server 2012 introduces high availability and disaster recovery (HADR), which allows you to maximize availability for your databases. Learn more.
Read MoreAbout SQL Server Parallel Processing of Tasks
The SQL Server Database Engine can execute different database tasks in parallel, including: bulk loads, backups, query execution, indices. Learn more.
Read MoreAbout SQL Server Row Versioning
The SQL Server Database Engine supports an optimistic concurrency control mechanism (versus pessimistic concurrency) based on row versioning. Learn more.
Read MoreWhen You Might See SQL Server Concurrency Problems
If SQL Server locking isn’t used, and no isolation exists between transactions, you may have concurrency problems such as lost updates, dirty reads, nonrepeatable reads and phantoms. Learn more.
Read MoreGetting Information About SQL Server Locks
The SQL Server DMV sys.dm_tran_locks returns information about currently active lock manager resources. Learn more.
Read MoreUnderstanding SQL Server Lock Escalation
SQL Server lock escalation happens when many locks of the same granularity are held during a transaction, and the Database Engine automatically upgrades these locks into a table lock. Learn more.
Read MoreUnderstanding SQL Server Lock Granularity
SQL Server lock granularity specifies which resource is locked by a single lock attempt. Lock granularity affects concurrency. In general, the more granular the lock, the more concurrency is reduced. Learn more.
Read MoreUnderstanding SQL Server Lock Modes
Lock modes specify different kinds of locks. The choice of which lock mode to apply depends on the resource that needs to be locked. Learn more.
Read MoreThe Nuts and Bolts of Locking in SQL Server 2012
Every DBMS has mechanisms that control the access of data by all users at the same time. The SQL Server Database Engine uses locks to guarantee the consistency of the database. Learn more.
Read More