How to perfor If the table running time is taking 2hours
and table is having 10 rows in it?



How to perfor If the table running time is taking 2hours and table is having 10 rows in it?..

Answer / 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

More SQL Server Interview Questions

Explain what is the use of custom fields in report?

0 Answers  


What does it mean if @@cursor_row returns a negative number?

0 Answers  


What is clustered index

0 Answers  


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  


what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,






Which are new data types introduced in sql server 2008?

0 Answers  


Explain activity monitors

0 Answers  


Explain what are commit and rollback in sql?

0 Answers  


What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,


According to you what goes into making the best database administrator? : sql server database administration

0 Answers  


What is sql server profiler trace data file?

0 Answers  


How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  


Categories