Home » Posts tagged 'TSQL' (Page 3)
Tag Archives: TSQL
DMV-3 : What is currently going on ?……..sys.dm_exec_requests
sys.dm_exec_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms177648.aspx Returns information about each request that is executing within SQL Server. sys.dm_exec_requests DMV is used to get details of currently running sessions. This DMV help us is getting details like used database, transaction isolation level, open transaction count, status, blocked session, percentage of task … Continue reading
DMV-2 : Explore the secrets of session…… sys.dm_exec_sessions
sys.dm_exec_sessions DMV (Dynamic Management View), delineated by BOL as follows: http://msdn.microsoft.com/en-us/library/ms176013.aspx Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server-scope view that shows information about all active user connections and internal tasks. This information includes client version, client program name, client login time, login user, current session setting, and more. sys.dm_exec_sessions is extremely useful DMV when … Continue reading
DMV-1 : Who All Are connected ? …. sys.dm_exec_connections
The sys.dm_exec_connections DMV (Dynamic Management View) is represented by Books Online (BOL) as follows : http://msdn.microsoft.com/en-us/library/ms181509.aspx Returns information about the connections established to this instance of SQL Server and the details of each connection. sys.dm_exec_connections is the most common DMV used to get connection details. We will get details info regarding every connection like protocol … Continue reading
Backup not starting for Database with Full Text Catalog…………..Failed to change the status to RESUME for full-text catalog in database. Error: 0x80043607
Issue :- One of our Database with Full Text Catalog is not getting backed up. When I checked, backup keeps pending on 0% without any progress. In SQL server error log, I also found error related to Full text catalog that SQL server is facing issue in setting Full test catalog status. These is some … Continue reading
Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above
Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy. But Sometimes I find that intellisense becomes stale and you start getting the wavy red lines when writing code. Even though object exists in database but Intellisense is not able to recognize it. Refreshing the cache … Continue reading