I agree with Gail. The other issue with using the Profiler GUI is that events can be lost on a very busy server, while a server-side trace will not...

Okay, Barry beat me to it. He used the derived table and I used the CTE, but the results should be the same unless I made mistake.

Here's how I'd do it:

;With cteItemTotalSales As

(

Select

IP.ItemNumberSK,

Sum(SI.Qty) as total_sold

From

item_purchase IP Join

sales_item SI On

IP.ItemNumberSK = SI.ItemNumberSK

Group By

IP.ItemNumberSK

)

SELECT

st.StoreName,

st.StoreCountry,

si.ItemNumberSK,

si.ItemName,

(SUM(si.Qty)/Convert(Float, total_sold)) as sales_pct

FROM

STORE st Join

ITEM_PURCHASE ip On

st.StoreNumberSK = ip.StoreNumberSK...

I've never worked with databases that size, but with the proper configurations I don't know why SQL Server wouldn't scale to that. It's more of a storage issue than...

Well, if you included the deadlock events I'd look for any of them first. Then I'd look at duration, cpu, reads, and writes. I forgot to mention before...

If you are planning on using Sharepoint and it's document management solution then you are tied to SQL Server since that is the backend of Sharepoint.

Even if the SQL Service account has access to the mapped drive, if you are accessing it via drive:\folder then you are not guaranteed that it will work. I...

From my experience it is one or the other. You would have to write your own No Rows message to get the header rows to show.

I would recommend...

IT looks like you have an instance of SSIS installed, but not the Database Engine, or the database engine is not configured to allow remote connections.

Are you getting any errors? Are you trying to send mail from SQL Server Agent jobs?

What happens when you execute sp_send_dbmail? Look it up in BOL for syntax.

Hey Brandie, thanks for posting the code.

No problem, Barry, I was interested in it, too. Kind of an interesting concept.

Can you provide the code you are using to create the Spry Dataset from the XML file?

Barry, here's a link to Spry http://livedocs.adobe.com/en_US/Spry/1.4/help.html?content=WSAD0FE19A-16F7-4479-9733-EA693A2B41CF.html. Apparently it's an Adobe technology.

Sounds like a good and flexible solution.