Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 1021 Views
- I also Faced
- E-Mail Answers
Answer Posted / Jagesh Kumar
To quickly address this issue, consider implementing database indexes, partitioning the large table, or optimizing the queries by using query hints. Also, analyzing and reorganizing the indexes can help improve performance. Lastly, upgrading to a more powerful server could also be an option.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you append an identity column to a temporary table?
Why we use the openxml clause?
what is the difference between openrowset and openquery?
How do I create a trace in sql server?
Explain system functions or built-in functions? What are different types of system functions?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Can you index views?
What is acid mean in sql server?
How to convert numeric expression data types using the cast() function?
What is the primary use of the model database?
What are the different subsets of sql?
How raid can influence database performance?
What are the kinds of subquery?
How to provide default values to function parameters?
What are the different SQL Server Versions you have worked on?
