Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

SET Options - 1 Expand / Collapse
Author
Message
Posted Friday, December 14, 2012 7:19 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:59 AM
Points: 1,670, Visits: 550
Great Question...
many thanks
Post #1396642
Posted Friday, December 14, 2012 7:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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.

Post #1396651
Posted Friday, December 14, 2012 8:26 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 1,718, Visits: 1,248
Thanks for the great question Ron. I was unaware of this limitation and have definitely learned something today.



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

Post #1396691
Posted Friday, December 14, 2012 8:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:12 AM
Points: 2,627, Visits: 19,093
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
Posted Friday, December 14, 2012 8:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:24 AM
Points: 5,794, Visits: 8,009
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
Posted Friday, December 14, 2012 8:50 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 07, 2014 5:50 AM
Points: 1,792, Visits: 890
Thank you Hugo.

(At least it wasn't something obvious I just wasn't seeing.)
Post #1396708
Posted Friday, December 14, 2012 9:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 10, 2014 10:30 AM
Points: 1,310, Visits: 246
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
Posted Friday, December 14, 2012 9:14 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:16 PM
Points: 20,462, Visits: 14,091
Thanks Ron. Very informative today.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1396720
Posted Friday, December 14, 2012 9:23 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:08 PM
Points: 1,906, Visits: 10,941
Great question. Got a little education today. Thanks.


Rob Schripsema
Accelitec, Inc
Post #1396728
Posted Friday, December 14, 2012 9:55 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 12:05 PM
Points: 3,569, Visits: 72,411
Koen Verbeeck (12/14/2012)
Great question to end the week. Had to do some research, but it was worth it.


I agree... the research as to the various set options was worth the time.




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1396741
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse