Answer / Ashok Kumar Ray

To improve the performance of a poor performing SQL Server query, consider the following steps: 1) Optimize Indexes: Ensure that your tables have appropriate indexes on frequently queried columns. 2) Query Tuning: Simplify complex queries by removing unnecessary joins or subqueries and optimizing their order. 3) Use appropriate functions: Avoid using built-in functions like COUNT(*), AVG(), MIN(), MAX() within the WHERE clause as they can significantly slow down performance. Instead, use SELECT DISTINCT or filter the results in your application code. 4) Monitor and analyze wait stats: Regularly monitor wait stats to identify potential bottlenecks in the database system. 5) Database Maintenance: Regularly perform database maintenance tasks like rebuilding indexes, cleaning up old data, or defragmenting the database to maintain optimal performance.

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1 Answers  

---

write coding for importing sql data into a word excel...

1 Answers   Oracle,

---

Give main differences between "Truncate" and "Delete".

1 Answers   HCL,

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

What does the INSTEAD OF trigger do?

3 Answers  

---

What do you understand by check constraint in sql server?

1 Answers  

---

Can group by and orderby be used together?

1 Answers  

---

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

---

Explain how to send email from sql database?

1 Answers  

---

What are the purposes and advantages stored procedure?

1 Answers  

---

What are the new features in sql server 2016?

1 Answers  

---

What is the need for indexing?

1 Answers  

---