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
No Answer is Posted For this Question
Be the First to Post Answer
Define cursor locking
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
How would we use distinct statement? What is its use?
There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9
How to insert data into an existing table?
What are the steps to follow to configure SQL*Net?
List the different types of joins?
What stored by the msdb? : sql server database administration
If there is failure during updation of certain rows, what will be the state?
Why do we backup Active Directory ?
Explain the commands in sql server?
Explain some stored procedure creating best practices or guidelines?
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)