SQL Server 2005: Get full information about transaction locks
摘要: SQL Server 2005: Get full information about transaction locksSometimes we wish to know what locks are being held by the transaction. Also it would be great to know what SPID owns the transaction, on w...
阅读全文
posted @
2010-01-18 14:07 闫力昕 阅读(22) |
评论 (0) 编辑
Table Variable vs. Temp Table Summary
摘要: Table Variable vs. Temp Table Summary:Local Temporary Tables and Table Variables Feature Table Variable Temp Table Note Table Name Max 128 characters Max 116 characters Data Storage In memory and Temp...
阅读全文