How to delete duplicate rows from a table in SQL

Duplicate records can result in unintended outcomes when working with data. Despite data professionals disliking it, this issue is often encountered in data warehouse systems. When loading data from sources…

Read more »

DROP multiple tables using a single DROP statement

The DROP TABLE command can also be used to drop multiple tables in a single statement. Example, Separate each table with a comma in the DROP TABLE statement to drop…

Read more »

How to Convert Seconds to “HH:MM:SS” format in TSQL

Presenting the time/duration in HH:MM:SS format is important for good readability. There are situations where the duration of an event needs to be calculated between time intervals. The difference can…

Read more »

Synonym in SQL Server

Synonym A synonym is an alias or an alternative name given to the other objects in the database. The alternative name can be used to refer to the underlying objects…

Read more »

How to find a column is updated.

In application development, there are situations where an action is driven based on a change in data. A trigger can be used to perform an action based on the data…

Read more »

Grant permission to Integration Service Catalog folder

People often confused that having access to SSISDB will also provide access to the Integration Service Catalog folders but permission for the folder is handled separately. The following code can…

Read more »

DBCC HELP!!

SQL Server has many DBCC commands, administrators use them for maintenance, validation and to collect information about the database, for example, DBCC SHOW_STATISTICS displays statistics for a table. But there…

Read more »

Data file not deleted from filesystem even after DROP DATABASE

When a database is dropped using the DROP DATABASE command, you might have noticed the command completed successfully and of course, the database is dropped but you could still see…

Read more »