What will you do If the low Performance occurs?

Answers were Sorted based on User's Feedback



What will you do If the low Performance occurs?..

Answer / bhanu pratap singh

We will create "full text search" in our database queries,
by doing it we can increase the speed of our queries.

Is This Answer Correct ?    0 Yes 1 No

What will you do If the low Performance occurs?..

Answer / yudistara

reducing complexity of the sql statements..
verifying indexes..
available storage space...
\Let me know is there any misleadings

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is a trigger and types of a trigger?

0 Answers  


Define model database?

0 Answers  


Explain for xml explicit mode?

0 Answers  


If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  


what is diffrent between store procedure and trigger

2 Answers  






What is a partition key?

0 Answers  


how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,


What is use of @@ spid in sql server?

0 Answers  


Explain the different types of joins?

0 Answers  


Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,


Why we are using the sql language?. What is the purpose of using this?

2 Answers  


What is the difference between update lock and exclusive lock?

0 Answers  


Categories