Sql Server Table Partitioning
-
Hi, Good morning. Would you please shed some light on the question I have on partitioning a table? I have a table with a size of 1.2 GB with 3.7 million rows. My question is whether it is a candidate for partitioning it? I thank you in advance for your help. Have a nice day. Regards.
-
Hi, Good morning. Would you please shed some light on the question I have on partitioning a table? I have a table with a size of 1.2 GB with 3.7 million rows. My question is whether it is a candidate for partitioning it? I thank you in advance for your help. Have a nice day. Regards.
-
Hi, Good morning. Would you please shed some light on the question I have on partitioning a table? I have a table with a size of 1.2 GB with 3.7 million rows. My question is whether it is a candidate for partitioning it? I thank you in advance for your help. Have a nice day. Regards.
Read this article from Microsoft ... http://technet.microsoft.com/en-us/library/dd578580(SQL.100).aspx[^]
-
What do you mean by partitioning a table? Filtering,sorting?
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
-
Hi, Good morning. Would you please shed some light on the question I have on partitioning a table? I have a table with a size of 1.2 GB with 3.7 million rows. My question is whether it is a candidate for partitioning it? I thank you in advance for your help. Have a nice day. Regards.
-
Hi, Good morning. Would you please shed some light on the question I have on partitioning a table? I have a table with a size of 1.2 GB with 3.7 million rows. My question is whether it is a candidate for partitioning it? I thank you in advance for your help. Have a nice day. Regards.
Do you have an obvious partitioning column?
-
Do you have an obvious partitioning column?
-
Read this article from Microsoft ... http://technet.microsoft.com/en-us/library/dd578580(SQL.100).aspx[^]
-
countmein wrote:
My question is whether it is a candidate for partitioning it?
Yes, it is.
Bastard Programmer from Hell :suss:
-
Thank you for your replies. Yes, I do have a column(primary key) that starts from 1 and automatically generated by adding 1.
That's not really the best partitioning column. What you want is to partition the table so that queries is only fetching or inserting data to and from one partition at a time, if possible. For example, If you want to partition a sales table, the date column would normally be a good choice. Most updates, inserts and queries would be done on the current year partition.