SET Options

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » SET Options - 1

33 posts, Page 2 of 4

««1 2 3 4 »»»

SET Options - 1

Rate Topic

Display Mode

Topic Options

Author

Message

pchirags

Posted Friday, December 14, 2012 7:19 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:21 AM
Points: 1,215, Visits: 232

Great Question...
many thanks

Post #1396642

SanDroid

Posted Friday, December 14, 2012 7:24 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046

Good question Ron.
Clear answer and the SQL statements did not distract from the truth you where creating.
Cool

Post #1396651

Dana Medley

Posted Friday, December 14, 2012 8:26 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:37 PM
Points: 1,350, Visits: 871

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

Oh no, we're toast! I've got this. *Keyboard clatter* Woah, how'd you do that? I'm a DBA...Booyah

Yeah, uh huh, you know what it is. Everything I do, I do it big

Post #1396691

jcrawf02

Posted Friday, December 14, 2012 8:33 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:09 PM
Points: 2,550, Visits: 18,882

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

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

"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."

Post #1396695

Hugo Kornelis

Posted Friday, December 14, 2012 8:41 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:24 AM
Points: 5,235, Visits: 7,040

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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #1396701

Rich Weissler

Posted Friday, December 14, 2012 8:50 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:47 AM
Points: 1,565, Visits: 769

Thank you Hugo.

(At least it wasn't something obvious I just wasn't seeing.)

Post #1396708

Lon-860191

Posted Friday, December 14, 2012 9:13 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 06, 2013 8:39 AM
Points: 1,054, Visits: 218

Good question, learned something today. Didn't think a numeric related setting would effect an action relating to textual information, oh well.
Thanks,
Lon

Post #1396719