1.

What Is Your Recommendation For A Query Running Very Slow?

Answer»

Well, your question is very difficult to answer without looking at the code, application and PHYSICAL server. In such situations, there are a few things that MUST be paid attention to right away.

RESTART Server
Upgrade HARDWARE

Check Indexes on Tables and Create Indexes if necessary Make sure SQL Server has priority over other operating system processes in SQL Server settings.

Update STATISTICS on the database tables.

Well, your question is very difficult to answer without looking at the code, application and physical server. In such situations, there are a few things that must be paid attention to right away.

Restart Server
Upgrade Hardware

Check Indexes on Tables and Create Indexes if necessary Make sure SQL Server has priority over other operating system processes in SQL Server settings.

Update statistics on the database tables.


Discussion

No Comment Found

Related InterviewSolutions