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

VIEW - 9 Expand / Collapse
Author
Message
Posted Monday, October 15, 2012 3:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 2,146, Visits: 1,738
Would there also be a difference between dbo.c_view and dbo.C_view if you had case sensitive collation set?
Post #1372633
Posted Monday, October 15, 2012 3:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:36 PM
Points: 6,002, Visits: 8,267
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1372635
Posted Monday, October 15, 2012 4:12 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: Today @ 11:15 AM
Points: 3,964, Visits: 5,204
Good question, thanks Ron

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1372638
Posted Monday, October 15, 2012 5:17 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
Great Monday morning question. Thanks.
Post #1372656
Posted Monday, October 15, 2012 6:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 9:00 AM
Points: 189, Visits: 127
A very good question.
Post #1372683
Posted Monday, October 15, 2012 6:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 9:00 AM
Points: 189, Visits: 127
Nice question. thanks!!
Post #1372686
Posted Monday, October 15, 2012 8:54 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: Friday, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
My only thought was.... where is the index for the statistics?

I kept trying to figure out a way that would have allowed for the statistics, but couldn't come up with one.

Yay +1 for me.




--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 #1372768
Posted Monday, October 15, 2012 10:13 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 4, 2014 8:10 AM
Points: 1,635, Visits: 1,972
L' Eomot Inversé (10/14/2012)
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.


Exactly why I got it wrong. I didn't spend the time to read through the question carefully.
Post #1372803
Posted Monday, October 15, 2012 1:58 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, November 11, 2013 2:35 PM
Points: 673, Visits: 123
This questions shows once more the variety of things you can do with MSSQL.

Great!
Post #1372923
Posted Tuesday, October 16, 2012 6:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:44 AM
Points: 11,194, Visits: 11,168
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.

I would have preferred a question worded that way too. It checks the same knowledge and offers the same learning opportunity.

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.

Same here - except I didn't spot the trap. People who know me may not be surprised to hear that I know manual and auto-statistics can be created on views (and why they are only used when the NOEXPAND hint is used), but still got this question 'wrong'. The same thing happened with the previous instalment in this series - I knew the correct SET options, but missed spotting the WITH SCHEMABINDING omission.

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.

Perhaps - it is hard to know. My personal preference would be to make the questions completely free of 'trickery'.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1373183
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse