Answer Posted / rama krishna
no need to impliment locks sql server automatically holds
locks
| Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
How can I tell if sql server is 32 or 64 bit?
What is a data collection table?
What is query processing?
What is normalization according to you and explain its different levels?
In which tcp/ip port does sql server run? Can it be changed?
How can you list all the table constraints in a database?
What is the difference between left and right outer join?
What is the difference between count and distinct count?
How to find the version of sql server? : sql server database administration
Explain what is the purpose of sql profiler in sql server?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How to enforce security in sql server? : sql server security
What is the benefit of normalization?
Explain the cursor lock types?