VIEW - 9

Question

VIEW - 9

Ron McCullough

SSC Guru

Points: 63877
More actions
October 14, 2012 at 7:07 am

#263878

Comments posted to this topic are about the item VIEW - 9
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]
October 15, 2012 at 4:12 am

This was removed by the editor as SPAM

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Nice Question Ron.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

TomThomson SSC Guru Points: 104773 More actions · Answer 2

Fun question.

I wonder how many people will fail to notice that although you've got everything ready to create the index you haven't actually done so, so the view is not indexed and can't have statistics.

Tom

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

Ah..Good question to begin with our Monday morning 🙂

~ 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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 4

L' Eomot Inversé (10/14/2012)
Fun question.
I wonder how many people will fail to notice that although you've got everything ready to create the index you haven't actually done so, so the view is not indexed and can't have statistics.

Correct answers: 79% (33)

Incorrect answers: 21% (9)

9/42 already failed to noticed this..

~ 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

demonfox SSCertifiable Points: 6289 More actions · Answer 5

nice question ..

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

DugyC Hall of Fame Points: 3804 More actions · Answer 6

I'm not very offay with Views, not used them much at all.

However after the last question like this I knew it needed that clustered index so got the answer right this time round.

Great questions, cheers.

_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

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

At first sight, I thought this was a question to check whether indexed views can have their own statistics. I did not know that, so I set out to research that, and I thought this was a great question.

Than, I (luckily) doublechecked the question - and found that it is actually a question that tests my ability to read carefully, and to not fall victim to suggested information.

The way the question is worded (with the starting words: "I set the options to support indexed views" (emmphasis mine) suggests that the view is indexed. It is very easy to overlook the fact that no index is created, hence it is a normal, unindexed view.

Ron has already submitted a lot of questions, and I have never seen him intentionally try to trick people, so I am sure that it was not his intention to make this a trick question either.

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/

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

Hugo Kornelis (10/15/2012)
At first sight, I thought this was a question to check whether indexed views can have their own statistics. I did not know that, so I set out to research that, and I thought this was a great question.
Than, I (luckily) doublechecked the question - and found that it is actually a question that tests my ability to read carefully, and to not fall victim to suggested information.
The way the question is worded (with the starting words: "I set the options to support indexed views" (emmphasis mine) suggests that the view is indexed. It is very easy to overlook the fact that no index is created, hence it is a normal, unindexed view.
Ron has already submitted a lot of questions, and I have never seen him intentionally try to trick people, so I am sure that it was not his intention to make this a trick question either.

+1

I did not read carefully 😀

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

call.copse SSCoach Points: 17958 More actions · Answer 9

I thought this one was pretty clear and unambiguous, no trickery just the knowledge / research required to amswer it.

Richard Warr SSCertifiable Points: 6963 More actions · Answer 10

Would there also be a difference between dbo.c_view and dbo.C_view if you had case sensitive collation set?

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

Richard Warr (10/15/2012)
Would there also be a difference between dbo.c_view and dbo.C_view if you had case sensitive collation set?

Yes, if your database uses case sensitive collation, "c_view" is different from "C_view". (And "dbo" is also different frmo "Dbo").

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/

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

(Bob Brown)

SSCrazy

Points: 2705

October 15, 2012 at 5:17 am

#1549072

Great Monday morning question. Thanks.

Erav SSC-Addicted Points: 411 More actions · Answer 13

Erav

SSC-Addicted

Points: 411

October 15, 2012 at 6:22 am

#1549089

A very good question.:-)