Profile

Cover photo
rohit garg
Works at Headstrong
Lives in Delhi
157 followers|107,556 views
AboutPostsPhotosVideos+1's

Stream

rohit garg

Shared publicly  - 
 
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…
1
Add a comment...

rohit garg

Shared publicly  - 
 
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 :-…
1
Add a comment...

rohit garg

Shared publicly  - 
 
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…
1
Add a comment...

rohit garg

Shared publicly  - 
 
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…
1
Add a comment...

rohit garg

Shared publicly  - 
 
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 view…
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 :- Data...
1
Add a comment...

rohit garg

Shared publicly  - 
 
The 15th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 15 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are…
1
Add a comment...

rohit garg

Shared publicly  - 
 
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…
1
Add a comment...

rohit garg

Shared publicly  - 
 
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…
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 ...
1
Add a comment...

rohit garg

Shared publicly  - 
 
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 facing…
1
Add a comment...

rohit garg

Shared publicly  - 
 
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 database_id in…
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 Current...
1
Add a comment...

rohit garg

Shared publicly  - 
 
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 facing…
1
Add a comment...

rohit garg

Shared publicly  - 
 
The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe…
1
Add a comment...
People
Have him in circles
157 people
Shanky Aggarwal's profile photo
Anuj Ruhela's profile photo
shivanshu gupta's profile photo
Sob Rahman's profile photo
Rajender Sharma's profile photo
Sanjay Bothra's profile photo
Rahul Sekhri's profile photo
nidhi vohra's profile photo
vardan bansal's profile photo
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Delhi
Links
Contributor to
Work
Employment
  • Headstrong
    Consultant, 2012 - present
  • HCL Technologies
    Associate Software Engineer, 2009 - 2011
  • Wipro Infotech
    Engineer - Database Administrator, 2011 - 2012
Basic Information
Gender
Male
Apps with Google+ Sign-in
  • Brain Dots
rohit garg's +1's are the things they like, agree with, or want to recommend.
Samsung Multi Window Manager
market.android.com

I CAN NOT HELP YOU IF YOU POST YOUR PROBLEMS IN THE REVIEW SECTION. IF YOU ARE HAVING DIFFICULTIES...SEND ME AN EMAIL AND I WILL DO MY BEST

DMV-12 : Retaion in Session & Transaction........sys.dm_tran_session...
mssqlfun.com

sys.dm_tran_session_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms18873

DMV-13 : Finding locking & blocking........sys.dm_tran_locks
mssqlfun.com

sys.dm_tran_locks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms190345.aspx Returns

DMV-11 : T-Log space used by transaction........sys.dm_tran_database_tra...
mssqlfun.com

sys.dm_tran_database_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms1869

DMV-10 : Does my database contain edition specific features?........sys....
mssqlfun.com

sys.dm_db_persisted_sku_features (Introduced in SQL Server 2008) DMV (Dynamic Management View), described by BOL as follows: http://msdn.mic

DMV-9 : Digging out details of CLR Tasks........sys.dm_clr_tasks
mssqlfun.com

sys.dm_clr_tasks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/ms177528.aspx Returns a

DMV-8 : Check Space consumed by Database........sys.dm_db_file_space_usage
mssqlfun.com

sys.dm_db_file_space_usage DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms174412.aspx

Cumulative Update - 7 for SQL Server 2012 RTM Is Now Available !
mssqlfun.com

The 7th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 7 contains all the hotfixes released since the

DMV-7 : Find Queries waiting for memory ?........sys.dm_exec_query_memor...
mssqlfun.com

sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms36539

Cumulative Update - 6 for SQL Server 2008 R2 Service Pack 2 Is Now Avail...
mssqlfun.com

The 6th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulat

Cumulative Update - 12 for SQL Server 2008 R2 Service Pack 1 Is Now Avai...
mssqlfun.com

The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft Support site. Cumula

DMV-6 : How well my store procedure doing ?........sys.dm_exec_procedure...
mssqlfun.com

sys.dm_exec_procedure_stats DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/cc280701.as

DMV-5 : Queries runing are adhoc or proc , single or multi use ?...........
mssqlfun.com

sys.dm_exec_cached_plans DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/ms187404.aspx

DMV-4 : Find top most expensive cached queries ?........sys.dm_exec_quer...
mssqlfun.com

sys.dm_exec_query_stats DMV (Dynamic Management View), described in BOL as follows : http://msdn.microsoft.com/en-us/library/ms189741.aspx R

DMV-3 : What is currently going on ?........sys.dm_exec_requests
mssqlfun.com

sys.dm_exec_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms177648.aspx Retur

Why SQL Server Named Instance connect without specifying instance name ?
mssqlfun.com

Issue : Today Evening, I was just about to leave the office and at same time I got a call from one of my friend. He is not running under any

Cumulative Update - 10 for SQL Server 2008 Service Pack 3 Is Now Availab...
mssqlfun.com

The 10th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 10 contains all the hotfixes relea

MSSQLFUN - IMPORTANT MESSAGE || is now - RohitGarg
beyondrelational.com

Dear Friends Firstly, I want to say thanks for your support & liking my blogs that make it possible. I like to share this good news that htt

Cumulative Update - 3 for SQL Server 2012 Service Pack 1 Is Now Available !
mssqlfun.com

The 3rdcumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 3 contains all the hotfixes released

SQL Server 2000 Extended Support ending soon.........21 days left
mssqlfun.com

· On April 9, 2013, Extended Support for SQL Server 2000 will come to an end, and SQL Server 2000 will no longer be supported. · What will c