摘要：
1.DMV Query to identify all active SQL Server SessionsThe query below identifies all currently active SQL Server user connections by their SQL Server ... 阅读全文
摘要：
Causes SQL Server to display information regarding the amount of disk activity generated by Transact-SQL statements. SyntaxSET STATISTICS IO { ON | OF... 阅读全文
摘要：
Summary Info:Logical Reads : Reading Data pages from CachePhysical Reads : Reading Data pages from Hard DiskBuffer Cach Hit Ratio: (logical reads – ... 阅读全文
摘要：
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... 阅读全文
摘要：
Last year Tibor Karaszi posted a blog post titledMatch Those Typesthat talked about implicit data type conversions associated with mismatched data typ... 阅读全文
摘要：
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... 阅读全文
摘要：
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... 阅读全文
摘要：
SQL Server游标语句1.声明游标declare myCursor cursor[global | local][forward_only | scroll][static | keyset | dynamic | fast_forward][read_only | optimistic | ... 阅读全文