Viewing 15 posts - 226 through 240 (of 330 total)
Well, at the end of the day people can shove 'best practice' down your throat all day - but what matters at the end of the day is a working...
September 14, 2009 at 7:25 am
Paul White (9/14/2009)
P.S. Matt - OPTION MAXRECURSION (0) gives you 32767 levels IIRC
You are a goldmine sir.
From MSDN: 'When 0 is specified, no limit is applied' - if you specify...
September 14, 2009 at 7:09 am
Did you see the DDL trigger I posted?
You could add the guts of that instead of the 'refresh everything 7 times' with two distinct advantages:
1) Everything would be refreshed once.
2)...
September 14, 2009 at 6:39 am
Paul White (9/14/2009)
September 14, 2009 at 5:16 am
Rob Fisk (9/14/2009)
I changed your second query to use * rather than be identical to the first and the plans were still the same.
I think the difference would be in...
September 14, 2009 at 4:43 am
I would imagine select 1 would be marginally more efficient, because it doesn't then have to look at meta data in order to determine what * would actually be...
September 14, 2009 at 4:40 am
Alex (9/14/2009)
I assume you would have hired him had he also mentioned the performance benefit of this approach? :laugh:
Oh, certainly! It was a close call... 😀
September 14, 2009 at 4:18 am
Alex (9/14/2009)
It is not like comparing MS Access with SQL Server or calling Excel a relational database (as one might 'colloquially'). 🙂
Hahah - please don't make me spit out my...
September 14, 2009 at 3:48 am
Sorry guys! I didn't mean to be on bad form or anything - just I know that a lot of you guys are really experienced people whose opinion I've come...
September 14, 2009 at 3:41 am
Hello all - I've been informed this is the place to post up a request for some really experienced SQL Server users... 🙂
To cut a long story short - I'm...
September 13, 2009 at 8:09 pm
Paul White (9/13/2009)
If the documentation said that dependencies unsupported by schema binding would always continue...
September 13, 2009 at 7:16 pm
Alex (9/13/2009)
SCHEMABINDING is a hack to make SQL Server conform a bit more to the relational model.
I can't really agree on that one. SCHEMABINDING does a lot more with respect...
September 13, 2009 at 7:02 pm
Paul White (9/13/2009)
You likened it to zeroing an account balance if it happened to end in a three!!
Yep, but I could have equally likened it to a kettle which exploded...
September 13, 2009 at 6:57 pm
Paul White (9/13/2009)
No your analogy was false, and about banks.
Would you like it more if it was about exploding kettles? 🙂 Just because you don't like my analogy, doesn't make...
September 13, 2009 at 6:28 pm
Paul White (9/13/2009)
September 13, 2009 at 5:43 pm
Viewing 15 posts - 226 through 240 (of 330 total)