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

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

---

What is the difference between dropping a database and taking a database offline?

0 Answers  

---

Does partitioning improve performance?

0 Answers  

---

Is truncate a dml command?

0 Answers  

---

What are indexers?

0 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,

---