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

Difference between DELETE and TRUNCATE?

0 Answers   TCS,


define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,


diffrence between function and procedure

5 Answers   Wipro,


What are sql server functions?

0 Answers  


What is sql server programming?

0 Answers  






What is Transparent Data Encryption?

0 Answers  


How to return the date part only from a sql server datetime datatype?

0 Answers  


Which are the new data types introduced in sql server 2008?

0 Answers  


you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  


What are the common performance issues in sql server?

0 Answers  


What is a result set object returned by mssql_query()?

0 Answers  


What function does a database engine serve in the sql server?

0 Answers  


Categories