Thanks Mike

Unfortunately I don't have a backup :-(, I will go through the link and update you...

Thanks Eralper

How can I achieve this one, when i tried to create a table on a different partition its...

Thanks Guys

I have done it, I have created the table...

Thanks Gail

I have tried with the clustered index as well, but when i...

Thanks Paul , yes this are new execution plans, with updated stats, can you tell me what difference will it make for an SQL if it takes a clustered and...

true , Currently I am having a Primary key Clustered, if I change this to primary key non clustered index what will be the performance impact on this, if we...

Thanks mate, just have a small doubt, i am partitioning the table with date, if this is clustered automatically does that mean i cant have duplicate dates??

Can you please let...

That is a good hint mate, thanks, I dint think through to that extent 🙂 .

Cheers 😀

Thanks Guys. Thanks a lot for clearing my doubts

Cheers

🙂

Thanks Grant, i will have a look 🙂

Thanks a lot 🙂

Thanks Grant, I havent used powershell until now, is there any good place you recommand for me to start to get some sample scripts.

Thanks Imu , It worked a magic

Cool thanks a lot, you made my day 🙂

no Dean , i never used powershell

Thanks guys, i am using CLR, since my string has numerics in any place, so i am just wondering is there any way to use one expression to get this...