How to Check Index Fragmentation in a SQL Server Database

How to Check Index Fragmentation in a SQL Server Database

When on a database's table frequently running INSERT, UPDATE or DELETE queries than we can see indexes on the particular table are fragmented and the SQL query may run slower as they may choose non-optimal execution plan. The below script can be used for checking how much percentages of an indexes gets fragmented on a database. so that we can rebuild or reorganize the indexes....

Read More
Delete Duplicate Records in SQL

Delete Duplicate Records in SQL

There are many way to delete duplicate records/row in SQL. We are going to explain the query to delete the duplicate record in table. Hare we use Common table expression method So in this way we can maintain consistency and accuracy of data in database....

Read More