Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL Server 2005 ·ÖÇø±íʵ¼ù——·ÖÇøÇл»


±¾ÎÄÑÝʾÁË SQL Server 2005 ·ÖÇø±í·ÖÇøÇл»µÄÈýÖÖÐÎʽ£º
1. Çл»·ÖÇø±íµÄÒ»¸ö·ÖÇøµ½ÆÕͨÊý¾Ý±íÖУºPartition to Table£»
2. Çл»ÆÕͨ±íÊý¾Ýµ½·ÖÇø±íµÄÒ»¸ö·ÖÇøÖУºTable to Partition£»
3. Çл»·ÖÇø±íµÄ·ÖÇøµ½ÁíÒ»·ÖÇø±í£ºPartition to Partition¡£
²¢Ö¸³öÁËÔÚ·ÖÇø±í·ÖÇøÇл»¹ý³ÌÖеÄ×¢ÒâÊÂÏî¡£
-- ´´½¨·ÖÇøº¯Êý
create partition function PF_Orders_OrderDateRange(datetime)
as
range right for values (
'1997-01-01',
'1998-01-01',
'1999-01-01'
)
go
-- ´´½¨·ÖÇø·½°¸
create partition scheme PS_Orders
as
partition PF_Orders_OrderDateRange
to ([primary], [primary], [primary], [primary])
go
-- ´´½¨·ÖÇø±í
create table dbo.Orders
(
OrderID int not null
,CustomerID varchar(10) not null
,EmployeeID int not null
,OrderDate datetime not null
)
on PS_Orders(OrderDate)
go
-- ´´½¨¾Û¼¯·ÖÇøË÷Òý
create clustered index IXC_Orders_OrderDate on dbo.Orders(OrderDate)
go
-- Ϊ·ÖÇø±íÉèÖÃÖ÷¼ü
alter table dbo.Orders add constraint PK_Orders
primary key (OrderID, CustomerID, OrderDate)
go
-- µ¼ÈëÊý¾Ýµ½·ÖÇø±í
insert into dbo.Orders
select OrderID, CustomerID, EmployeeID, OrderDate
from dbo.Orders_from_SQL2000_Northwind --£¨×¢£ºÊý¾ÝÀ´Ô´ÓÚ SQL Server 2000 ʾÀýÊý¾Ý¿â£©
go
-- ²é¿´·ÖÇø±íÿ¸ö·ÖÇøµÄÊý¾Ý·Ö²¼Çé¿ö
select partition = $partition.PF_Orders_OrderDateRange(OrderDate)
,rows = count(*)
,minval = min(OrderDate)
,maxval = max(OrderDate)
from dbo.Orders
group by $partition.PF_Orders_OrderDateRange(OrderDate)
order by partition
go
Ò»¡¢Çл»·ÖÇø±íµÄÒ»¸ö·ÖÇøµ½ÆÕͨÊý¾Ý±íÖУºPartition to Table
Ê×ÏȽ¨Á¢ÆÕͨÊý¾Ý±í Orders_1998£¬¸Ã±íÓÃÀ´´æ·Å¶©µ¥ÈÕÆÚΪ 1998 ÄêµÄËùÓÐÊý¾Ý¡£
create table dbo.Orders_1998
(
OrderID int not null
,CustomerID varchar(10) not null
,EmployeeID int not null
,OrderDate datetime not null
) on [primary]
go
create clustered index IXC_Orders1998_OrderDate on dbo.Orders_1998(OrderDate)
go
alter table dbo.Orders_1998 add constrai


Ïà¹ØÎĵµ£º

SQL ServerÃæÊÔÌâÕûºÏ

3¡£±íÄÚÈÝÈçÏÂ
-----------------------------
ID            LogTime
1            2008/10/10 10:00:00
1            2008/10/10 10:03:00
1            2008/10/10 10:09:00
2 ¡ ......

perlÀûÓÃÄÚ´æÊ¹ÓÃsqlÓï¾ä

 ´ó¼ÒºÃ£¡×î½üÓÖÓÐÁËһЩģ¿éÓ÷¨µÄÐĵã¬ÄǾÍÊÇÀûÓÃÄ£¿éʹÄãµÄÄÚ´æ±ä³ÉÒ»¸öÐéÄâµÄÊý¾Ý¿âģʽ£¬Ê¹Äã¿ÉÒÔÔÚûÓÐÊý¾Ý¿âµÄÇé¿öÏ£¬½«txtÎļþµÄÊý¾Ý½øÐÐ sqlÓï¾ä´¦Àí£¬¸Ð¾õºÜÐÂÏʰɣ¬²»¹ýÕâ¸ö²»Óøе½¾ªÑÈ£¬PerlÒ»Ö±ÊǺÜÍêÃÀµÄ£¬¹þ¹þ£¬ÄÇÎÒÃǾÍÀ´¿´¿´Õâ¸öÉñÆæ°É£¡
ÐèÒª°²×° Ä£¿é£º
SQl::Library;
DBI 
ÏÂÃæÊdzÌÐò ......

SQL·Ö×éÅÅÐò

 
½ñÌìÓöµ½¸öÓÐÒâ˼µÄÎÊÌ⣬ÊÇÒ»¸ö·Ö×éÅÅÐòµÄÎÊÌ⣬²»¹ýÒªÇó·Ö×éºÍ·Ö×é¼äÒ²ÒªÅÅÐò£¬Èç¹ûÕâ¸ö×éÄÚÓÐÒ»ÌõÊý¾ÝÊÇ×î½ü¸üеģ¬ÄÇôÕâÕû¸ö×é¶¼Ó¦¸ÃÅÅÔÚÇ°Ãæ¡£
ÏÂÃæÒÔOracleµÄHRʾÀýSchemaÖеÄemployees±íΪÀý£º
Óï¾ä°´²¿ÃÅ·Ö×飬·Ö×éÖ®¼äµÄÅÅÐòÊÇÕâÑùµÄ£ºÈç¹ûÕû¸ö·Ö×éÖÐÓÐÒ»¸öÔ±¹¤µÄhire_dateÊÇ×îеģ¬ÄÇôÕâ¸ö·Ö×é¾ÍÓ¦ ......

SQLÊý¾Ý¿â·þÎñÆ÷µÄ°²È«²ßÂÔ ±£»¤Êý¾Ý°²È«

 SQL Server 2000µÄ°²È«ÅäÖÃÔÚ½øÐÐSQL Server 2000Êý¾Ý¿âµÄ°²È«ÅäÖÃ֮ǰ£¬Ê×ÏȱØÐë¶Ô²Ù×÷ϵͳ½øÐа²È«ÅäÖ㬱£Ö¤²Ù×÷ϵͳ´¦ÓÚ°²È«×´Ì¬¡£È»ºó¶ÔҪʹÓõIJÙ×÷Êý¾Ý¿âÈí¼þ(³ÌÐò)½øÐбØÒªµÄ°²È«ÉóºË£¬±ÈÈç¶ÔASP¡¢PHPµÈ½Å±¾£¬ÕâÊǺܶà»ùÓÚÊý¾Ý¿âµÄWebÓ¦Óó£³öÏֵݲȫÒþ»¼£¬¶ÔÓڽű¾Ö÷ÒªÊÇÒ»¸ö¹ýÂËÎÊÌ⣬ÐèÒª¹ýÂËһЩÀàËÆ&ld ......

SQL Server 2005ÀûÓ÷ÖÇø¶Ôº£Á¿Êý¾ÝµÄ´¦Àí


³¬´óÐÍÊý¾Ý¿âµÄ´óС³£³£´ïµ½Êý°ÙGB£¬ÓÐʱÉõÖÁÒªÓÃTBÀ´¼ÆËã¡£¶øµ¥±íµÄÊý¾ÝÁ¿ÍùÍù»á´ïµ½ÉÏÒڵļǼ£¬²¢ÇҼǼÊý»áËæ×Åʱ¼ä¶øÔö³¤¡£Õâ²»µ«Ó°Ïì×ÅÊý¾Ý¿âµÄÔËÐÐЧÂÊ£¬Ò²Ôö´óÊý¾Ý¿âµÄά»¤ÄѶȡ£³ýÁ˱íµÄÊý¾ÝÁ¿Í⣬¶Ô±í²»Í¬µÄ·ÃÎÊģʽҲ¿ÉÄÜ»áÓ°ÏìÐÔÄܺͿÉÓÃÐÔ¡£ÕâЩÎÊÌâ¶¼¿ÉÒÔͨ¹ý¶Ô´ó±í½øÐкÏÀí·ÖÇøµÃµ½ºÜ´óµÄ¸ÄÉÆ¡£µ±±íºÍË÷Òý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ