博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

04 2010 档案

修改SQL Server 2005/2008 用户数据库文件默认路径和默认备份路径

摘要：以下仅为参照，如果有多个实例，可能会有些许不同：本环境是SQLServer2005StandardVersion64-bit 和 SQLServer2008 StandardVersion64-bit 双实例同时安装在一个WindowsServer2008StandardVersion64-bit OS上：代码Code highlighting produced by Actipro CodeHi... 阅读全文

posted @ 2010-04-29 23:19 nzperfect 阅读(12446) 评论(5) 推荐(1)

[转]Database Mirroring Log Compression in SQL Server 2008 Improves Throughput

摘要：Database Mirroring Log Compression in SQL Server 2008 Improves Throughput Author: Sanjay Mishra Reviewers: Peter Byrne, Don Vilen, Kaloian Manassiev, Burzin Patel, Eric Jacobsen Overview Da... 阅读全文

posted @ 2010-04-16 14:04 nzperfect 阅读(606) 评论(1) 推荐(0)

[转]Why you want to be restrictive with shrink of database files

摘要：原文：http://www.karaszi.com/SQLServer/info_dont_shrink.asp Overview If you want the really reallyshort story, then check out this analogy - hopefully you come back here and read the full story. Introd... 阅读全文

posted @ 2010-04-16 13:59 nzperfect 阅读(512) 评论(0) 推荐(0)

How change the identity increment of column ?

摘要：Following statement can reset seed[代码]but can't reset increment.how change the identity increment of column?I can't find the simple method,now I use Following sql script to change it.[代码]please tell m... 阅读全文

posted @ 2010-04-14 16:35 nzperfect 阅读(361) 评论(0) 推荐(0)