SETTINGS - 1

Question

Post reply

SETTINGS - 1

Viewing 13 posts - 16 through 27 (of 27 total)

You must be logged in to reply to this topic. Login to reply

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 1

PHYData DBA

SSCertifiable

Points: 7541

March 4, 2013 at 7:21 am

#1592998

Nice Basic Question on a very unbasic topic. 😎

mtassin SSC-Insane Points: 23099 More actions · Answer 2

Nice question... the comments about it from Hugo and Tom are worth even more.

Thanks guys!

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

jagpatel9 Right there with Babe Points: 756 More actions · Answer 3

Thank you for the question.

Special thanks to Tom and Hugo for the explanation.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

thx for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Nice and easy one to start the week with - unusually easy for Ron.

Thanks, Ron!

TomThomson SSC Guru Points: 104773 More actions · Answer 6

james.parker 62839 (3/4/2013)
Tom and/or Hugo -
I understand and may even agree your dismay in the BOL description given with this answer.
I do not see any recomendations for correcting it or a better wording.
Not even a commment on the Community Additions. 😀
If it has been such a mess for you for that long, post a correction with the BOL.
People read and act on the comments made in the BOL Community Additions by others. 😛

I guess you didn't realise that

a decade or more after it was pointed out to them

meant that I (and others) did make some recommendations on this to MS a long time ago, with no effect at all, and I (and perhaps the others too) can't be bothered to try again.

Tom

EL Jerry SSCertifiable Points: 7061 More actions · Answer 7

Easy question to start the week. Thank you, Ron, and thanks to Tom and Hugo for the explanation.

Saludos,

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 8

james.parker 62839 (3/4/2013)
If it has been such a mess for you for that long, post a correction with the BOL.
People read and act on the comments made in the BOL Community Additions by others. 😛

I only noticed it today, and I decided to whip up a quick explanation here. I didn't (and still don't) have the time to also submit community content or other forms of feedback to Books Online.

But feel free to do so if you want. You can use (or refer to) my post. All scenarios I described were tested on SQL Server 2012.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/