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
List the types of recovery model available in sql server?
What is constraints and its types?
What are the built in functions in sql server?
Can you insert NULL in unique column?
What are data driven subscriptions?
What is the new security features added in sql server 2016? : sql server security
What are partitioned views and distributed partitioned views?
What are the five major components of a dbms?
What is 2nf example?
What are key constraints?
how can a database be repaired? : Sql server administration
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Sql server reporting services vs. Crystal reports.
What is the difference between an index and a unique index?