You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
No Answer is Posted For this Question
Be the First to Post Answer
Write a sql query to get zero records from a table having n number of records?
What is a constant or literal in ms sql server?
What is Peer to peer Replication?
1 Answers CarrizalSoft Technologies, HCL,
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
What structure can you implement for the database to speed up table reads?
How you trouble shoot when any job fails
Where in ms sql server is ’100’ equal to ‘0’?
How would you choose between a clustered and a non-clustered index?
Define Unique Key?
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
You want to implement the one-to-one relationship while designing tables. How would you do it?
Why and when do stored procedure recompile?
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)