Microsoft SQL Server

Delete Duplicate Records in SQL

Delete Duplicate Records in SQL There are many ways to delete duplicate records/row in SQL. We are going...

SQL Server script to Rebuild/Reorganize fragmented Indexes

When on a database’s table frequently running INSERT, UPDATE or DELETE queries than we can see indexes on...

Identify the most expensive queries running on table

I was investigating SQL Server performance issue on a table where I was getting more locks, query timeout...

SQL Server find and replace in TEXT or NTEXT fields

Replace function in SQL | TEXT or NTEXT fields We often use replace function in SQL server databases...

SQL query to find largest table in database

Find largest table in a SQL Server database? Monitoring table size over time is very important to the...

Update statistics with full Scan all tables in sql server database

full Scan all tables in sql server database We all know to keep auto statistics update ON for...