https://www.simple-talk.com/sql/performance/execution-plan-basics/

I think, this is help for you.

can you elaborate your question?.

Hi Sturner,

Thanks for your reply.

Table already existed and having 86 millions data so already table have primary key with clustered index on ID column , so not possible to remove...

Waiting for your answers ...

thanks

Any reply pls.....?

Hi All,

Can any one explain on it?

I have taken "TestPartition" Database backup (In that db , 5 table are partitioned with 10 file-groups(.ndf files)) then I executed below command

RESTORE FILELISTONLY FROM disk='D:\DB\Backup\TestPartition.bak'

It is showing only mdf...

Easy one ..... +1

It seems ... you dont have permission for creating .mdf and .ldf files in C drive(C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\AdventureWorksDW.mdf').

So login with administrator or change the mdf and ldf...

By using this below scripts.It showing data from each partition

--Getting each partitin record count

SELECT $PARTITION.testfn1(LMD) AS Partition,

COUNT(*) AS [COUNT] FROM tblPart2

GROUP BY $PARTITION.testfn1(LMD)

ORDER BY Partition ;

OutPut

PartitionCOUNT

1 ...

I executed this one also, Partition not removed .

ALTER TABLE [dbo].[tblPart2] DROP CONSTRAINT [PK_tblPart2]

GO

ALTER TABLE [dbo].[tblPart2] ADD CONSTRAINT [PK_tblPart2] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

I rebuild the clustered index. Event though , partition is not removed. I used the below script for rebuilding the index.

ALTER INDEX [PK_tblpart2] ON [dbo].[tblpart2] REBUILD WITH...

you mean, Rebuilding the index or table,

I have no idea, how to rebuild "Table" and verified in msdn for re-building the table , I didn't get any information on...

For removing the partition: I had dropped the non clustered index on partitioned column and created non clustered index with primary file group. even though partitioned is not...

For removing the partition: I had dropped the non clustered index on partitioned column and created non clustered index with primary file group. even though partitioned is not...