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

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

Transparent data encryption (TDE) introduces a new database option that encrypts the database files automatically, without needing to alter any applications...

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

Relational Database Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained...

GHOST originally was a protocol modification, a chain selection rule, that makes use of blocks that are off the main chain to obtain a more secure and scalable system...