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 […]
What is an event handler? It is a workflow that responds programmatically to events that occur on a package level, container level, task level or change of variable value What is MSDTC? The built-in transaction support in SSIS makes use of the Distributed Transaction Coordinator (MSDTC) service which must be running for the transaction to […]
What is the difference between Fuzzy Lookup and Fuzzy Grouping? Fuzzy Lookup is used to find clean data. Fuzzy Grouping is used to remove duplicate data. Fuzzy Lookup works on a row by row basis. Fuzzy Grouping works on rows within a group. Fuzzy Lookup uses a clean reference source as well as its input. […]