What will you do If the low Performance occurs?

Question Posted / vamsimadineni

2 Answers
4234 Views
I also Faced
E-Mail Answers

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

Can a function call a stored procedure in sql server?

0 Answers

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers

What is a view?

6 Answers

What is the difference between a primary key and a unique key? Are they the same?

0 Answers

where the connection string store in the database

0 Answers HCL, Wipro,

Is it possible to call a stored procedure within a stored procedure?

0 Answers

what are isolation levels? : Sql server database administration

0 Answers

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