摘要：
Temporary tables are created in tempdb. The name "temporary" is slightly misleading, for even though the tables are instantiated in tempdb and backed ... 阅读全文
摘要：
转自http://rusanu.com/2009/08/05/asynchronous-procedure-execution/Update:a version of this sample that accepts parameters is available in the postPassin... 阅读全文
摘要：
转自http://technet.microsoft.com/en-us/library/ms189823(v=sql.105).aspxPlaces a lock on an application resource.Transact-SQL Syntax ConventionsSyntaxsp_... 阅读全文
摘要：
转自http://www.mssqltips.com/sqlservertip/1841/auto-generate-an-hourly-sql-server-profiler-trace-file/ProblemWhile investigating performance issues as a... 阅读全文
摘要：
Executing a ROLLBACK TRANSACTION or COMMIT TRANSACTION Transact-SQL statement inside a stored procedure or trigger is possible, but doing so may cause... 阅读全文
摘要：
转自http://www.sqlservergeeks.com/blogs/sarab/sql-server-bi/184/types-of-transactions-in-sql-serverThere are four types of transactions in SQL Server.Au... 阅读全文
摘要：
转自http://www.sqlservercurry.com/2011/01/rollback-nested-transactions-in-stored.htmlIn a previous articleRollback Transaction in SQL Server, l explaine... 阅读全文
摘要：
转自http://technet.microsoft.com/en-us/library/ms188378(v=sql.110).aspxSyntaxSAVE { TRAN | TRANSACTION } { savepoint_name | @savepoint_variable }[ ; ]Ar... 阅读全文
摘要：
转自http://geekswithblogs.net/bbiales/archive/2012/03/15/how-to-nest-transactions-nicely---quotbegin-transactionquot-vs-quotsave.aspxDo you write stored... 阅读全文