How to perfor If the table running time is taking 2hours
and table is having 10 rows in it?
Answer Posted / bru medishetty
I guess something must be seriuosly wrong with Server not
with that table.
Since a table with 10 records must not be taking 2 hours to
perform any operation (INSERT,UPDATE,DELETE,SELECT) or
Indexing anything else.
Where is this question asked?
Thanks,
Bru Medishetty
www.LearnSQLWithBru.com
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between count and distinct count?
What are pages and extents? : SQL Server Architecture
Explain sql server authentication modes?
How do I open port 1433?
What does REVERT do in SQL Server 2005?
Why and when do stored procedure recompile?
What is ddl and dml commands?
What are the different normalization forms?
When is update_statistics command used?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
What are the methods used to protect against sql injection attack?
What are the disadvantages of using the stored procedures?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is a hint?