Currently browsing category

Temporary Database

SQL Server TSQL Temporary Table

Temp tables in SQL Server: they are just like any normal tables except that they are created in the TempDB database. They …

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 …