随笔 - 120, 文章 - 1, 评论 - 166, 阅读 - 19万
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理
< 2025年3月 >
日 一 二 三 四 五 六
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

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 阅读(12404) 评论(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 阅读(592) 评论(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 阅读(511) 评论(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 阅读(353) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示