摘要：
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
阅读(273)
评论(0)
推荐(0)
摘要：
Causes SQL Server to display information regarding the amount of disk activity generated by Transact-SQL statements. SyntaxSET STATISTICS IO { ON | OF... 阅读全文
posted @ 2014-04-22 18:57
princessd8251
阅读(266)
评论(0)
推荐(0)
摘要：
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
阅读(759)
评论(0)
推荐(0)
摘要：
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
阅读(276)
评论(0)
推荐(0)
摘要：
Last year Tibor Karaszi posted a blog post titledMatch Those Typesthat talked about implicit data type conversions associated with mismatched data typ... 阅读全文
posted @ 2014-04-22 01:53
princessd8251
阅读(360)
评论(0)
推荐(0)
摘要：
This week, T-SQL Tuesday is being hosted by Jes Borland (blog|twitter), and the theme is "Aggregate Functions."When people think of aggregates, they t... 阅读全文
posted @ 2014-04-22 01:24
princessd8251
阅读(221)
评论(0)
推荐(0)
摘要：
All functions that exist in SQL Server are either deterministic or nondeterministic. The determinism of a function is defined by the data that is retu... 阅读全文
posted @ 2014-04-22 01:18
princessd8251
阅读(178)
评论(0)
推荐(0)
摘要：
SQL Server游标语句1.声明游标declare myCursor cursor[global | local][forward_only | scroll][static | keyset | dynamic | fast_forward][read_only | optimistic | ... 阅读全文
posted @ 2014-04-22 01:11
princessd8251
阅读(437)
评论(0)
推荐(0)
浙公网安备 33010602011771号