Archive for May, 2012

Index Tuning Wizard in SQL Server

The Index Tuning Wizard simplifies the task of identifying which indexes to create in a table and also optionally generates scripts to create them by analyzing a user-supplied workload. Various modes are offered for tuning both indexes and indexed views. Open SQL Server Enterprise Manager Select Tools -> SQL Profiler Press -> New Trace Button Perform the following actions: Note:…read more →

Shrink Database in SQL Server

SQL Server Procedure to Drop Log Size of all the databases available in SQL Server (Works for all version)   Use master declare @DBName varchar(35), @str varchar (255), @str1 varchar(1000), @str2 varchar(1000), @str3 varchar(1000), @defaultRecoveryModel Varchar(100) declare DBRecoveryModelGenerator_cursor cursor for select name from sysdatabases where category in (’0′, ’1′,’16′) /* will change all the databases currently present in the SQL,…read more →