August 14, 2010 at 1:01 pm
Paul White NZ (8/14/2010)
Jeff Moden (8/13/2010)
Paul White NZ (8/12/2010)
What sort of hint did you have in mind? Index hints don't work with table variables, and you can't give the PRIMARY KEY or UNIQUE constraints names anyway!Heh... I removed it from the Running Total article and you've forgotten it already. 😉 Remember? From BOL...
If a clustered index exists, INDEX(0) forces a clustered index scan and INDEX(1) forces a clustered index scan or seek. If no clustered index exists, INDEX(0) forces a table scan and INDEX(1) is interpreted as an error.
As if I would forget that! Index hints just don't work at all with table variables: not even INDEX(number). You get a syntax error if you try it 😛
Even the new 2K8 OPTION (TABLE HINT...) clause is ignored (or produces an error in some cases):
DECLARE @T TABLE (A INT NOT NULL PRIMARY KEY, B INT NOT NULL UNIQUE, C CHAR DEFAULT 'Z');
INSERT @T (A, B) VALUES (1, 1), (2, 2), (3, 3);
WITH CTE AS (SELECT * FROM @T)
SELECT B, C
FROM CTE
WHERE B = 2
OPTION (TABLE HINT(CTE, INDEX(0)))
Despite the INDEX(0) hint, the plan uses a non-clustered seek plus bookmark lookup on the UNIQUE index instead.
I voted for your PASS session, I hope you get selected - I'm intrigued to see your new hierarchy idea.
Paul
Heh... I'm a whole lot embarassed. :blush: I didn't even try the hint on a table variable because I don't use table variables except as a "container" for iTVF's. My very sincere apologies and thank you for the correction.
On the hierarchy thing, thank you VERY much for your vote. It's a funny thing. I submitted the hierarchy abstract thinking that they'd be more interested in something "new". I submitted the Tally Table session just to see if I could shoehorn a "grass roots" session into the dev path. I was surprised when they picked the Tally Table session as my primary session because, well... I didn't believe that anyone was interested in grass roots sessions at PASS any more. I'm very glad that I was totally wrong there and I don't mean because it gives me a chance to present at PASS.
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to Hierarchies. I'd have absolutely no problem teaching 5 sessions. If I get some time (in the middle of a very time consuming project right now for work), I'm thinking about targetting an SQL Saturday or two for presentations. Between plane tickets and hotel rooms, it's just a wee bit expensive and I'm getting too bloody old to do the double red-eye thing in a single day. 😛 Heh... it's not that I can't... I just don't want to anymore.
It's like one of my favorite sayings at work when someone says they thought I couldn't hear well... "Old folks aren't hard of hearing... we're just tired of listening." 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
August 15, 2010 at 6:56 pm
Lynn Pettis (8/14/2010)
Just registered for SQLSat52. Sorry, couldn't pay for lunch, will have to fend for myself.So who all is going to be there?
I'll be there. see you in Sept.
August 16, 2010 at 12:18 am
Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to Hierarchies.
It does seem that the 'basics' sessions are preferred this year for some reason. It's important, of course, but I think it'd be a shame if the balance swung too far in that direction for too long. Well, good luck anyway. If the world makes any kind of sense, the Hierarchies session will make it 🙂
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
August 16, 2010 at 1:56 am
Lynn Pettis (8/13/2010)
Guess where I'll be on August 29th? At my first Bronco game! Family gave me an early birthday present!
GO Broncos!
Nice! 😀
I got tickets for the International Series in UK :w00t:
I'd say GO 49ers!
But I don't think it would do any good 🙁
Far away is close at hand in the images of elsewhere.
Anon.
August 16, 2010 at 2:18 am
Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to Hierarchies. I'd have absolutely no problem teaching 5 sessions.
Typically (at least the times I've submitted), there's a limit of 4 submitted abstracts and it's fairly uncommon to have more than 2 sessions accepted.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2010 at 5:53 am
GilaMonster (8/16/2010)
Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to Hierarchies. I'd have absolutely no problem teaching 5 sessions.Typically (at least the times I've submitted), there's a limit of 4 submitted abstracts and it's fairly uncommon to have more than 2 sessions accepted.
This year there was a hard cap of 2 on the number of accepted sessions by a single speaker. The main reason is to give an opportunity for new speakers. Otherwise the top speakers would each get 4 or 5 sessions, if they wanted, and there would be few, if any, new speakers. For example, there were 27 available community session slots in the DBA track and 150 sessions submitted. If the number of sessions per speaker had not been capped then instead of having 20+ speakers we probably would have had 10-15 speakers.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 16, 2010 at 6:14 am
GilaMonster (8/16/2010)
Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to Hierarchies. I'd have absolutely no problem teaching 5 sessions.Typically (at least the times I've submitted), there's a limit of 4 submitted abstracts and it's fairly uncommon to have more than 2 sessions accepted.
They have a hard limit on 2 sessions. Although, I think they flex those rules for the A-Listers.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 16, 2010 at 6:23 am
Alvin Ramard (8/14/2010)
Greg Edwards-268690 (8/13/2010)
P.S. If you're in the Memphis area tonight, come join us for:
Dan Evans - Creating an EPM Environment Using Microsoft SQL Server 2008 R2 and SharePoint 2010
Check our humble website for more details: http://Mem-PASS.org
I don't suppose I got lucky and this was recorded?
Exactly where we are headed, working on building a dev environment to play with.
Greg E
Greg, Dan will be presenting this again at SQL Saturday #51 in Nashvilee, on Aug 21st.
It would be a long drive from Mpls.
Have a 50th wedding anniversary for my ohter half's aunt and uncle that day.
She also has relatives up from Florida staying with us.
So I have no plans of my own, but have plenty of plans that weekend. ;>)
Thanks for thinking about me though.
Greg E
August 16, 2010 at 6:59 am
Jack Corbett (8/16/2010)
GilaMonster (8/16/2010)
Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to Hierarchies. I'd have absolutely no problem teaching 5 sessions.Typically (at least the times I've submitted), there's a limit of 4 submitted abstracts and it's fairly uncommon to have more than 2 sessions accepted.
This year there was a hard cap of 2 on the number of accepted sessions by a single speaker. The main reason is to give an opportunity for new speakers. Otherwise the top speakers would each get 4 or 5 sessions, if they wanted, and there would be few, if any, new speakers. For example, there were 27 available community session slots in the DBA track and 150 sessions submitted. If the number of sessions per speaker had not been capped then instead of having 20+ speakers we probably would have had 10-15 speakers.
Heh... we need more room.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 16, 2010 at 7:02 am
Does anyone know what's up with the upcoming SQL Saturday in Minnesota? I see no speakers and no sessions. I've sent emails asking what's up and have gotten no responses either from the folks at Minnesota or the SQL Saturday main mail.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 16, 2010 at 7:05 am
Grant Fritchey (8/16/2010)
GilaMonster (8/16/2010)
Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to Hierarchies. I'd have absolutely no problem teaching 5 sessions.Typically (at least the times I've submitted), there's a limit of 4 submitted abstracts and it's fairly uncommon to have more than 2 sessions accepted.
They have a hard limit on 2 sessions. Although, I think they flex those rules for the A-Listers.
I don't think there was any flex this year. I think Paul and Kimberly got pre/post cons and then a spotlight session each and that's it.
PASS was really strict this year. If you had a pre/post con that counted as one of the sessions, which I don't necessarily agree with because most of the attendees don't do pre/post con's so may miss out on getting something from Paul, Kimberly, Kalen, Adam, et al...
I think pre/post con's should be separate and then give 2 sessions at the main Summit.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 16, 2010 at 7:07 am
Jeff Moden (8/16/2010)
Jack Corbett (8/16/2010)
GilaMonster (8/16/2010)
Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors), and Into to Hierarchies. I'd have absolutely no problem teaching 5 sessions.Typically (at least the times I've submitted), there's a limit of 4 submitted abstracts and it's fairly uncommon to have more than 2 sessions accepted.
This year there was a hard cap of 2 on the number of accepted sessions by a single speaker. The main reason is to give an opportunity for new speakers. Otherwise the top speakers would each get 4 or 5 sessions, if they wanted, and there would be few, if any, new speakers. For example, there were 27 available community session slots in the DBA track and 150 sessions submitted. If the number of sessions per speaker had not been capped then instead of having 20+ speakers we probably would have had 10-15 speakers.
Heh... we need more room.
Let's just say I'm waiting to hear about the slate for the PASS Election before commenting...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 16, 2010 at 7:08 am
Not sure Jeff. Sent out a tweet to see if anyone knows who to contact for that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 16, 2010 at 7:15 am
Jeff Moden (8/16/2010)
Does anyone know what's up with the upcoming SQL Saturday in Minnesota? I see no speakers and no sessions. I've sent emails asking what's up and have gotten no responses either from the folks at Minnesota or the SQL Saturday main mail.
According to the Twitter denizens, you could try Dan English (@denglishbi, http://denglishbi.spaces.live.com ). He's the PASSMN President.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 16, 2010 at 7:30 am
Whats everyone's thoughts on the SSWUG newsletter ?
In todays there is a summary of one of my blog posts. It doesn't specify that it is a free web resource and implies that you have to subscribe to get the content.
http://www.sswug.org/nlarchive.aspx?odate=08%2F16%2F2010
OK , so , hopefully , my article is not being plagiarized by SSWUG, i dont subscribe so dont know where the click will go to, but should web articles be used like this as ?
Viewing 15 posts - 17,476 through 17,490 (of 66,688 total)
You must be logged in to reply to this topic. Login to reply