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 […]
The process of optimizing a stored procedure is much like the process for optimizing a query, with a few differences. If a sproc was running well, but slowed down, it will probably benefit from being recompiled. This can be accomplished in 2 ways: Run the system stored procedure sp_recompile against the sproc. This will cause […]