SQL Server essence

  博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::
  37 随笔 :: 8 文章 :: 2 评论 :: 0 引用

公告

06 2009 档案

摘要: Original link: http://www.sqlservercentral.com/scripts/63782/This has been tested on SQL 2000, 7 and 2005 databases very successfully. 40 GB went down to under 1 GB, 176GB went down to 105MB/*Shrink a...阅读全文
posted @ 2009-06-26 19:00 天蝎 阅读(181) | 评论 (0) 编辑

摘要: create proc sp_default_collation as set nocount on declare @servercollation sysname select @servercollation = convert(sysname, serverproperty('collation')) if @servercollation is not NULL BEGIN sele...阅读全文
posted @ 2009-06-26 18:19 天蝎 阅读(78) | 评论 (0) 编辑