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?
No Answer is Posted For this Question
Be the First to Post Answer
What is sql server query analyzer?
Suggest a method of joining two tables.
0 Answers Ernst Young, Thomson Reuters,
Explain Trigger with an example?
What is a cube? : sql server analysis services, ssas
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is for xml in sql server?
How many nested transaction can possible in sql server?
Can we insert data into view sql server?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are the steps you should follow to start sql server in single-user mode?
What are the steps you can take to avoid “deadlocks”?
How to execute a stored procedure in ms sql server?
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)