jlp3630 (11/10/2008)

---

Thanks for the advice. Unfortunately, a consultant is not an option because I'm working for a startup company. I was hired on to be the DBA because of my...

Dude, if you are new to perf tuning and are looking to improve stuff that currently takes days to run that could be a pretty tall order. 🙂

Here is...

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