troubleshooting Question

SQL server 2008 table paritioning how to?

Avatar of sqlagent007
sqlagent007Flag for United States of America asked on
Microsoft SQL Server 2008
3 Comments1 Solution148 ViewsLast Modified:
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!
ASKER CERTIFIED SOLUTION
Ramesh Babu Vavilla

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros