With failover clustering, the nodes share disks, but only a single node has access to the database at a time. It is possible to install additional...

Log shipping is the process of automating the backup of database and transaction log files on a production SQL server and then restoring them onto a standby server...

SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and...

Table-Valued Parameter is a new feature introduced in SQL SERVER. In earlier versions of SQL SERVER, it is not possible to pass a table variable in a stored...

INTERSECT operator in SQL Server is used to retrieve the common records from both the left and the right query of the Intersect Operator...

In SQL Server, the functionality of non-clustered indexes is extended by adding non-key columns to the leaf level of the non-clustered index. Non-key columns...

Master database is a system database and it contains information about running server’s configuration. When SQL Server is installed, it usually creates master...

It is an index that can satisfy a query just by its index keys without having needed to touch the data pages is called Covering Index. It means that when a query is fired...

Filestream allows you to store unstructured large objects (text documents, images, and videos) in the file system and have these files integrated within the database...

The XML data type lets you store XML documents and fragments in a SQL Server database. An XML fragment is an XML instance that has a missing single top-level element...

RAISERROR generates an error message and initiates error processing for the session. RAISERROR can either reference a user-defined message stored in the...

When Exclusive Lock is on any process, no other lock can be placed on that row or table. Every other process has to wait till Exclusive Lock completes its tasks...

To minimize the cost of opening and closing connections, ADO.NET uses an optimization technique called connection pooling. The pooler maintains ownership of the physical connection...

The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns...

Views are a description of the data(metadata). When a view is a reference in the FROM clause its metadata is retrieved from the system catalog and placed into query...

Online operation means when online operations are happening the database is in normal operational condition, the processes which are participating in online...

MERGE is a new feature that provides an efficient way to perform multiple DML operations in a single statement. In previous versions of SQL Server...

Synonyms give you the ability to provide alternate names for database objects. You can alias object names; for example, using the Employee table as Emp...

There are 3 types of wait types...

CHECKPOINT process writes all in-memory dirty pages for the current database to disk. Dirty pages are data pages that have been entered into the buffer...