What will you do If the low Performance occurs?

Question Posted / vamsimadineni

2 Answers
4308 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

How to use "begin ... End" statement structures in ms sql server?

0 Answers

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers Amdocs,

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers

Why the trigger fires multiple times in single login?

0 Answers

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers

How to provide column names in insert statements in ms sql server?

0 Answers

Explain triggers?

0 Answers

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers Microsoft,

What is the disadvantages of index?

3 Answers TCS,

What is raid, and how it can influence database performance?

0 Answers

What is key attribute?

0 Answers

What is compression - row-level and page-level compression?

0 Answers

For more SQL Server Interview Questions Click Here