Answer / Vishav Pratap Singh

The slow performance of an application server could be due to various reasons such as high traffic, database issues, memory leaks, inefficient code, or hardware limitations. To troubleshoot, you can check the server logs for errors, monitor resource usage, optimize the code, and consider scaling up the server resources if needed.

What are the different types of join?

1 Answers  

---

where the connection string store in the database

1 Answers   HCL, Wipro,

---

How real and float literal values are rounded?

1 Answers  

---

what is the maximum size of a row in sql server 2000 and 2005

2 Answers  

---

How to provide default values to function parameters?

0 Answers  

---

Do you know nested transaction?

1 Answers  

---

Where can you add custom error messages to sql server?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

How can you start sql server in different modes?

1 Answers  

---

How to stop a loop early with break statements in ms sql server?

1 Answers  

---

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

---

What are the different normalization forms?

1 Answers  

---