The Resource Governor is a feature given by SQL Server to control and allocate CPU and memory resources depending on the priority of applications...

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...

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...

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...

In principle, they are the same and are handled in the same way by your application. The only difference is that NVARCHAR can handle Unicode characters, allowing...