This is gonna be a monster SUM(CASE ...) query, but definitely doable as long as the column values are known. Have fun Jeff. Something like this is billable...

1) I would turn off hyperthreading. it is more often suboptimal than helpful for sql server workloads

2) your disk metrics are not as good as you think. 10...

1) why are you checking for memory problems? Those are maybe 5% of the actual performance problems out there.

2) are you actually HAVING any performance problems? ...

Jportelas (12/2/2009)

---

Yep, Visio is great, but the diagrams are UML diagrams and those are not exactly ER models. In the company I work for they require the diagrams to be...

mohammed moinudheen (12/2/2009)

---

Just one doubt, in SQL server 2005 we have reorganize, rebuild index tasks in maintenance plans

But in SQL server 2000 when we run optimization jobs, does it do...

doobya (12/3/2009)

---

I wouldn't download the BOL

use the lightweight online version

http://msdn.microsoft.com/en-us/library/ms130214.aspx

I would avoid the (extremely bad) microsoft local help system

the online versions are much quicker

that is unless you like:

- waiting up...

Actually LMU our queries do not produce the same plan. It only seems that way due to the limitations of the graphical query plan you probably looked at. ...

RBarryYoung (12/1/2009)

---

You know, this kind of constant product spamming would go down a lot easier if...

I didn't use the NTILE function because it seemed the OP wanted the 'buckets' of leads per salesperson to be evenly distributed in desc order. Something semi-random such as...

I...

Here is another solution that doesn't require an identity column:

select name, LeadQuality, CASE WHEN (LeadOrder+3)%4=0 THEN 1

...

Unless you have very few rows in the table relative to the amount being added, I would say that dropping the indexes and recreating them would NOT be the best...

If you know IN ADVANCE what date range you wish to deal with, then a fixed query such as below is perfect. If you don't, then I recommend you...

Isn't this the best solution for the stated problem?

select Total, Type1Count, Type1Count*100.0/Total as Perc1, Type2Count, Type2Count*100.0/Total as Perc2

FROM (

select count(*) as Total,

sum(case...

I highly recommend you download the latest copy of SQL Server 2005 Books Online, install it, and get very familiar with it. It is a wonderful resource!!!

Here is the...