2010 年 1月 18 日随笔档案 - π三毛

2010年1月18日

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 π三毛阅读(246) 评论(0) 推荐(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... 阅读全文

posted @ 2010-01-18 09:14 π三毛阅读(382) 评论(0) 推荐(0) 编辑