===========================================================
SQL SERVER:事件探查器与Server-side Trace
===========================================================
SQL SERVER:事件探查器与Server-side Trace 查看全文
===========================================================
SQL SERVER:事件探查器与RML的使用
===========================================================
使用RML utility可以得到结构化的分析结果，并以图形格式报表输出。
配套软件ReportViewer.exe
===========================================================
华山再高，顶有过路
===========================================================
“华山再高，顶有过路”释义 查看全文
===========================================================
央视配楼工程款因火灾起纠纷
===========================================================
本报讯 (记者刘杰) 央视配楼起火，其工程款引起纷争。记者昨天获悉，朝阳法院判处拖欠工程款的公司支付承包工程的公司剩余工程款120万余元。
===========================================================
批量置Job为无效
===========================================================
使用系统存储过程EXEC dbo.sp_update_job 查看全文
===========================================================
Maximum insert commit size and Rows Per Batch in OLE DB Destination in SSIS
===========================================================
The Maximum insert commit size (MICS) controls how much data is committed in its batches.
So, if you have MICS set to 5000 and you have 9000 rows and you encounter an error in the first 5000 results, the entire batch of 5000 will be rolled back. MISC equates to the BATCHSIZE argument in the BULK INSERT transact-sql command.
Rows Per Batch (RPB) is merely a hint to the query optimizer. The value of this should be set to the actual expected number of rows. RPB equates to the ROWS_PER_BATCH argument to the BULK INSERT transact-sql command.
http://msdn2.microsoft.com/en-us/library/ms188365.aspx
Specifying a value for the MICS will have a few effects. Each batch is copied to the transaction log, which will cause it to grow quickly, but offers the ability to back up that transaction log after each batch. Also, having a large batch will negatively affect memory if you have indexes on the target table, and if you are not using table locking, you might have more blocking going on.
So, if you have MICS set to 5000 and you have 9000 rows and you encounter an error in the first 5000 results, the entire batch of 5000 will be rolled back. MISC equates to the BATCHSIZE argument in the BULK INSERT transact-sql command.
Rows Per Batch (RPB) is merely a hint to the query optimizer. The value of this should be set to the actual expected number of rows. RPB equates to the ROWS_PER_BATCH argument to the BULK INSERT transact-sql command.
http://msdn2.microsoft.com/en-us/library/ms188365.aspx
Specifying a value for the MICS will have a few effects. Each batch is copied to the transaction log, which will cause it to grow quickly, but offers the ability to back up that transaction log after each batch. Also, having a large batch will negatively affect memory if you have indexes on the target table, and if you are not using table locking, you might have more blocking going on.
===========================================================
Load 1TB in less than 1 hour
===========================================================
OVERVIEW
This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the BULK INSERT command with 60 parallel input files, each of approximately 16.67 GB. The best time I got was 50 minutes. Hewlett Packard was kind enough to loan me some time one night on the machine they use to do the TPC-C tests. It is an Itanium2 Superdome with 64 1.6GHZ 9M (Madison) CPUs. For the insert tests the system was equipped with 256GB of RAM. The HP SAN configuration is rated at 14GB per second throughput. You can find the specific configurations at http://tpc.org/tpcc/results/tpcc_result_detail.asp?id=103082701. (Note: The configurations at this site may be updated periodically).
查看全文
===========================================================
适用于SQL Server生产环境DBA的七大技巧
===========================================================
由于SQL Server的普及程度非常高，也出现了大量的辅助工具，让DBA感觉眼花缭乱，为了避免在这些工具堆中不知所措，本文将向那些管理生产系统的DBA提供一些工具选择及使用方面的技巧，让他们的工作变得更简单。 查看全文
===========================================================
Integration Services 高性能策略
===========================================================
本文描述了如何成功的运用性能提高策略来对Microsoft® SQL Server™ 2005 Integration Services(SSIS)的数据整合方案进行优化。 查看全文
===========================================================
SSIS工程师为您揭秘数据流
===========================================================
我上个月有幸参加了在西雅图召开的PASS（Professional Association for SQL Server）峰会。我的同事Matt Masson做了个关于SQL Server 数据集成服务（Integration Services，SSIS）的讲座（下载），现场非常火爆，讲完后他被听众围住了个把小时。他的题目是Maximize Your SSIS Investment with Tuning Tricks and Tips，主要关于提升数据集成包（package）的性能。 他讲了四部分，其中第二部分深入浅出地介绍了SSIS数据流（Data flow）。我估计我国的用户会特别感兴趣这一块，因此在这里分享给你 :-)
查看全文
===========================================================
使用聚集索引和非聚集索引的区别
===========================================================
===========================================================
一些道理
===========================================================
高调做事低调做人 查看全文
===========================================================
阅读使人充实
===========================================================
阅读使人充实
会谈使人敏捷
写作与笔记使人精确
史鉴使人明智
诗歌使人巧慧
数学使人精细
博物使人深沉
伦理使人庄重
逻辑与修辞使人善辩
会谈使人敏捷
写作与笔记使人精确
史鉴使人明智
诗歌使人巧慧
数学使人精细
博物使人深沉
伦理使人庄重
逻辑与修辞使人善辩
===========================================================
软件项目量化管理方法
===========================================================
===========================================================
4步追踪导致事务日志膨胀的SQL命令
===========================================================
4步追踪导致事务日志膨胀的SQL命令 查看全文