Features Archives - Himanshu Patel SQL Server consultant Developer DBA Administration

Track data changes using CDC in SQL Server Enterprise edition

Leave a Comment / DB Information, Features / By Himanshu / September 19, 2020 / CDC, Change Data Capture

SQL Server provides two features that track changes to data in a database: change data capture and change tracking. These features enable applications to determine the DML changes (insert, update, and delete operations) that were made to user tables in a database. Change Data Capture configuration settings ● maxtrans* — The maximum number of transactions to process in …

Track data changes using CDC in SQL Server Enterprise edition Read More »

List all assemblies in a database

Leave a Comment / DB Information, Features / By Himanshu Patel / June 22, 2020 / assemblies, assembly_modules

assembly_modules: Returns one row for each function, procedure or trigger that is defined by a common language runtime (CLR) assembly. This catalog view maps CLR stored procedures, CLR triggers, or CLR functions to their underlying implementation. Assemblies (Database Engine) – SQL Server | Microsoft Docs

How to write merge statement in SQL Server

Leave a Comment / Features, Query Type / By Himanshu / May 31, 2020

SQL Server provides the MERGE statement that allows you to perform three actions at the same time. If you use the INSERT, UPDATE, and DELETE statement individually, you have to construct three separate statements to update the data to the target table with the matching rows from the source table. The following shows the syntax …

How to write merge statement in SQL Server Read More »