SQL Server

摘要: 原文http://www.cnblogs.com/awpatp/archive/2010/01/26/1656651.htmlTask Manager跟Performance Monitor的区别(Working set和Private bytes)windows server 2003 :在Performance monitor中可以通过private bytes和Virtual bytes来衡量程序的内存使用. 在task manager中, 也有Memory Usage和VM Size两项. 但是仔细比较后会发现Memory Usage并不是对应private bytes, VM Siz阅读全文

摘要: 最近遇到一个问题，示例表结构如下：set statistics io onuse tempdb go--drop table TBcreate table TB (id int identity primary key, parentId int,name varchar(50))goinsert into TB(parentId,name) select 0,CAST(NEWID() as varchar(50))go 499990insert into TB(parentId,name) select 499990,CAST(NEWID() as varchar(50))insert in阅读全文

摘要: My Evn:windows 2003 server x64 + sql server 2008 sp2 Enterprise X64 example: The deadlock condition results when two processes executing the same statement at same time in hight concurrency:updatettwith(rowlock)setc='eb',d='cc'wherea='84B23855-2155-4EE0-911D-38D1265F1655'tabl阅读全文

摘要: SQL Server 2008 Service Pack 3http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27594Microsoft SQL Server 2008 SP3 Express Editionhttp://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27597Microsoft SQL Server 2008 Service Pack 3 Feature Packhttp://www.microso阅读全文