Sorry to bombard - but if you tryEXECUTE AS [YourFastUserGoesHere] - does it change the performance?

Beat me to it 😉 - could you provide the query and the context of the differing users...?

Have you tried SET STATISTICS IO ON; and are they the same for each?

Brandie Tarvin (7/7/2011)

---

Jeffrey, I know I can change connections after bringing things up, but I tend to have so much going on at once that I don't always remember to...

Try running a trace for each user and then compare the results...

Is the R drive on the server (or machine) you are running the query from?

Is it a network drive or share?

During the ETL process of the particular dimension you could utilise the MERGE function to alleviate these kinds of issues...

The advice here http://www.sqlservercentral.com/Forums/Topic735049-23-1.aspx may be of assistance...

Also http://www.sqlservercentral.com/scripts/Common+Table+Expression+(CTE)/62599/

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

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'AdventureWorks2008R2 Administrator',

@recipients = 'danw@Adventure-Works.com',

@query = 'SELECT COUNT(*) FROM AdventureWorks2008R2.Production.WorkOrder

...

Duplicate post -

http://www.sqlservercentral.com/Forums/Topic1135045-391-1.aspx

I second what Elliott has stated and also add that if someone is creating/dropping or altering databases then you should review security and permissions and "nip it in the bud"...

mtillman-921105 (6/28/2011)

---

Ninja's_RGR'us (6/28/2011)

---

Here's a sample concat code. Enjoy the little tweaks!

SELECT

T.name,

STUFF((

SELECT

...

Congrats!

Can I ask - how many questions are there in the exam?

I would...

gsc_dba (6/27/2011)

---

You could also circumvent the @varCheck by setting the @tableHTML = your result set when exists = true

And set @tableHTML to be your "No data available..." when exists...