SET Options - 1

Question

Post reply

SET Options - 1

Ron McCullough

SSC Guru

Points: 63877
More actions
December 13, 2012 at 8:37 pm

#267429

Comments posted to this topic are about the item SET Options - 1
If everything seems to be going well, you have obviously overlooked something.
Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]
December 14, 2012 at 12:30 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 32 total)

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

Another Great question Ron!

I was not aware of this limitation and got the question wrong 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 2

Great question to end the week. Had to do some research, but it was worth it.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Stuart Davies SSCoach Points: 19505 More actions · Answer 3

Good question Ron.

Thanks

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Gazareth One Orange Chip Points: 27737 More actions · Answer 4

Gazareth

One Orange Chip

Points: 27737

December 14, 2012 at 3:12 am

#1568608

Nice question, thanks.

ronmoses@gmail.com SSCarpal Tunnel Points: 4480 More actions · Answer 5

Really nice question. I even did the research on each option, but somehow missed the line about indexed views. Looks like I need to brush up on my options!

(And I will smack the first guy who says "Thanks for the easy question to end the week!") 😉

ron

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 6

(Bob Brown)

SSCrazy

Points: 2705

December 14, 2012 at 6:28 am

#1568665

Great question to end the week! Thanks.

Toreador SSChampion Points: 11358 More actions · Answer 7

Toreador

SSChampion

Points: 11358

December 14, 2012 at 6:39 am

#1568671

Thanks for the easy question to end the week!

😉

Rich Weissler Hall of Fame Points: 3286 More actions · Answer 8

Great question.

But, okay... I give up, how does having an indexed view cause a loss of precision?

(I.e. Yep, I see the error. I don't understand WHY. 🙁 )

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 9

PChiragS

SSCarpal Tunnel

Points: 4965

December 14, 2012 at 7:19 am

#1568690

Great Question...

many thanks

SanDroid SSChampion Points: 10068 More actions · Answer 10

Good question Ron.

Clear answer and the SQL statements did not distract from the truth you where creating.

😎

Dana Medley SSCertifiable Points: 6764 More actions · Answer 11

Thanks for the great question Ron. I was unaware of this limitation and have definitely learned something today. 🙂

Everything is awesome!

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 12

I've been looking for Steve Moden's phone number, thanks....

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

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

Rich Weissler (12/14/2012)
Great question.
But, okay... I give up, how does having an indexed view cause a loss of precision?
(I.e. Yep, I see the error. I don't understand WHY. 🙁 )

It doesn't. But there are specific settings required for making and maintaining indexed views, and this happens to be one of them.

If you change the setting before trying to create the view, that in itself would already fail. (Or, to be more precise, creating the view would succeed, but creating the index to convert it from a normal into an indexed view would fail).

The reason for this limitation? (Puts on speculative hat) Many settings are discouraged anyway, and I guess that MS decided not to put in extra engineering effort to support and test indexed views (and several other features with similar limitations) under all those settings. So they simply forbid them.

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/