|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Today @ 8:39 AM
Points: 1,609,
Visits: 1,103
|
|
| Would there also be a difference between dbo.c_view and dbo.C_view if you had case sensitive collation set?
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 3:03 PM
Points: 5,244,
Visits: 7,061
|
|
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
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 3,129,
Visits: 4,312
|
|
Good question, thanks Ron
____________________________________________ Space, the final frontier? not any more... All limits henceforth are self-imposed. “libera tute vulgaris ex”
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Friday, April 19, 2013 10:27 AM
Points: 690,
Visits: 1,100
|
|
| Great Monday morning question. Thanks.
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 8:36 AM
Points: 165,
Visits: 110
|
|
A very good question.
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 8:36 AM
Points: 165,
Visits: 110
|
|
Nice question. thanks!!
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Today @ 10:48 PM
Points: 3,231,
Visits: 64,337
|
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:44 AM
Points: 1,559,
Visits: 1,925
|
|
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.
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:28 PM
Points: 515,
Visits: 119
|
|
This questions shows once more the variety of things you can do with MSSQL.
Great!
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 4:22 PM
Points: 10,990,
Visits: 10,542
|
|
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
|
|
|
|