Bora.Choi

--SQL 2000/2005 Version set nocount on go DECLARE @SqlPort Nvarchar(10) DECLARE @instance_name Nvarchar(30) DECLARE @reg_key Nvarchar(500) Declare @value_name Nvarchar(20) if left(CAST(SERVERPROPERTY('ProductVersion')AS sysname),1) = '9' BEGIN select @instance_name = CAST(SERVERPROPERTY('instancename')AS sysname) if @instance_name is NULL BEGIN set @reg_key = 'SOFTWARE\Microsoft\MSSQLServer\MSSQ..

-- 퍼옴. /* Find Duplicate Indexes This script returns the Duplicate indexes on any database I use 2 User defined Functions Compatible with SQLServer 2000 (I used sp3) It won't work in SQL Server 7.0 because It uses user-defined functions and a Memory. Created by G.R. Preethiviraj Kulasingham pkulasingham@virtusa.com Written on : February 20, 2003 Modified on : May 18, 2004 Additional code written..

SQL SERVER 2008 SP 2 이상 출처: http://sqlfool.com/category/sql-scripts/ 인덱스 조각화를 얻고 실행하는 sp 이다. SQLl 2005의 sp2 이상에서 가능하다. 1. 테이블 생성 /* Scroll down to the see notes, disclaimers, and licensing information */ DECLARE @indexDefragLog_rename VARCHAR(128) , @indexDefragExclusion_rename VARCHAR(128) , @indexDefragStatus_rename VARCHAR(128); SELECT @indexDefragLog_rename = 'dba_indexDefragLog_obsolete_' +..

SQL SERVER 2005 이상 출처: http://www.sqlservercentral.com/scripts/Monitoring/68069/ This script displays data from the dynamic management view called: sys.dm_os_performance and presents it in a report. I recommend that you look closer to this view for all your statistical needs. If you find other information that you want to include, just modify this script to reflect the additional information. Ho..

SQL SERVER 2005 이상 Microsoft Windows PowerShell and SQL Server 2005 WMI Providers - Part 2 이 글은 스프링노트에서 작성되었습니다.

SQL SERVER 2005 이상 Microsoft Windows PowerShell and SQL Server 2005 WMI Providers - Part 1 이 글은 스프링노트에서 작성되었습니다.