Interested to Buy Any Domain ? << Click Here >> for more details...
How to perfor If the table running time is taking 2hours
and table is having 10 rows in it?
- 1 Answers
- 3767 Views
- I also Faced
- E-Mail Answers
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
How do I partition a table in sql server?
what stored procedure can you use to display the current processes? : Sql server administration
What is table join?
What will be the maximum number of index per table?
Where are SQL server users names and passwords are stored in sql server?
Can you explain what are commit and rollback in sql?
How to Update from select query in sql server?
What is advantage data architect?
What is meant by referential integrity?
What are the limitations/drawbacks or ssrs 2008 r2?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is the command used to recompile the stored procedure at run time?
Do you know the capabilities of cursors?
What is tabulation?
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?
