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

SQL Server Express supports a maximum size of 4 GB per database...

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

TABLESAMPLE allows you to extract a sampling of rows from a table in the FROM clause. The rows retrieved are random and they are not in any order...

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

SQL Server Audit offers features that help DBAs achieve their goals of meeting regulatory compliance requirements. SQL Server Audit provides centralized storage..

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

SQLCMD utility is a command prompt utility to run ad-hoc T-SQL statements and scripts. You can also run sqlcmd interactively...

The extensible key management (EKM) feature allows third-party enterprise key management and hardware security module (HSM) vendors to register their devices in SQL Server...

The OFFLINE directive is a new feature of the ALTER DATABASE command. This allows databases that employ multiple filegroups to be online serving queries...

There are a couple of ways to start SQL Server in single-user mode..

In Ms Sql, VIEW s or Views are virtual tables. They can be used just like a table, but they do not have the definition or structure of a table..

In Ms Sql the CASE WHEN structure is often used to set the value of a column based on values in other columns or variables..

Although using Stored Procedure in Ms sql is beneficial in many ways, it also has disadvantages in some issues...

Using Stored Procedure in ms sql provides many benefits. Below are the main benefits. It can reduce interference in application code..