Great. is the developer edition is free of cost or do i need to purchase any license?

Thanks Lynn. But when i try to drop the partition scheme , it keep on says it's not empty and it cannot be dropped. Could you please suggest me the...

Hello bhuvnesh,

I have removed the indexes on the table level. The result of below query returns no row.

select distinct t.name

from sys.partitions p

inner join sys.tables t

on p.object_id = t.object_id

where p.partition_number <>...

H Gila,

Thanks for your answer. I would like to for step3. also i tried step 3 yesterday. the problem is i am unable to remove the partition and...

Thank you Lynn. I will try that.

Hi Gila,

no where i can drop the partitioning in production as it is being used now. any other hope please ?

Thank you Bhuvesh,

is it possible to take only schema backup without partition?

Yes Jeff,

I totally agree your statement and thanks a lot for all your time on this thread. Really it helped me in many aspects and learning about different concepts.

Once again...

Hi Jeff,

am back,

i got one more tricky situation from my client. i frightened to hear about this concept from them. the concept will be i will have to take the...

Hi Jeff,

WOW!!!!

Thanks a lot for your precious time on this post and really this is going to help many users. I just back from my sick days to work....

Hi Jeff,

Thanks a lot for your time on this and product_name on the table1 is unique.

Hi Livingston,

my bad. i didn't realize your set up data. The data is perfect but it's not cornil. it should be corn on the last insert row.

Hi Livingston,

thanks for your time on this and i have tried whatever you have shown couple of days before, the problem is time consuming and how to fasten the search...

Hi Gila,

Thanks for your time,

The problem now is that production rolled out. so at this point of time the table design cannot be changed. looking for some temp solution.

Any hope.....

Hi Jeff,

Thanks a lot for your time on this and from temp table i am taking data and doing some other process. that will not be a deal. the actual...