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 […]
What is an OLTP database? OLTP-(On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE).The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed […]