got it ...

select dateadd(year, -1, getdate())

Thank you

thanks for the response... I m trying weird commands like select getdate()-1 or year(getdate())-1)...

still I m trying to search BOL....if you could help me thats gr8 for me...

you can try replicating using scripts....in sp_addarticle you have @verticalPartition clause which allows you to filter the columns....may be you can google sp_addarticle.....

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

This was given by Gila Monster to one of my posts......it works perfect for parameter sniffing....

did you try sp_browsereplcmds ..............it should give you an idea where the error is..??

it's great that you have got lot of time...JK

I know, the import and export wizard creates some temporary files, may be you are missing one of those temp files...generally, if you restart the server, all the temp files...

wow...Thank you very much for your quick reply....This is perfect...and Thanks a lot for your valuable suggestion ...I got it....

this is not for the test environment.....for production...testing everything was fine...but in production, somethimes they take long to finish execution...so may be I will log to a table with getdate()

hmm yeah....may be I will try this....Thank you

Thank you very much GilaMonster....It works superb...Thanks a lot..

Thank you for all your replies and help....After keen working out on this, I found an issue...I m giving 2 queries here...1st query, In the where condition I gave the...

Indexes are same, But the data is different. and there is no much difference in data. say, it has 5 tables which are of total size 30gb in prod and...

Thanks for the quick reply..... Yeah...I already did that...But Still I m getting the same results...

Thanks for your valuable suggestion. This sound really good.

the page_count is 37,358.