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...

I'm not sure I understand the question. Are you trying to tune queries where there is a lot NULL columns?

If so, yes, this can be an issue in 2005 and...

Bruce W Cassidy (4/19/2009)

---

[font="Verdana"]For me personally I prefer C#. But you will probably find there's a bigger audience for VB....

It honestly depends on what the optimizer considers to be a trivial plan. Here's an explanation of how plans are determined: http://msdn.microsoft.com/en-us/library/aa226174.aspx