SQL Server essence

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

2009年6月26日

摘要: 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 天蝎 阅读(584) 评论(0) 推荐(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 天蝎 阅读(275) 评论(0) 推荐(0) 编辑