use below code to create primary key on existing table.

ALTER TABLE <table name>

ADD PRIMARY KEY (<column name>)

but the column you are going to specify in syntax should not have duplicate...

Hi,

Index creation on date column and table partition would be a better option for creating reports on a big table.

Hi,

I had came across similar scenario but different case(moving older that 30 days data from source table).

Mass deletion using delete command will take huge time and if the date column...

Hi,

Just add 7 packages to the SQL Agent as a job with different steps and schedule it according to your requirement.