Log Shipping is one of the oldest forms of High-Availability Strategy inside SQL Server. The concept here is the primary database on the server...

The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server...

ORDER BY clause does not work in View. ..

There are many tips and tricks for the same...

SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing...

An index scan means that SQL Server reads all rows in a table, and then returns only those rows that satisfy the search criteria...

At the high-level, there are 3 most important backups...

Online PIECEMEAL RESTORE is available from SQL Server Enterprise Edition, this allows administrators of databases that employ multiple...

Database mirroring can be used with replication to provide availability for the publication database. Database mirroring involves two...

Dedicated Admin Connection allows user to connect to SQL server when normal connection attempts fail, for example, when a server is hanging...

The SQLdiag utility is a general-purpose diagnostics collection utility that can be run as a console application or as a service...

The tracking mechanism in change data capture involves an asynchronous capture of changes from the transaction log so that changes...

When a small number of rows are requested by a query, the SQL Server optimizer will try to use a non-clustered index on the column or columns contained...

Using the NOLOCK query optimizer hint is generally considered good practice to improve concurrency on a busy system especially for Reporting workloads...

A view can be thought of as a stored query accessible as a virtual table. It can be used for retrieving data as well as updating or deleting rows. Rows updated...

An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently...

A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers. With a linked server, you can create very clean...

Filtered Index is used to index a portion of rows in a table that means it applies a filter on INDEX which improves query performance...

In Partial Cache Mode, SSIS queries the database against new rows coming in from the source and if matched then that row is cached into SSIS...

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