posts - 83, comments - 88, trackbacks - 0, articles - 1
  博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理

公告

04 2010 档案

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

posted @ 2010-04-29 23:19 nzperfect 阅读(2707) | 评论 (4) 编辑 |

摘要: 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 阅读(196) | 评论 (1) 编辑 |

摘要: 原文: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 阅读(198) | 评论 (0) 编辑 |

摘要: 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 阅读(142) | 评论 (0) 编辑 |