System Catalog Views, sys.server_principals and sys.sql_logins can show the various users in the system and...

CDC was created to help ETL scenarios by providing support for incremental data load. It uses an asynchronous...

ROLLUP clause is used to do aggregate operation on multiple levels in a hierarchy. If we want to sum on different...

Using CTE improves the readability and enables easy maintenance of complex queries...

CTE is the abbreviation for Common Table Expression. A CTE is an expression that can be thought of as a temporary...

A local temporary table exists only for the duration of a connection, or if defined inside a compound statement...

There are two authentication modes in SQL Server...

The SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). It is...

A deadlock occurs when two or more tasks permanently block each other by having a lock on a resource that...

Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire...

There are 3 different recovery models inside SQL Server...

VARCHARS are variable-length strings with a specified maximum length. If a string is less than the maximum...

A clustered index is a special type of index that reorders the way records in the table are physically stored...

SQL Server runs on port 1433...

OUTPUT clause has accesses to inserted and deleted tables (virtual tables) just like triggers. OUTPUT clause...

The default SQL Server trace from SQL Server 2005 onwards is a background trace that runs continuously and records...

SQL Server introduced the concept of data collector - you can obtain and save data that is gathered from several sources about...

During the installation, there are 3 System Data Collection are made available to DBAs. These to be later configured...

Some of the limitations with Indexed views are...

Transactions specify an isolation level that defines the degree to which one transaction must be isolated from...