Replication is a server-based tool that you can use to synchronize data between two or more databases. Replication can send data from one SQL Server instance to another There are 3 types of Replication Snapshot Replication Snapshot replication is also known as static replication. Snapshot replication copies and distributes data and database objects exactly as they […]
Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command. TRUNCATE TRUNCATE is faster and uses fewer system and transaction […]
Integrity is all about maintaining a consistent state of your data. Here are some types of integrity that can be defined on data. Entity Integrity Entity integrity involves the structure (primary key and its attributes) of the entity. If the primary key is unique and all attributes are scalar and fully dependent on the primary […]
When it comes time to analyze the performance of a specific query, one of the best methods is to view the query execution plan. A query execution plan outlines how the SQL Server query optimizer actually ran (or will run) a specific query. There are several different ways to view a query’s execution plan. They […]