What is the meaning of lock escalation and why/how to stop this? : sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
How you can minimize the deadlock situation?
What is @@rowcount in sql?
What is a join and their types?
2 Answers Challenger Financial,
What is the difference between clustered and non-clustered indexes in ms sql server?
What is application role in sql server database security? : sql server security
What is the sql case statement used for? Explain with an example?
how can u get last observation in an unknown dataset ?
What are the differences between union, intersect, and minus operators?
Explain the difference between functions and stored procedures in sql server?
what is joins please explain breffly ??
whate is advantages of sql server 2000
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)