Loading

摘要: I have received call from my DBA friend who read my articleSQL SERVER – 2005 – Introduction to Partitioning. He suggested that I should write simple tutorial about how to horizontal partition database table. Here is simple tutorial which explains how a table can be partitioned. Please read my articl 阅读全文
posted @ 2011-03-10 17:09 .net's 阅读(606) 评论(0) 推荐(0)
摘要: 【鹏城万里】 发表于www.sqlstudy.comSQL Server 2005 分区表实践——建立分区表(partition table)问题:有一个订单表 Orders,要转换成分区表,以订单日期 OrderDate 为分区列, 目前含有订单日期为 1996-07-04 ~ 1998-05-06 的数据。可以在 SQL Server 2000 Northwind 数据库中找到 Orders 表,下面是简化了的表结构:create table dbo.Orders( OrderID int not null ,CustomerID varchar(10) not null ,Employe 阅读全文
posted @ 2011-03-10 16:58 .net's 阅读(598) 评论(0) 推荐(0)