Viewing 15 posts - 1,201 through 1,215 (of 1,838 total)
schoenbeck16 (12/9/2016)
...I don't think this one will work as is, since the variable will only hold the last value selected.
OK, I thought there was only 1 row in the ROLES...
December 9, 2016 at 9:46 am
MadAdmin (12/6/2016)
SET options.
I agree that this may be a good place to start. A common problem comparing a query running in Management Studio vs the same query run from...
December 9, 2016 at 7:39 am
It's difficult to tell without knowing the indexes on these tables, but I'm thinking Steve's query is more expensive since it's hitting all 3 base tables twice, and the only...
December 9, 2016 at 7:08 am
Kris-155042 (12/7/2016)
Regardless of who is using it for what, unless it's development SQL server then you have to pay for the license.
This is definitely not right, in many cases Microsoft...
December 8, 2016 at 7:47 am
I notice you've rewritten part of the stored procedure, USP_ICMExtendedSummaryReport_Temp, now has:
...
from dbo.EOS_Reports c with (nolock)
INNER JOIN #TempUserAccess T on T.AccessID = c.OrgPathID AND T.AccessType = 'NONSHARED'
where
...
December 7, 2016 at 2:48 pm
Charlottecb (12/7/2016)
...From ParentTable a
left outer join (selecta.[RecordID],
isnull(min(A.[Number]), 0) as [MinNumber]
from[ChildTable] a
where a.[StartDate] between @Week02 and @Week03
group by a.[RecordID]) y on y.[RecordID] = a.[RecordID]
...
Do you have a calendar table, or something...
December 7, 2016 at 12:12 pm
Jeff Moden (12/7/2016)
...Here's to you, Dwain. May your work and our memories of you last forever. You were a great man and a thoughtful and humble human...
For many...
December 7, 2016 at 11:25 am
CELKO (12/6/2016)
December 7, 2016 at 6:48 am
sqlandbiuser (12/6/2016)
Any further inputs...
December 6, 2016 at 7:00 am
Hmm, now I'm starting to wonder if I code better when I drink Earl Grey over plain old Lipton tea. 😉 I always try to limit myself to...
December 5, 2016 at 1:54 pm
sqlandbiuser (12/5/2016)
SharedOrgPathID is also part of clustered key. 3rd Column in the index definition.
true... but each part of the UNION is evaluated by the optimizer as a separate query, then...
December 5, 2016 at 1:24 pm
sqlandbiuser (12/5/2016)I have put code in same folder, thanks for your inputs.!
OK looking at the whole stored procedure code (I could only see part of it using the sqlplan file),...
December 5, 2016 at 1:00 pm
sqlandbiuser (12/5/2016)
...I am not getting why clustered scan, because OrgPathID is part of Clustered Index key defined on EOS_Reports table
...
When considering how SQL Server uses indexes, the order of...
December 5, 2016 at 12:34 pm
There are a number of reasons that there could be multiple execution plans for the same stored procedure. One common case is the connection settings of the sessions that...
December 5, 2016 at 12:14 pm
I'm still reading through all this code and the execution plan, but here's some initial things I see that give me some concern:
1. I see you're using a multi-line...
December 5, 2016 at 9:34 am
Viewing 15 posts - 1,201 through 1,215 (of 1,838 total)