代码的魅力

BI, .NET

导航

09 2010 档案

How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2005

摘要：http://msdn.microsoft.com/en-us/library/aa964122.aspxMicrosoft CorporationMarch 2006Applies To: SQL Server 2005Summary: This article shows how to implement an automatic sliding window in a partitioned... 阅读全文

posted @ 2010-09-19 16:50 moge 阅读(447) 评论(0) 推荐(0)

SQL Server 2005 Partitioned Tables and Indexes

摘要：http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htmSummary: Although partitioning tables and indexes has always been a design tactic chosen to improv... 阅读全文

posted @ 2010-09-19 15:02 moge 阅读(382) 评论(0) 推荐(0)

如何估算数据库的大小

摘要：--得到数据库中所有表的空间/记录情况 exec sp_MSForEachTable @precommand=N ' create table ##( id int identity, 表名 sysname, 字段数 int, 记录数 int, 保留空间 Nvarchar(10), 使用空间 varchar(10), 索引使用空间 varchar(10), 未用空间 va... 阅读全文

posted @ 2010-09-19 14:56 moge 阅读(1636) 评论(0) 推荐(0)

MSDN链接

摘要：SSISPackage Configurations Lesson 3: Adding Package ConfigurationsUnderstanding Integration Services Package Configurationsdtexec 实用工具SQL Server 2008 R2 中 Integration Services 功能的行为更改Sql Server基础xp_cm... 阅读全文

posted @ 2010-09-14 16:09 moge 阅读(168) 评论(0) 推荐(0)

Enabling Change Data Capture

摘要：Before a capture instance can be created for individual tables, a member of the sysadmin fixed server role must first enable the database for change data capture. This is done by running the stored pr... 阅读全文

posted @ 2010-09-10 13:12 moge 阅读(425) 评论(0) 推荐(0)

SQL Server 操作集锦

摘要：select @@version 查看数据库版本CHECKSUM ( * | expression [ ,...n ] ) 返回在表的行上或在表达式列表上计算的校验值。CHECKSUM 用于生成哈希索引，可用于表full match。Update与Select联合使用： update dbo.Monthly_Revenue_Detail set Revenue_Amount= b.Revenue... 阅读全文

posted @ 2010-09-10 13:10 moge 阅读(229) 评论(0) 推荐(0)