Answer / suresh

check if any indexes is created for that table if not
create it. Open connection and close immediately when no
longer in use.

Answer / ram

you need to check the following things:

1. Database size is very high and you are using query which
is not optimized.
2. you must be using too many joins in the query. Check the
execution plan
3. Confirm whether the CPU utilization is more from database
end or application end

http://www.interview-questions.maxmice.com

my project run very wel in my sytem yhen i am deploying my project on client machine ,after deployment i run my project then it show " can no find server name " what i do .

0 Answers  

---

What is JIT(Just In Time) and How it works?

5 Answers   Data Entry Operator, Infocons, Siemens,

---

What is the difference between value and reference types?

0 Answers  

---

What is sealed class?

0 Answers  

---

how to restore database using vb.net?

4 Answers   Eclat, PCS, Pepon, Restor, TCS,

---

ColumnMapping belongs to which namespaces?

1 Answers  

---

Display a roll having minimum marks in two subjects?

1 Answers   Patni,

---

Can you please explain the difference between c# and vb.net?

0 Answers  

---

What does VS.NET contains ?

3 Answers   Infosys,

---

how to send data to exe file? my code has a button when i press it, an exe file will open. how can i send data as input to the exe file?

2 Answers  

---

Is it necessary to have SQL server installed in your computer in order to create a service based database in vb.net?

0 Answers  

---

if user enters 1 or 2 or any other number in digit format in next textbox it should show the answer in word reading like if enters 12 answer should be twelve

4 Answers  

---