摘要：
转自http://www.mssqltips.com/sqlservertip/1715/scheduling-a-sql-server-profiler-trace/ProblemYou want to schedule a trace, but SQL Profiler does not hav... 阅读全文
摘要：
转自http://rusanu.com/2009/06/11/exception-handling-and-nested-transactions/I wanted to use a template for writing procedures that behave as intuitively... 阅读全文
摘要：
使用整数数据的精确数字数据类型。bigint从 -2^63 (-9223372036854775808) 到 2^63-1 (9223372036854775807) 的整型数据（所有数字）。存储大小为 8 个字节。int从 -2^31 (-2,147,483,648) 到 2^31 - 1 (2,... 阅读全文
摘要：
question:if the nested transaction encountered an exception, then rollbacked. How about the outer transaction?Lets demo this using below code.create p... 阅读全文
摘要：
转自http://blog.sqlauthority.com/2009/12/15/sql-server-difference-temptable-and-table-variable-temptable-in-memory-a-myth/Recently, I have been conducti... 阅读全文
摘要：
转自 http://www.mssqltips.com/sqlservertip/2825/sql-server-temp-table-vs-table-variable-performance-testing/ProblemIf you've been a DBA for any amount o... 阅读全文
摘要：
转自http://www.mssqltips.com/sqlservertip/1556/differences-between-sql-server-temporary-tables-and-table-variables/ProblemI've heard of table variables,... 阅读全文