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
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How to create a user to access a database in ms sql server using "create user" statements?
Explain Normalization and DE normalization
How do we get current date in SQL Server 2000, Oracle, MS Access?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is difference between equi join and inner join?
Display a roll having miminum marks in two subjects?
What is the command used to recompile the stored procedure at run time?
Does group by or order by come first?
What is the use of stored procedure?
Why truncate is ddl command?
What are the main control-of-flow T-SQL constructs?
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)