Poecilonym Madness!

Question

Poecilonym Madness!

Andy Warren

SSC Guru

Points: 119902
More actions
June 19, 2014 at 9:58 pm

#290205

Comments posted to this topic are about the item Poecilonym Madness!
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
June 20, 2014 at 3:54 am

This was removed by the editor as SPAM

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

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

rhythmk SSCertifiable Points: 7271 More actions · Answer 1

Thanks for question Andy.

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

domenico.delbrocco SSChasing Mays Points: 617 More actions · Answer 2

Thanks for the question

I've missed something about synonym. I need to review the subject

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

Interesting question, thank you Andy.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Erwin Oosterhoorn SSCrazy Points: 2316 More actions · Answer 4

There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.

Would I have been correct to say that the synonym would not have been created, the table failed to drop and the view was not created?

Sean Pearce SSCoach Points: 15999 More actions · Answer 5

erwin.oosterhoorn (6/20/2014)
There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.
Would I have been correct to say that the synonym would not have been created, the table failed to drop and the view was not created?

If not otherwise indicated in the question we should assume the server is running with default settings.

Good question.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 6

Thank you for the post, Andy, good one.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

erwin.oosterhoorn (6/20/2014)
There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.
Would I have been correct to say that the synonym would not have been created, the table failed to drop and the view was not created?

Well... the exchange of thoughts on collation is been going on from very long back, but at the end we all kind of nodded that if the mention of collation is not there then go for default "Latin1_General_CI_AI" (this is just an example and not for debate) - Or in other words drop the collation from the criteria. Sorry for your loss (i mean for points..) Now you know. 🙂

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Toreador SSChampion Points: 11365 More actions · Answer 8

Given the discussions about collation over the years, I assumed that this was a "trick" question on that subject. In which case the correct answer would have been

Table Test is created

Table Test2 is created

The synonym is created

The drop table statement fails

The create view statement fails

The final select fails

It was unfortunate that the options were set in such a way that this configuration also gave 6 answers!

Ed Wagner SSC Guru Points: 287026 More actions · Answer 9

This is a nice, straightforward question. A good way to end the week. Thanks, Andy.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Gazareth One Orange Chip Points: 27737 More actions · Answer 10

Sean Pearce (6/20/2014)
erwin.oosterhoorn (6/20/2014)
There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.
Would I have been correct to say that the synonym would not have been created, the table failed to drop and the view was not created?
If not otherwise indicated in the question we should assume the server is running with default settings.
Good question.

This is a question by Andy Warren. Assumptions are dangerous 🙂

Mighty SSCrazy Eights Points: 9063 More actions · Answer 11

Raghavendra Mudugal (6/20/2014)
Well... the exchange of thoughts on collation is been going on from very long back, but at the end we all kind of nodded that if the mention of collation is not there then go for default "Latin1_General_CI_AI" (this is just an example and not for debate) - Or in other words drop the collation from the criteria. Sorry for your loss (i mean for points..) Now you know. 🙂

Issue with this is that there is no "default collation". Depends on the language/local of the system on which SQL Server has been installed and on the version of SQL Server.

Andy Warren SSC Guru Points: 119902 More actions · Answer 12

I love "assumptions are dangerous"

Thanks to all for giving the question a try, always nice to see one go well:-)

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

david.gugg SSCertifiable Points: 6096 More actions · Answer 13

Tricky, I failed to realize the synonym would be pointing to the view instead of the table that had been dropped.

Great question!

Be still, and know that I am God - Psalm 46:10