Toad World

Blogs

Rohit Garg
Follow /5 Oct 2015 at 4:42pm / SQL Server Blog

Implementation of Data Compression – SQL Server

Data Compression Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of Duplicates, Null & Zeroes. It’s a process of reducing size of database & its objects by increasing CPU cycle and reducing I/O effort...
646 0 /
Rohit Garg
Follow /24 Jul 2015 at 5:34pm / SQL Server Blog

MDW Data Collector – Collection Set jobs not working

ERROR : Error Message 1 : Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS – Read Current Upload Data [1], Description: String too long. The adapter read...
749 0 /
Rohit Garg
Follow /11 Jun 2015 at 5:35am / SQL Server Blog

500+ Facebook Like

Thanks every one for loving me, joining me & providing you extreme support. I am very happy to share that we reach to 500+ milestone. Please keep supporting us & liking us. Reference : Rohit Garg ( http://mssqlfun.com/ ) You can find...
703 0 /
Rohit Garg
Follow /2 Jun 2015 at 2:50am / SQL Server Blog

Strange Issue of waittype – PREEMPTIVE_OS_GETPROCADDRESS

ISSUE : Today, My Friend is facing issue with SQL Server error logs on one of my production server. SQL Server is not able to read SQL server error log files. We have checked that SQL Server Error log files are accessible on file system. 1) When we...
1249 0 /
Rohit Garg
Follow /25 May 2015 at 2:56am / SQL Server Blog

Last Cumulative Update – 16 for SQL Server 2012 Service Pack 1 Is Now Available !

The 16th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 16 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
751 0 /
Rohit Garg
Follow /25 May 2015 at 2:56am / SQL Server Blog

Cumulative Update – 6 for SQL Server 2012 Service Pack 2 Is Now Available !

The 6th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are...
660 0 /
Rohit Garg
Follow /25 May 2015 at 2:56am / SQL Server Blog

SQL Server 2014 Service Pack 1 (SP1) Is Now Available !

Finally after a long waiting period, Microsoft release SQL Server 2014 Service Pack 1 (SP1), Same is now available for download at the Microsoft Support site. SQL Server 2014 Service Pack 1 (SP1) contains all the hotfixes released since the initial release...
730 0 /
Rohit Garg
Follow /18 May 2015 at 3:40am / SQL Server Blog

How to Move MSDB & Model SQL Server system Databases ?

Steps of Moving MSDB & Model SQL Server system Database to new locaation:- 1) Check current location of MSDB & Model Databases by executing below query SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE...
1433 0 /
Rohit Garg
Follow /11 May 2015 at 9:51am / SQL Server Blog

Database snapshot captures only data changes or it will also save real database from DDL changes ?

Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure, store procedure etc.) Answer : Yes. So here we explian how :- Databse snapshot is read only databse. It’s a static...
699 0 /
Rohit Garg
Follow /27 Apr 2015 at 5:20am / SQL Server Blog

Cumulative Update – 5 for SQL Server 2012 Service Pack 2 Is Now Available !

The 5th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are...
613 0 /