-- I have added DateInserted and Address columns to show how to remove all old records for the same person

--drop table #DuplicateRow

CREATE TABLE #DuplicateRow(

ID INT identity(1,1),

DateInserted Datetime,

FName varchar(30),

LName varchar(30),

JobTitle...

In this example I am sorting by Year And Month. just by including month number in GROUP BY am now able to sort by year and month number. I don't...

Deleting as fast as possible:

Two suggestions 1) log(ldf) and data(mdf) files on physically separate disks.

2) Partition the table so that records to be deleted are distributed among several spindles

if possible,...