application server is slow what may be the problem

Question Posted / patlolla.dba

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

More SQL Server Interview Questions

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

How global temporary tables are represented and its scope?

What is the difference between an index and a unique index?

Find top Nth employee from each department in terms of salary?

What are the steps you will take to improve performance of a poor performing query?

what is datawarehouse?

What is fill factor and pad index?

What are the types of model in sql server and explain

Which sql server table is used to hold the stored procedure script?

What is database replication? What are the different types of replication you can set up in sql server?

What are views in ms sql server?

What are the basic functions for master, msdb, model, tempdb and resource databases?

For more SQL Server Interview Questions Click Here