What is your recommendation for a query running very slow? : sql server database

What is your recommendation for a query running very slow? : sql server database administration

Question Posted / kush gandhi

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

What are transactions in sql?

What causes index fragmentation?

what is index seek and index scan?

When a primary key constraint is included in a table, what other constraints does this imply?

What is the library index called?

Explain the steps to create and execute a user-defined function in the sql server?

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

What is bit datatype and what's the information that can be stored inside a bit column?

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

what is a cursor and what is its use?

How to create a user to access a database in ms sql server using "create user" statements?

What are sub-queries? Give example? In which case sub-queries are not feasible?

For more SQL Server Interview Questions Click Here