SQL Server Index Fragmentation and Maintenance Plan

July 31, 2019

Author: Hari Saran Manandhar  Index in SQL Server  Indexes play a vital role in the performance of SQL Server applications. Indexes are created on columns in tables or views and provide a quick way to look up data based on the values of those columns. It is an on-disk structure that comprises of keys that… Continue reading SQL Server Index Fragmentation and Maintenance Plan

How to Remove Duplicate Rows from a SQL Server Table

March 31, 2019

Hari Saran Manandhar Introduction  It is best not to have an SQL Server table containing duplicate rows as per the database design best practices. During the database design process primary keys/Unique Keys should be created to eliminate duplicate rows. However, sometimes we need to work with databases where these rules are not followed, or exceptions are possible (when these rules are bypassed… Continue reading How to Remove Duplicate Rows from a SQL Server Table