sql server
youzi8800
这个作者很懒,什么都没留下…
展开
-
sql2005创建,删除分区表
--创建------------------------------------------------------------------创建文件组ALTER DATABASE PCCarer ADD FILEGROUP [Architectureamd64]GoALTER DATABASE PCCarer ADD FILEGROUP [Architectureia64]GoALTER DATABASE PCCarer ADD FILEGROUP [Architecturex64]GoALTER DATA原创 2010-07-22 17:35:00 · 791 阅读 · 0 评论 -
sql 执行语句性能测试
<br />SET STATISTICS io ON<br />SET STATISTICS time ON<br />go<br /> ---要测试的sql语句<br />select * from Driver_Device1 where ProcessorArchitecture = 'x86' <br />and DeviceID = 'PCI/VEN_14e4&DEV_16C6' and OSVersion = '5.1'<br />go<br />SET STATISTICS profile O原创 2010-07-22 17:35:00 · 429 阅读 · 0 评论