2014年4月22日
SQLServer DMV Query
摘要： 1.DMV Query to identify all active SQL Server SessionsThe query below identifies all currently active SQL Server user connections by their SQL Server ... 阅读全文
posted @ 2014-04-22 19:04 princessd8251 阅读(277) 评论(0) 推荐(0)
SQL Server Logical/Physical Reads
摘要： Summary Info:Logical Reads : Reading Data pages from CachePhysical Reads : Reading Data pages from Hard DiskBuffer Cach Hit Ratio: (logical reads – ... 阅读全文
posted @ 2014-04-22 18:27 princessd8251 阅读(762) 评论(0) 推荐(0)
The include feature of SQL Server Index
摘要： 1. Why we need the index 'include' feature? For SQLServer , the length of all the index key have a limit length as 900 byte.when you create a index wh... 阅读全文
posted @ 2014-04-22 17:01 princessd8251 阅读(283) 评论(0) 推荐(0)