It sure sounds like blocking, but since you say it's not, I'd step back a bit, not look at that procedure directly and instead examine the waits and queues on...

GilaMonster (4/21/2009)

---

mithun.gite (4/21/2009)

---

GilaMonster (4/21/2009)

---

I can suggest some books.

Inside SQL Server 2005: Query...

I would have to see the code to fully understand the issue. However, no, there's no way to selectively limit the query defined within a view. The query is going...

That's tough.

Without rearchitecting... I'd suggest setting up server side traces and capture query performance behavior. Then, go after the top poor performers. I'd focus on establishing a good set of...

You basically need a baseline to compare against. I'd suggest collecting the information when there are very few users on the system and then when there are lots of users....

The one thing no one seems to have mentioned is the selectivity of the data. Just because there are 10 columns and just because each of the 10 is used...

I wouldn't recommend using this method in the WHERE or JOIN clauses of your queries, but for the SELECT list, instead of CASE statements, try this:

SELECT COALESCE(MyColumn,'') AS MyColumn

...

That will...

You can also run it from Profier (Tools - Database Engine tuning Advisor) or from a SSMS query window (Query - Analyze Query in Database Enging Tuning Advisor).

I agree with GSquared. Capture the query info and make decisions from there. The one other thing that you might concern yourself with is the volatility of the data in...

GilaMonster (4/20/2009)

---

Jack Corbett (4/20/2009)

---

Another note for the non-Twitterer's is that there have been 358 sessions submitted to PASS so far, deadline is Friday at Midnight, for about 80-90 slots available....

Jack Corbett (4/20/2009)

---

In 2005 yes, but in 2008 you can use C# as well. My current work...

SQL Server is heavily involved on managing parallelism. It has to to merge the data from the various streams so, it does quite a lot of work.

Krishna Potlakayala (4/18/2009)

---

fayilt (4/18/2009)

---

I use set showplantext on to get execution plan of my query, but I feel that I am lack of theoretical knowledge about it. Where can I...

Yes, you can follow the link provided above and download the book for free. It's also available in a dead-tree version from Amazon if you prefer reading from paper.

Also, you...

Parallelism is an expensive process because of all the management that SQL Server has to do. So, you only want it to run on queries that are running long already...