Answer Posted / pandians
In SQL Server 2005, 2008, 2008 R2,...
Select Session_ID, Blocking_Session_ID From
Sys.Dm_Os_Waiting_Tasks Where Blocking_Session_ID Is Not
Null
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is BCP? When does it used in sql server 2012?
How to rebuild all indexes on a single table?
Explain what are the basic functions for master, msdb, model, tempdb databases?
Define ACID properties in a Database?
Where sql server usernames and passwords are stored in a sql server?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is the difference between truncate and delete commands?
What are the dmvs? : sql server database administration
Explain filestream storage of sql server 2008?
write an SQL query to list the employees who joined in the month of January?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Tell me what is use of except clause? How it differs from not in clause?
Can the “if update (colname)” statement be used in a delete trigger?
When should you use an instead of trigger?
What are audit control procedures?
