1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how to improve the speed of SQL database server and how to
avoid dead lock?

Question Posted / vijeesh v


how to improve the speed of SQL database server and how to avoid dead lock?..

Answer / indira gandhi

1.check th disc space u have to use
2.check the profile client have any job,and query problem
3.use update_satistics to update indexes

-------------------------
to avoid the deadlock

use nolock command in select staement

Is This Answer Correct ?    11 Yes 5 No

Post New Answer

More SQL Server Interview Questions

What is row_number function?

0 Answers  

Explain what is analysis service repository?

0 Answers  

How to concatenate two strings in SQL Server.

0 Answers   HCL,

How to see existing views in ms sql server?

0 Answers  

how many instance use in sql server 2005

4 Answers   EFI, HCL,




How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

Explain DBCC?

0 Answers   QuestPond,

What is tabulation?

0 Answers  

How do I connect to sql server database?

0 Answers  

Explain difference between control flow and data flow?

0 Answers  

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

What are the restrictions that views have to follow?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories