Viewing 7 posts - 16 through 22 (of 22 total)
After more thought it strikes me as this is almost a bug in that it would seem that the parser/normalizer should recognize early on that the sub query is not...
April 22, 2009 at 8:21 am
Grant, no problem. Thanks for your help in figuring this out. We have a lot of views that will need review based on this and I have a new method...
April 21, 2009 at 7:35 pm
Grant, it looks like your theory is, on the surface, correct. The query that does not explicitly reference the sub query columns is consistently a little bit faster than the...
April 21, 2009 at 2:07 pm
Grant, let me know if this is not what you are looking for.
AVERAGE EXECUTION TIME for query not referencing sub query columns
Time Statistics
Client processing time0.0000
Total...
April 21, 2009 at 1:39 pm
Just getting back to the thread, got caught in a webex...
I am running on my local dev box and am running dbcc dropcleanbuffers and dbcc freeproccache before each run. I'll...
April 21, 2009 at 1:10 pm
Hi Grant, Thanks for having a look at this! It would appear that a lot more is happening when explicitly selecting the sub query columns.The statistics IO output...
STATISTICS IO for...
April 21, 2009 at 12:43 pm
Thank you Grant for your reply and help!
Here is the setup...
/*VIEW DEFINITION*/
/*NOTE: VBaseAllUsers accesses the base tables directly*/
create view VAllUsers as
select
VBaseAllUsers.*,
(
select count(*)
from UserStudentAssoc
where UserStudentAssoc.UserID=VBaseAllUsers.iUser
and AssocType=1
and DomainID...
April 21, 2009 at 9:39 am
Viewing 7 posts - 16 through 22 (of 22 total)