SQLSERVER - 文章分类(第4页) - 桦仔

DBCC WRITEPAGE: an introduction

摘要：DBCC WRITEPAGE: an introductionhttp://www.sqlskills.com/blogs/paul/dbcc-writepage/Check out my online training courses:SQL Server: Detecting and Corre... 阅读全文

posted @ 2014-07-03 16:13 桦仔阅读(349) 评论(0) 推荐(0) 编辑

在事务日志文件里查找page split记录

摘要：在事务日志文件里查找page split记录http://www.sqlskills.com/blogs/paul/tracking-page-splits-using-the-transaction-log/Tracking page splits using the transaction lo... 阅读全文

posted @ 2014-07-03 16:04 桦仔阅读(298) 评论(0) 推荐(0) 编辑

New hardware to play with: Fusion-io SSDs

摘要：New hardware to play with: Fusion-io SSDshttp://www.sqlskills.com/blogs/paul/new-hardware-to-play-with-fusion-io-ssds/Christmas comes but once a year…... 阅读全文

posted @ 2014-07-03 15:51 桦仔阅读(171) 评论(0) 推荐(0) 编辑

Are mixed pages removed by an index rebuild?重建索引会回收混合区的页面吗

摘要：Are mixed pages removed by an index rebuild?重建索引会回收混合区的页面吗http://www.sqlskills.com/blogs/paul/mixed-pages-removed-index-rebuild/This is a question tha... 阅读全文

posted @ 2014-07-03 15:35 桦仔阅读(221) 评论(0) 推荐(0) 编辑

Online index rebuild corruption bug in SQL Server 2012 SP1

摘要：Online index rebuild corruption bug in SQL Server 2012 SP1http://www.sqlskills.com/blogs/paul/online-index-rebuild-corruption-bug-sql-server-2012-sp1/... 阅读全文

posted @ 2014-07-03 15:13 桦仔阅读(188) 评论(0) 推荐(0) 编辑

SQLSERVER自旋锁等待 SOS_SCHEDULER_YIELD waits and the LOCK_HASH spinlock

摘要：SQLSERVER自旋锁等待 SOS_SCHEDULER_YIELD waits and the LOCK_HASH spinlock http://www.sqlskills.com/blogs/paul/sos_scheduler_yield-waits-and-the-lock_hash-sp 阅读全文

posted @ 2014-07-03 14:08 桦仔阅读(998) 评论(0) 推荐(0) 编辑

SQLSERVER最普通的等待类型排行榜

摘要：SQLSERVER最普通的等待类型排行榜http://www.sqlskills.com/blogs/paul/common-wait-stats-24-hours/Back in February I kicked off asurveyasking you to run code that cr... 阅读全文

posted @ 2014-07-03 12:18 桦仔阅读(501) 评论(0) 推荐(0) 编辑

维护窗口和停机时间可用率99.99%

摘要：维护窗口和停机时间可用率99.99%QQ的可用率是99.99%http://www.sqlskills.com/blogs/paul/survey-target-uptime-planned-actual/t’s been five years(!) since the last time I as... 阅读全文

posted @ 2014-07-03 12:08 桦仔阅读(1245) 评论(0) 推荐(1) 编辑

SQL Server IO_COMPLETION 和 WRITE_COMPLETION 等待的原因

摘要：SQL Server IO_COMPLETION 和 WRITE_COMPLETION 等待的原因http://www.sqlskills.com/blogs/paul/causes-io_completion-write_completion-sql-server-wait-types/In ma... 阅读全文

posted @ 2014-07-03 11:54 桦仔阅读(1561) 评论(0) 推荐(0) 编辑

数据库913错误菠萝兄设置数据库只读

摘要：数据库913错误菠萝兄设置数据库只读传说】北京-肖磊日Could not find database ID 7. Database may not be activated yet or may be in transition. Reissue the query once the databa... 阅读全文

posted @ 2014-07-02 11:54 桦仔阅读(692) 评论(0) 推荐(0) 编辑

如何使用 DBCC MEMORYSTATUS 命令来监视 SQL Server 2005 中的内存使用情况

摘要：如何使用 DBCC MEMORYSTATUS 命令来监视 SQL Server 2005 中的内存使用情况http://support.microsoft.com/kb/907877/zh-cnDBCC MEMORYSTATUS 命令提供了 Microsoft SQL Server 的当前内存状态的... 阅读全文

posted @ 2014-07-02 11:28 桦仔阅读(931) 评论(0) 推荐(0) 编辑

复制中代理配置文件中的MaxBCPThreads选项 not causing parallel export

摘要：复制中代理配置文件中的MaxBCPThreads选项 not causing parallel export快照复制http://troubleshootingsql.com/2013/09/23/maxbcpthreads-not-causing-parallel-export/I had rec... 阅读全文

posted @ 2014-07-01 17:29 桦仔阅读(212) 评论(0) 推荐(0) 编辑

禁用发布和分发

摘要：禁用发布和分发生成的脚本use [master]exec sp_dropdistributor @no_checks = 1GO禁用了之后，分发数据库、作业会消失，链接服务器不会删除阅读全文

posted @ 2014-07-01 15:00 桦仔阅读(342) 评论(0) 推荐(0) 编辑

The Data Loading Performance Guide解决插入问题

摘要：The Data Loading Performance Guide解决插入问题http://msdn.microsoft.com/en-us/library/dd425070(v=SQL.100).aspxSQL Server Technical ArticleWriters:Thomas Kej... 阅读全文

posted @ 2014-06-30 14:43 桦仔阅读(545) 评论(0) 推荐(0) 编辑

SQLSERVER Trace Flag 跟踪标志大全

摘要：SQLSERVER Trace Flag 跟踪标志大全http://troubleshootingsql.com/2014/01/20/sql-server-2012-trace-flags/SQL Server 2012: TraceFlags6 comments5 VotesThis is so... 阅读全文

posted @ 2014-06-30 14:22 桦仔阅读(1430) 评论(0) 推荐(0) 编辑

Partial Database Backup and Piecemeal（零碎） Restore in Microsoft SQL Server 数据库段落备份和段落还原

摘要：Partial Database Backup and Piecemeal（零碎） Restore in Microsoft SQL Server数据库段落备份和段落还原http://aboutsqlserver.com/2014/06/24/partial-database-backup-and-... 阅读全文

posted @ 2014-06-29 23:08 桦仔阅读(244) 评论(0) 推荐(0) 编辑

SQL Server 存储引擎: 数据库文件和文件组

摘要：SQL Server 存储引擎: 数据库文件和文件组http://aboutsqlserver.com/2013/09/24/sql-server-storage-engine-database-files-and-filegroups/Recently I have received a few ... 阅读全文

posted @ 2014-06-29 22:44 桦仔阅读(310) 评论(0) 推荐(0) 编辑

Clustered Columnstore Indexes: Performance Considerations

摘要：Clustered Columnstore Indexes: Performance Considerationshttp://aboutsqlserver.com/2014/05/27/clustered-columnstore-indexes-performance-considerations... 阅读全文

posted @ 2014-06-29 22:35 桦仔阅读(238) 评论(0) 推荐(0) 编辑

Locking in Microsoft SQL Server (Part 19) – Concurrency model in in-memory OLTP (Hekaton)

摘要：Locking in Microsoft SQL Server (Part 19) – Concurrency model in in-memory OLTP (Hekaton)http://aboutsqlserver.com/2014/04/08/concurrency-model-in-hek... 阅读全文

posted @ 2014-06-29 18:13 桦仔阅读(252) 评论(0) 推荐(0) 编辑

揭秘Table Spools

摘要：揭秘Table Spoolshttp://aboutsqlserver.com/2014/01/07/unwinding-table-spools/One of the questions I have often been asked during various SQL Server event... 阅读全文

posted @ 2014-06-29 16:54 桦仔阅读(380) 评论(0) 推荐(0) 编辑

文章分类 - SQLSERVER

公告