2009 年 9月 30 日随笔档案 - Edison Zhu

2009年9月30日

[转载] Moving table to a different filegroup in SQL 2005

摘要： source article: http://decipherinfosys.wordpress.com/2007/08/14/moving-tables-to-a-different-filegroup-in-sql-2005/In SQL Server 2005, a new clause ‘MOVE TO’ was added to the ALTER TABLE c... 阅读全文

posted @ 2009-09-30 18:39 Edison Zhu 阅读(266) 评论(0) 推荐(0) 编辑

[转载] SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table

摘要： surce article: http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/have received call from my DBA friend who read my... 阅读全文

posted @ 2009-09-30 01:02 Edison Zhu 阅读(339) 评论(0) 推荐(0) 编辑

[转载] SQL SERVER – 2005 – Introduction to Partitioning

摘要： original article: http://blog.sqlauthority.com/2008/01/24/sql-server-2005-introduction-to-partitioning/Partitioning is the database process or method where very large tables and indexes are divided in... 阅读全文

posted @ 2009-09-30 00:33 Edison Zhu 阅读(201) 评论(0) 推荐(0) 编辑