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, July 7, 2014 9:38 AM
Points: 1,780, Visits: 582
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 @ 7:35 AM
Points: 1,826, Visits: 1,359
Thanks for the great question Ron. I was unaware of this limitation and have definitely learned something today.



Everything is awesome!
Post #1396691
Posted Friday, December 14, 2012 8:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:00 AM
Points: 2,656, Visits: 19,185
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 @ 4:02 PM
Points: 5,916, Visits: 8,167
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: Thursday, June 19, 2014 12:20 PM
Points: 1,792, Visits: 895
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, June 26, 2014 7:55 AM
Points: 1,385, Visits: 249
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 @ 7:44 PM
Points: 21,209, Visits: 14,899
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: Friday, July 18, 2014 10:48 AM
Points: 1,935, Visits: 10,956
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: Monday, July 21, 2014 8:35 AM
Points: 3,642, Visits: 72,429
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