2014年08月_OnlyQi

转载 What's the difference between a URI and a URL?

URI s identify and URL s locate; however, locators are also identifiers, so every URL is also a URI, but there are URIs which are not URLs.ExamplesRoger PateThis is my name, which is

2014-08-25 11:22:21 903

转载一个关于SQL Server memory计数器的系列讲座(很详细)

http://www.sqlshack.com/sql-server-memory-performance-metrics-part-1-memory-pagessec-memory-page-faultssec/

2014-08-15 16:11:39 742

转载 Trace 4136

这篇文中关于4136http://blogs.msdn.com/b/axinthefield/archive/2010/11/04/sql-server-trace-flags-for-dynamics-ax.aspx

2014-08-08 10:58:50 682

转载 Why you should not shrink your data files

http://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/照着文中的实验做了一下，还真是一样的结果。

2014-08-07 15:57:53 731

转载一篇简洁的介绍log file结构的文章

http://technet.microsoft.com/en-us/library/ms179355(v=sql.105).aspx

2014-08-07 14:56:40 922

转载 Special Table Types In SQL Server

SQL Server 2008 R2中有4中不同的tablehttp://technet.microsoft.com/en-us/library/ms186986(v=sql.105).aspx

2014-08-07 10:38:21 750

转载当数据库很慢时考察的一些计数器

Overview of Performance Monitoring：http://technet.microsoft.com/en-us/library/cc958276.aspx

2014-08-06 17:17:23 877

我们知道SQL Server会尽可能的获得内存来保证自己的运行，但占用内存是一个渐进的过程。SQL Server启动后，不会瞬间占用很多内存，只有当SQL Server需要更多内存时，它才试图获取更多的内存。当SQL Server不忙时，也不会释放不需要的内存(除非重启SQL Server)。因此SQL Server在启动后，会逐渐占用越来越多的内存，直到无法获取更多内存为止。因此SQL Serv

2014-08-06 17:05:18 1498

转载 Determine SQL Server memory use by database and object

http://www.mssqltips.com/sqlservertip/2393/determine-sql-server-memory-use-by-database-and-object/

2014-08-06 14:51:30 909

转载一篇不错的SSIS性能很慢的分析

http://stackoverflow.com/questions/16181921/dataflow-task-in-ssis-is-very-slow-as-compared-to-writing-the-sql-query-in-execu

2014-08-06 14:50:49 7102

原创查询数据库自动增长的历史记录

SQL Server 默认会自动跟踪数据库的自动增长，注意只有自动z

2014-08-01 15:06:43 1480

转载 Managing Data Growth in SQL Server 很长很详细

https://www.simple-talk.com/sql/database-administration/managing-data-growth-in-sql-server/

2014-08-01 14:24:54 745

转载一篇不错的判断SQL Server无法连接的问题

http://www.sqldbadiaries.com/2011/01/05/on-which-port-is-sql-server-listening-on/如果所有端口都已监听，那最后zai

2014-08-01 12:59:28 566

我的学习成长日记