We help IT Professionals succeed at work.
Get Started

SQL server 2008 table paritioning how to?

146 Views
Last Modified: 2012-09-27
Several new applications are launching, and the company I am working for has purchased an Enterprise Edition license for SQL 2008 R2. I know we will be storing up to 1TB of data in this new application and the data will be trickling in through a web service at about 600 inserts per minute during peak times and a lot less during non peak times. I will need to take advantage of table partitioning as we will need to categorize entities by STATE and CITY, not so much by time. I am told each STATE and CITY will have possibly 1million or more records that will need to be searchable. I will need to get up to speed with table partitions. I am looking for recommendations on great web articles or books that can help me get from beginner to novice to pro in a short amount of time. What great articles \ books have the experts read on partitioning in SQL 2008 EE R2?

Thanks experts!
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE