SQL: Identify & Remove Duplicate data from a SQL Table
Duplicate data, as the name suggests, refers to the presence of identical records in a table. OR We label a row as duplicated when it is inserted into a table again, even though an identical entry already exists within that table
Read MoreSQL Server Data Management: Monitoring Delete and Truncate Operations
Tracking data deletions or truncations in SQL tables can be a challenging task, as it becomes difficult to identify the responsible party. While delete triggers offer a solution by capturing deleted data information,
Read MoreSELECT INTO (vs) INSERT INTO SELECT in MS-SQL Server
Before getting into the concept first let us understand the number of ways to insert data into the MS SQL Server table 1. Using any ETL Tools: Such as SSIS, Informatica
Read MoreCurrently running querys in MS SQL Server
The Query below helps fetching the currently running SQL Queries
Read More
Nice Format and information.
ReplyDelete