Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Query/SP Optimization

Author  Topic 

srkvellanki
Starting Member

14 Posts

Posted - 2009-10-08 : 11:25:41

Hi All,

In a Interview i was asked this question.If a Query/SP is running slow how do you optimize it.Appreciate if you share detailed information.


Regards
Sri

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-10-08 : 12:07:41
On that question I would answer: SET PRIORITY BOOST = 1

just kidding


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -