tell me what is blocking and how would you troubleshoot it? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -
Explain having clause?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What are different types of join?
How to defragment table indexes?
syntax for deleting the database in T SQL
How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.
What is the importance of a recovery model?
What is database black box testing?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is blocking and how would you troubleshoot it?
Oracle (3253)
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)