Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 7947 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rajkumar
Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.
sp_who2 will give the list of blocking sessions. From that
we can find the objects using dbcc command.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can sql server instances be hidden?
Do you know what is sql injection?
when you create a database how is it stored? : Sql server database administration
Explain how would you store your query in an SSRS report or a Database server?
How to execute a sql statement using mssql_query()?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
What is primary key and example?
How can you hide the sql server instances?
What will be the maximum number of indexes per table?
How to create new tables with "select ... Into" statements in ms sql server?
what is package and it uses and how can u call a package
Explain what are partitioned views and distributed partitioned views?
What is the simplest way to create a new database in ms sql server?
What is database white box testing?
Explain the concepts and capabilities of sql server?
