Articles by Rohitmssqlfun (Article: 1, Technical Blogs: 17)

Article: 1, Technical Blogs: 17

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.00

Programming Languages
C++	DMV-12 : Retain in Session & Transaction……..sys.dm_tran_session_transactions 31 Jan 2014 Updated: 31 Jan 2014 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 7,180 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Returns correlation information for associated transactions and sessions.

Average blogs rating: 4.11

	The Server Principal “xxxx” is Not Able to Access the Database “msdb” under the Current Security Context. [Technical Blog] 19 Feb 2013 Updated: 19 Feb 2013 Rating: 4.67/5 Votes: 2 Popularity: 1.40 Licence: CPOL Views: 42,892 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. The server principal “xxxx” is not able to access the database “msdb” under the current security context.
All Topics
	Cumulative Update – 10 for SQL Server 2012 RTM Is Now Available ! [Technical Blog] 29 Jan 2014 Updated: 29 Jan 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 5,050 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. The 10th cumulative update release for SQL Server 2012 RTM is now available.
	Cumulative Update – 13 for SQL Server 2008 SP3 Is Now Available ! [Technical Blog] 30 Jan 2014 Updated: 30 Jan 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 9,460 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. The 13th cumulative update release for SQL Server 2008 Service Pack 3 is now available.
	Cumulative Update – 11 for SQL Server 2008 SP3 Is Now Available ! [Technical Blog] 31 Jan 2014 Updated: 31 Jan 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 4,740 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. The 11th cumulative update release for SQL Server 2008 Service Pack 3 is now available.
	DMV-13: Finding Locking & Blocking……..sys.dm_tran_locks [Technical Blog] 31 Jan 2014 Updated: 31 Jan 2014 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 14,602 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Finding, locking and blocking
	DMV-11: T-Log space used by Transaction……..sys.dm_tran_database_transactions [Technical Blog] 31 Jan 2014 Updated: 31 Jan 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 7,510 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. T-Log space used by Transaction……..sys.dm_tran_database_transactions
Database Development
	Database Snapshot Failed Due to Disk Space Issue [Technical Blog] 29 Jan 2014 Updated: 29 Jan 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 4,770 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Database snapshot failed due to disk space issue
SQL Server	Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available! [Technical Blog] 29 Jan 2014 Updated: 29 Jan 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 6,731 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available!
	Cumulative Update – 8 for SQL Server 2008 R2 Service Pack 2 Is Now Available! [Technical Blog] 31 Jan 2014 Updated: 31 Jan 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 4,800 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. The 8th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site.
	SQL Server Silent unattended installation using configuration file [Technical Blog] 19 Feb 2013 Updated: 19 Feb 2013 Rating: 3.67/5 Votes: 5 Popularity: 2.56 Licence: CPOL Views: 39,851 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. SQL Server Silent unattended installation using configuration file
	SQL Server Discovery Report [Technical Blog] 26 Feb 2013 Updated: 26 Feb 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 9,420 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. SQL Server discovery report
	How to Save Deadlock Graph Events as .xdl file in SQL Server? [Technical Blog] 19 Feb 2013 Updated: 19 Feb 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 12,790 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. This post discusses how to save deadlock graph events as .xdl file in SQL Server.
	DMV-6: How Well Is My Stored Procedure Doing? [Technical Blog] 18 Apr 2013 Updated: 18 Apr 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 8,640 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. This DMV allows you to discover a lot of very interesting and important performance information about your cached stored procedures.
	Data Purity Issue After Upgrading SQL 2000 to Later Versions [Technical Blog] 31 Jan 2014 Updated: 31 Jan 2014 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 5,810 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Data purity issue after upgrading SQL 2000 to later versions
Programming Languages
SQL	Under Which User Does Your SQL Agent Job Run: SQL Agent Service Account or SQL Agent Job Owner? [Technical Blog] 19 Feb 2013 Updated: 19 Feb 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 17,491 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Under which user does your SQL Agent job run: SQL Agent service account or SQL Agent job owner?
	The EXECUTE Permission was Denied on the Object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’ [Technical Blog] 19 Feb 2013 Updated: 19 Feb 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 55,834 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. EXECUTE permission was denied on the Object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’
	How to Find the Top Most Expensive Cached Queries: sys.dm_exec_query_stats [Technical Blog] 18 Apr 2013 Updated: 18 Apr 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 34,842 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Finding the top most expensive cached queries

Average tips rating:

No tips have been posted.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Rohitmssqlfun

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.