I haven't really try this either, just an idea

1. Backup Strategy

If you use full recovery model, maybe you can seperate the tables you want to backup into a new filegroup...

Actually the initial size is only affecting your initialization time for the replication to take place, what really count is the changes that happened in the database.

The strategy will be...

What I mean is not a combination temp table and while loop but temp table with an bulk update statement with help of variable, is it the same as while...

Not really looking in detail but

I think it should be a store procedure.

And I quite sure we can eliminated the cursor using temp table and update and set variables in...

Yeah you should check the actual query plan.

One more thing maybe you should check the amount of IO or scanning actually happened using Set statistics io on then execute your...

Hi Pratap,

Sory i didn't give you the full formula, here it is :

select convert(varchar(10),dateadd(dd,-datepart(dw,SalesDate)+2,SalesDate),101) + '-' + convert(varchar(10),dateadd(dd,datepart(dw,SalesDate)+2,SalesDate),101)

The formula will be like that but the constanta 2 is depend on...

I think when you want the report month wise you can use group by datepart(yyyy, SalesDate), datepart(mm, SalesDate), also the same for week group by datepart(yyyy, SalesDate), datepart(wk, SalesDate)

But...

you can try,

select a.* from Table2 a left join Table1 b on a.email like '%' + b.domain

where b.id is null

rgds,

ZL