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»»»

View - 8 Expand / Collapse
Author
Message
Posted Saturday, October 6, 2012 2:21 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,563, Visits: 24,689
Comments posted to this topic are about the item View - 8

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1369461
Posted Saturday, October 6, 2012 2:28 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 8:54 PM
Points: 606, Visits: 151
Good and Easy Question +1.

Thanks
Post #1369462
Posted Saturday, October 6, 2012 6:17 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:53 PM
Points: 8,543, Visits: 9,030
It's a question with a correct answer, no scope for argument for that (as I have come to expect from Ron's questions, which seem to be always accurate - unlike mine, or indeed pretty well anyone elses), so in that respect it's a good question.

But all those settings up front are just a red herring - completely irrelevant to the question. It's not a trick question, because it's extremely unlikely that anyone thinks that those settings could have any effect on the answer. Nevertheless, I think that that stuff detracts from the quality of the question; it might leave someone wondering if there were some setting (not one of those listed) that could have affected the answer, which would be unfortunate.

But never mind, maybe I should like it anyway, because there's nothing actually wrong with it and I got it right.

BTW, it's another Monday question released rather early, of course. Is "dbcc timewarp" somehow involved? Should I be able to answer Monday's question in the small hours of the preceeding Sunday?


Tom
Post #1369485
Posted Sunday, October 7, 2012 8:51 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,563, Visits: 24,689
L' Eomot Inversé
It's a question with a correct answer, no scope for argument for that (as I have come to expect from Ron's questions, which seem to be always accurate - unlike mine, or indeed pretty well anyone elses), so in that respect it's a good question.


And I thank you for the compliment ... so often the comments are far, far away from being complimentary. Let us see how it developes as more answer and comment.


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1369604
Posted Sunday, October 7, 2012 10:11 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, May 31, 2014 9:19 PM
Points: 1,128, Visits: 1,162
good question..
nice and easy ..

Thanks


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1369610
Posted Sunday, October 7, 2012 10:43 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
L' Eomot Inversé (10/6/2012)
It's a question with a correct answer, no scope for argument for that (as I have come to expect from Ron's questions, which seem to be always accurate - unlike mine, or indeed pretty well anyone elses), so in that respect it's a good question.


I must agree in accord. Many a times when I post a question, either there is some anomaly in the question or there is something wrong with the way I explain the answer of that question.
Ron's questions are often to the point and accurate. Keep it up. It's a learning for people like me


~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1369613
Posted Sunday, October 7, 2012 10:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
L' Eomot Inversé (10/6/2012)

But all those settings up front are just a red herring - completely irrelevant to the question. It's not a trick question, because it's extremely unlikely that anyone thinks that those settings could have any effect on the answer. Nevertheless, I think that that stuff detracts from the quality of the question; it might leave someone wondering if there were some setting (not one of those listed) that could have affected the answer, which would be unfortunate.


Those couple of SET options seems to be red-herring, but they are pretty much in-line with BOL text. Here is the excerpt taken from BOL (link mentioned by Ron)

The following steps are required to create an indexed view and are critical to the successful implementation of the indexed view:
1. Verify the SET options are correct for all existing tables that will be referenced in the view.
2. Verify the SET options for the session are set correctly before creating any new tables and the view.


~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1369615
Posted Monday, October 8, 2012 12:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:21 AM
Points: 5,916, Visits: 8,164
I really liked the question. Unlike Tom, I even liked the inclusion of all the settings, and I don't think it's a red herring. This question is about knowing all the requirements for indexing a view, and the only way to test that is to use questions that either get all the requirements right, or all except one.

And if this results in people reading Books Online to check all the required SET options, then I would argue that this is a good thing. (Not that I think that anyone should know these requirements by head - but people should know the requirements exist, and know where to find them documented).



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1369631
Posted Monday, October 8, 2012 1:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 11, 2014 1:37 AM
Points: 2,546, Visits: 1,613
Very good + clear question. thanks... nice way to start the week.
Post #1369647
Posted Monday, October 8, 2012 2:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
Great question Ron, thanks!

Another thing that might lead to the create index statement to fail:
it's not sure the base table has been created with ANSI_NULLS set to ON.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1369667
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse