In SQL Server is it possible to perform table partition without having to recode or modify the application?
+1
A:
Yes. The application will simply see a single table, so no changes are required to your application.
Partitioned Tables and Indexes in SQL Server 2005
Partitioned Table and Index Strategies Using SQL Server 2008
Mitch Wheat
2010-03-01 01:22:01
So how does INSERT, UPDATE and DELETE work?
K001
2010-03-01 02:31:57
@khou: Your original question asks if it makes any difference: the answer is No. If you want an answer to a different question, may I suggest you ask a separate question.
Mitch Wheat
2010-03-01 02:44:30