- 博客(9)
- 收藏
- 关注
原创 Optimising System Memory for SQL Server
http://www.modhul.com/2007/11/10/optimising-system-memory-for-sql-server-part-i/
2011-01-27 14:44:00 294
转载 Managing Data Growth in SQL Server
<br />http://www.simple-talk.com/sql/database-administration/managing-data-growth-in-sql-server/
2011-01-20 18:25:00 258
转载 Using Microsoft Virtual Server 2005 to Create and Configure a Two-Node Microsoft Windows Server 2003 Cluster
<br />http://www.microsoft.com/technet/prodtechnol/virtualserver/deploy/cvs2005.mspx<br /> <br />
2011-01-17 17:51:00 274
转载 The count of VLFs for different size of transaction log
<br />The formula for VLFs is: less than 64MB - 4 VLFs64MB and less than 1GB - 8 VLFs1GB or greater - 16VLFs
2011-01-10 23:39:00 244
转载 Powershell Database Backup Script
Powershell Database Backup Script<br /> <br />http://www.sqlservercentral.com/articles/Backup/71682/
2011-01-05 21:28:00 398
原创 生成xml并更新表字段
<br /> <br /> <br /><br /> <br />--生成tm_xUnique对应的xml<br />DECLARE @x1 XML<br />SET @x1 = <br /> CAST((SELECT a.name AS "@TableName",<br /> 'uq_' + a.name + '_id_num' AS "UniqueConstraint/uq_name", <br /> '(' + STUFF((<br /> SELECT ',' + name FROM sy
2010-12-31 16:44:00 437
转载 XQuery in SQL Server 2005
<br />http://msdn.microsoft.com/en-us/library/ms345122.aspx<br /> <br /> <br />Example: Deleting a skill<br />The following example illustrates the use of the delete keyword to delete a skill for a specified candidate.<br />The following stored procedure i
2010-12-31 01:27:00 246
转载 Retrieving Deadlock Graphs with SQL Server 2008 Extended Events
http://www.sqlservercentral.com/articles/deadlock/65658/
2010-12-27 22:51:00 284
转载 win7 / virtual server 2005 r2
http://bluearousal.blog.51cto.com/361928/291760
2010-12-13 00:54:00 416
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人