Viewing 14 posts - 1 through 15 (of 15 total)
Sorry to bombard - but if you tryEXECUTE AS [YourFastUserGoesHere] - does it change the performance?
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 7, 2011 at 7:38 am
Gianluca Sartori (7/7/2011)
Is resource governor configured?
Beat me to it 😉 - could you provide the query and the context of the differing users...?
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 7, 2011 at 7:35 am
Have you tried SET STATISTICS IO ON; and are they the same for each?
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 7, 2011 at 7:33 am
Brandie Tarvin (7/7/2011)
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 7, 2011 at 7:30 am
Try running a trace for each user and then compare the results...
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 7, 2011 at 7:23 am
Is the R drive on the server (or machine) you are running the query from?
Is it a network drive or share?
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 1, 2011 at 9:13 am
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/
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 1, 2011 at 8:46 am
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
...
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 1, 2011 at 8:43 am
Duplicate post -
http://www.sqlservercentral.com/Forums/Topic1135045-391-1.aspx
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 1, 2011 at 8:35 am
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"...
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 1, 2011 at 8:32 am
mtillman-921105 (6/28/2011)
Ninja's_RGR'us (6/28/2011)
SELECT
T.name,
STUFF((
SELECT
...
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 1, 2011 at 8:28 am
Congrats!
Can I ask - how many questions are there in the exam?
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 1, 2011 at 8:24 am
So, my thinking was, if the last_elapsed_time is greater than the avg elapsed time, this would indicate a "long running query" In other words, its greater than the average.
I would...
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
June 29, 2011 at 7:47 am
gsc_dba (6/27/2011)
And set @tableHTML to be your "No data available..." when exists...
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
June 27, 2011 at 3:30 am
Viewing 14 posts - 1 through 15 (of 15 total)