question

saran1087 avatar image
saran1087 asked

Infinite running of patition query

I have a table with 50 million records.I tried to partition this table,but partitioning query is running infinitely.Any help will be highly appreciated. I am using sql server 2008 r2 and have used the below query CREATE PARTITION FUNCTION part_func (numeric(18,0)) AS RANGE left FOR VALUES (1253072,1353072) go CREATE PARTITION SCHEME part_scheme AS PARTITION part_func all TO ([primary]) go --Dropping and creating clustered index based on partition key ALTER TABLE [dbo].[SALES] DROP CONSTRAINT PK_SALES go CREATE CLUSTERED INDEX [PK_SALES] ON [dbo].[SALES] ( SALES_ID )WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [part_scheme]([SALES_ID])
table partition
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
Is it still running? Processing 50 million records could take time depending various variables.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.