sys.dm_exec_requests:- The sys.dm_exec_requests view returns one row for every currently executing request within your SQL Server instance and is useful
Continue readingCategory: SQL Server -DBA
SQL Server -DBA, SQL Server Services, who dropped or altered tables,procedures or databases in SQL Server, What in SQL Server
sys.dm_exec_sql_text In SQL Server
Function sys.dm_exec_sql_text can take a sql_handle or a plan_handle as a parameter, And it returns the SQL text that matches
Continue readingMemory Brokers In SQL Server
Memory Brokers:- Because memory is needed by so many components in SQL Server and to make sure each component uses
Continue readingHow To Convert STRING To INT In SQL SERVER
If the table column is in VARCHAR and contains all numeric values, then it can be obtained as an integer
Continue readingFind out CPU Uses By each Databases in SQL Server
Through Below Script you are able to identify the CPU utilization By per databases in your SQL Server WITH CPU_Uses_Per_Db
Continue readingCapture TRUNCATE and DELETE events in SQL Server
I received one question on my email regarding how to capture TRUNCATE and DELETE statements being fired on a database
Continue readingAdding db_executor role In SQL Server
Recently, One of our colleagues asked me to give permission to execute Stored procedures on the Sales database but he
Continue readingAttempt to fetch logical page (1:64920) in database 2 failed
when executing certain SP get following error:- Error Msg 605, Level 21, State 3 attempt to fetch logical page (1:64920)
Continue readingThe server principal already exists – Msg 15025
When we tried to creating login from SSMS then getting error saying “The server principal already exists”. I thought that
Continue readingFix:- Error: 262 : SHOWPLAN permission denied in SQL Server
One of my friends asked me one question when he tries to check the execution plan the he received an
Continue reading