NOW we are starting to get somewhere! :w00t:

alter function dbo.fn_totalprice (@orderid varchar(max))

returns varchar(max)

as

BEGIN

declare @result money

select @result = sum(UnitPrice * Quantity) from [Order...

jlp3630 (11/10/2008)

---

TheSQLGuru (11/10/2008)

---

The query with the lowest IO requirement is the one with the lowest logical reads (unless there are LOB reads, in which case you also compare lob logical...

If you want a 'cursor', simply create a UDF that takes an OrderID and calculates the SUM in the output. I leave it to the inquisitive reader to implement...

No need to 'guess' there! That was indeed a LONG way of saying "it depends"!! 😀

Gail, your index choices and join choices were 'too good'! 🙂 Try this one:

SELECT CompanyName, OrderDate, ProductName, OD.UnitPrice, Quantity, SUM(OD.UnitPrice) over (partition by CompanyName, OrderDate, ProductName,...

The query with the lowest IO requirement is the one with the lowest logical reads (unless there are LOB reads, in which case you also compare lob logical reads).

>>but they want only the categories that have products,

Doesn't that indicate the need for an EXISTS clause, not a direct join?? Exists would be orders of magnitude faster...

Marios Philippopoulos (11/6/2008)[hr

Thanks, I have a question on how to judge a SAN's performance (what to use as a baseline etc.), but perhaps this can be reserved for a separate...

I must have missed the smiley that indicated you were joking. As for resources required, the main issue with that statement is that almost everyone simply uses SIZE as...

That is emphatically NOT correct. auto...

Marios Philippopoulos (11/6/2008)

---

Would all 1024 drives be 'seen' by the same SQL server instance and shared by all other SQL instances? How does that help with IO throughput? Isn't contention...

Marios Philippopoulos (11/6/2008)

---

TheSQLGuru (11/6/2008)

---

1) Can you have 1024 drives direct attached effectively? You can do that...

1) Can you have 1024 drives direct attached effectively? You can do that with a 3Par...

One other thing: did you verify that there are no other batch jobs, maintenance jobs (such as backups or checkdbs), etc running between 2330 and 0330?

I agree with Jeff, 4 hrs to redo indexing on 65GB isn't unreasonable unless you have pretty good hardware.

I would check out IO stalls (fn_virtualfilestats). Also, how...