Viewing 15 posts - 4,186 through 4,200 (of 18,926 total)
GilaMonster (7/29/2011)
No difference at all. Look at the execution plans, they'll be exactly the same.
I was going down that route too, untill I only saw 1 operator per plan :hehe:.
Might...
July 29, 2011 at 11:43 am
Chad Crawford (7/29/2011)
bitbucket-25253 (7/29/2011)
What makes an index tick and why do they make your queries faster.
Is a title that would attract myself, as far as the I6 reference, would...
July 29, 2011 at 11:40 am
Nether creates a temp table.
The difference is that you can reuse the cte without having to retype it in the query. But that now runs 2 twice.
The real difference...
July 29, 2011 at 11:39 am
What do you want to do with this? Maybe we can help out if you can give more details.
July 29, 2011 at 11:35 am
Chad Crawford (7/29/2011)
Ninja's_RGR'us (7/29/2011)
Chad Crawford (7/29/2011)
Thought up agoodcheezy title this morning: "The new i6 (Investigation Into Index Internals, Including Implementation)"What's I6????
Investigation Into Index Internals,...
July 29, 2011 at 11:34 am
coronaride (7/29/2011)
the thread that will never end 🙂
Much like your ETL process. :w00t:
PS that's the real never-ending thread >>> http://www.sqlservercentral.com/Forums/Topic604325-61-571.aspx#bm1151139
July 29, 2011 at 11:28 am
A little easier on the eyes...
declare
@StartTime DateTime= '07/08/2011 19:00PM'
, @EndTime DateTime
, @StartTimeUTC datetime
, @EndTimeUTC dateTime
, @radid int
--set @StartTime...
July 29, 2011 at 11:24 am
Please post both actual execution plans so we figure the best way out of the parameter sniffing problem (yes that's the issue).
July 29, 2011 at 11:22 am
Lowell (7/29/2011)
there you go!
re-tx 😀
July 29, 2011 at 11:18 am
Ninja's_RGR'us (7/29/2011)
Can you make that image a little larger. That text looks like TSQL but I'm not even sure... and yes I have good eye-sight!
Tx.
July 29, 2011 at 11:17 am
Can you make that image a little larger. That text looks like TSQL but I'm not even sure... and yes I have good eye-sight!
July 29, 2011 at 11:13 am
coronaride (7/29/2011)
July 29, 2011 at 11:11 am
Chad Crawford (7/29/2011)
Thought up agoodcheezy title this morning: "The new i6 (Investigation Into Index Internals, Including Implementation)"
What's I6????
July 29, 2011 at 11:07 am
Happy to help, TIA for the feedback.
July 29, 2011 at 11:07 am
Here's a nice thread... read from there on down.
July 29, 2011 at 10:57 am
Viewing 15 posts - 4,186 through 4,200 (of 18,926 total)