explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
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?
what is meant by deafult in sql server?
How to handle error or exception in sql?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are cursors stored procedures and triggers?
How to find tables without indexes?
What are the main control-of-flow T-SQL constructs?
What happens if the update subquery returns no rows in ms sql server?
what type of index will get created after executing the above statement? : Sql server database administration
Magic Tables ?
Can anyone explain difference between Database, Data warehouse and Data mart with some example?````
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)