In SQL Server Integration Services (SSIS) a workflow is called a controlflow. Control-flow links together our various data-flows as a series of operations...

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

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

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

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

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

VARCHAR stores variable-length character data whose range varies up to 8000 bytes; varchar(MAX) stores variable-length character data whose range may vary beyond 8000...

Service Broker is a message-queuing technology in SQL Server that allows developers to integrate SQL Server fully into distributed applications...

SQL Server blocking occurs when one connection places a lock on a table (or selected rows, pages, extend) and another connection attempts to read or...

A sparse column is another tool used to reduce the amount of physical storage used in a database. They are the ordinary columns that have optimized...

The maximum columns per table are 1024 in SQL Server..

SQL Server introduced a new method of administering multiple servers by enabling you to designate a Central Management Server..

A "FILLFACTOR" is one of the important arguments that can be used while creating an index...

Change data capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes..

The SQL Server Utility models an organization’s SQL Server-related entities in a unified view. Utility Explorer and SQL Server Utility viewpoints in...