文章分类 - SQLSERVER
摘要:Slow query using non-deterministic user defined functionhttp://blogs.msdn.com/b/psssql/archive/2014/07/08/slow-query-using-non-deterministic-user-defi...
阅读全文
摘要:Troubleshooting Error 3313, 3314, 3414, or 3456 (SQL Server)http://technet.microsoft.com/en-us/library/ff713991(v=sql.100).aspxAn error during a redo,...
阅读全文
摘要:一些非常重要的系统表 internal BaseTableData(Database db) { this.db = db; scanner = new DataScanner(db); // These are ...
阅读全文
摘要:SQLSERVER里的各种数据类型以及对应的system_type_idnamespace OrcaMDF.Core.MetaData.Enumerations{ public enum SystemType : byte { Image = ...
阅读全文
摘要:SQLSERVER里的所有系统表namespace OrcaMDF.Core.MetaData.Enumerations{ public enum SystemObject : long { sysrscols = 3, // Parsed ...
阅读全文
摘要:稀疏列存储和稀疏向量 Orca MDFMSDN文章:使用稀疏列http://improve.dk/sparse-column-storage-ndash-the-sparse-vector/In this post I’ll be looking at the internal storage me...
阅读全文
摘要:辨识行记录中的 Complex Columnshttp://improve.dk/identifying-complex-columns-in-records/For an introduction to the anatomy of records, I suggest you readthis ...
阅读全文
摘要:数据行揭秘 Paul Randal 的博客http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-anatomy-of-a-record/This week I'm going to post a bunch of info on ...
阅读全文
摘要:SQLSERVER数据类型 internal static SqlDbType ToSqlType(byte value) { switch (value) { case 34: ...
阅读全文
摘要:SQLSERVER 页面类型状态A的值 记录类型namespace InternalsViewer.Internals.Records{ public enum RecordType { Primary = 0, Forwarded = 1, F...
阅读全文
摘要:使用默认的扩展事件 system_health分析死锁(Deadlock) 适用于SQL2008转载自:http://blog.csdn.net/kevinsqlserver/article/details/38417833在2008之前我们分析死锁需要用profiler trace或者trace ...
阅读全文
摘要:OPTION(FAST N)选项http://blogs.msdn.com/b/queryoptteam/archive/2006/03/30/564912.aspxhttp://social.msdn.microsoft.com/Forums/sqlserver/zh-TW/11e24bf3-2e...
阅读全文
摘要:误区 #2: DBCC CHECKDB会引起阻塞,因为这个命令默认会加锁http://www.jb51.net/article/33127.htm这是错误的!在SQL Server 7.0以及之前的版本中,DBCC CHECKDB命令的本质是C语言实现的一个不断嵌套循环的代码并对表加表锁(循环嵌套算...
阅读全文
摘要:MERGE语句也支持最小化日志Minimal logging and MERGE statementMERGE语句也支持最小化日志http://blogs.msdn.com/b/sqlserverstorageengine/archive/2010/06/03/minimal-logging-and...
阅读全文
摘要:IOCP 的意思和SQLSERVER里的IOCP等待全称 IO_COMPLETIONhttp://baike.baidu.com/view/1256215.htm?fr=aladdinIOCP编辑本词条缺少概述、信息栏、名片图,补充相关内容使词条更完整,还能快速升级,赶紧来编辑吧!目录1基本概念2详...
阅读全文
摘要:深入解析SQL Server 2008 笔记 目录 F F F F F F F 第一章 sqlserver2008架构和配置 版本 SELECT SERVERPROPERTY('Edition') --Developer Edition (64-bit) SELECT SERVERPROPERTY(
阅读全文
摘要:EXEC sys.[sp_spaceused] 的行数经过两次封装EXEC sys.[sp_spaceused] @objname = N'', -- nvarchar(776) @updateusage = '' -- varchar(5)SET QUOTED_IDENTIFIER OFFS...
阅读全文
摘要:SQL2000全文搜索架构SQL2000技术内幕Full-Text SearchingThe Transact-SQL language in SQL Server 2000 includes several programming extensions that allow you to acce...
阅读全文
摘要:SQL2000系统表sql2000技术内幕System TablesAs I've mentioned, SQL Server maintains a set of tables that store information about all the objects, datatypes, con...
阅读全文
摘要:SQL2000存储引擎内部sql2000技术内幕Internal StorageThis section covers system catalogs and the internal data storage of tables. Although you can use SQL Server e...
阅读全文