Niraj (1/4/2009)

---

Hi...:)..

I guess..while deployment of data sources and reports itself...you can deploy the respective data sources in an individual folder..the reports must access their concerned data sources....

Please let me knw...if...

Perry Whittle (12/28/2008)

---

as you say, depends if the system is already live. If your...

Yes, I took database backups. However, I was trying to save time and not...

Perry Whittle (12/25/2008)

---

not at all.

RAID 10 will generally offer a performance boost over RAID1 due to the striping across mirrored sets. As SQL server...

What perfmon data would you recommend capturing?

GSquared (12/4/2008)

---

Matt Miller (12/3/2008)

---

GSquared (12/3/2008)

---

It won't matter as much in a Group By as it does in a Where, since the Where clause problem is table/index scans instead of seeks,...

Bob Hovious (11/19/2008)

---

However, I don't understand your concern about insertions if you are building strings under your own control. I am guessing that the AVG(clean_sale_price) function could...

Are you referring to...

The queries that I posted are actually the rewritten versions. Over the course of the report creation, this stored procedure (and it's "sibling" stored procedures) is getting called about 25000...

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

TheSQLGuru (11/10/2008)

---

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

When...

I re-attached an updated version of the table_definitions.txt with the table indices.

I'm actually trying to optimize someone else's stored procedure. The DISTINCT keyword existed in the previous version of...

I've attached the 2 queries with all the query table's I/O information, referenced functions, and create table statements.

If you need anything else, please let me know.

Thanks again for your input.

Grant Fritchey (11/6/2008)

---

It's clearly not a wash, one of the procedures is doing something more effeciently than the other, but the return times don't seem indicative of the resource cost....