SQL Server Integration & Reporting Services

Microsoft SQL Server Integration (SSIS) & Reporting Services (SSRS) SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation,…read more →

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 →