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 a string that was 50331648 bytes long, and expected a string no longer than 129 bytes, at offset 12901. … Continue reading
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. Types of Database Compression · Row Compression · Page Compression You can … Continue reading
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 a string that was 50331648 bytes long, and expected a string no longer than 129 bytes, at offset 12901. … Continue reading
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 and follow MSSQLFUN :- http://www.facebook.com/mssqlfun http://mssqlfun.com/feed https://twitter.com/Rgarg86 Other Linked Profiles :- http://www.sqlservercentral.com/blogs/mssqlfun/ http://social.msdn.microsoft.com/Profile/rohitgarg http://www.toadworld.com/members/rohit-garg/blogs/default.aspx http://beyondrelational.com/members/RohitGarg/default.aspx
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 are running SP_readerrorlog, XP_readerrorlogs or XP_enumerrorlogs, query … Continue reading