<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Dave62
»
Color coding
44 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
Color coding
Rate Topic
Display Mode
Topic Options
Author
Message
dave.farmer
dave.farmer
Posted Friday, October 15, 2010 2:51 AM
SSC Eights!
Group: General Forum Members
Last Login: Friday, May 03, 2013 3:39 AM
Points: 857,
Visits: 584
Another dumb trick question
I use connection colouring, and it always works, so I was tricked into thinking the question was about that, hence answered 'True'.
I don't mind getting an answer wrong if I learn something, but misdirection and trickery is damned annoying.
Pah!
Paris
in the
the spring
by another name.
Post #1004974
Hugo Kornelis
Hugo Kornelis
Posted Friday, October 15, 2010 3:07 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:22 AM
Points: 5,244,
Visits: 7,059
Carlo Romagnano (10/15/2010)
I answered TRUE, but reading and re-reading both question and answer, I do not understand why it's false. Please Hugo, help us to understand.
I seem to have built a reputation for myself...
I had this one wrong as well. Partially because I don't work with SQL Server 2008 yet (I do have it installed on a laptop, fopr "play" purposes), and partly because I misread the question.
The answer is hidden in the explanation. You
can
configure different colors for the "query window" (which I knew - that's why I selected "true"), but you
cannot
configure the colors for "the status bar in SSMS".
This last status bar obviously refers to another status bar than that of the query window. I don't know which status bar, though, and I can't check if it's true. But even if it is, the correct answer should have been "it depends" - since the query window sits within SSMS, you can obviously configure colors for
some
status bars in SSMS.
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #1004981
Carlo Romagnano
Carlo Romagnano
Posted Friday, October 15, 2010 3:19 AM
SSCommitted
Group: General Forum Members
Last Login: Today @ 12:56 AM
Points: 1,972,
Visits: 1,822
Thanks Hugo.
I work with SSMS sql2500, too.
Post #1004990
Toreador
Toreador
Posted Friday, October 15, 2010 3:36 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356,
Visits: 4,761
Pedantic trickery at its worst!
"the status bar in SQL Server 2008 Management Studio" does not clearly state that it means the one in the main window rather than the one in the query window. It could mean anything.
So the closest answer is probably "it depends", as it depends how you interpret the question.
Post #1004993
honza.mf
honza.mf
Posted Friday, October 15, 2010 3:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 1,103,
Visits: 1,200
Thanks, Hugo. You have built great reputation here.
And the others: Don't complain. The question and answers are OK. Yes, it's tricky. Do you like to obtain point without thinking?
See, understand, learn, try, use efficient
© Dr.Plch
Post #1005002
Toreador
Toreador
Posted Friday, October 15, 2010 4:01 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356,
Visits: 4,761
honza.mf (10/15/2010)
Do you like to obtain point without thinking?
Not at all.
But the answer as given doesn't depends on SQL, but on how you interpret the phrase "the status bar". I think it means "any status bar"; the author thinks it means "the status bar of the main window"; it could equally mean "the status bar of the query window", since it is only the query window that is connected to a server and hence the only one to which the question is relevant.
It's not a SQLServer question, it's an ambiguous English Comprehension question.
Post #1005005
honza.mf
honza.mf
Posted Friday, October 15, 2010 4:28 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 1,103,
Visits: 1,200
Toreador (10/15/2010)
honza.mf (10/15/2010)
Do you like to obtain point without thinking?
Not at all.
But the answer as given doesn't depends on SQL, but on how you interpret the phrase "the status bar". I think it means "any status bar"; the author thinks it means "the status bar of the main window"; it could equally mean "the status bar of the query window", since it is only the query window that is connected to a server and hence the only one to which the question is relevant.
It's not a SQLServer question, it's an ambiguous English Comprehension question.
Yes, you are right. But is that one point worth for this discussion? For me it's a fly buzzing in my ears. Especially because it's not a SQL question, it's a question about a Microsoft tool.
See, understand, learn, try, use efficient
© Dr.Plch
Post #1005029
Koen Verbeeck
Koen Verbeeck
Posted Friday, October 15, 2010 5:56 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
The question itself is good, it poins to a not so well known feature in SSMS.
But the answers, boy, does that suck. Pure trickery...
It is like: "Hahaha, you knew you could color the status bar of a query window, but I didn't specify which status bar, so it is wrong. Nananananana." A bit childish...
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 #1005077
William Vach
William Vach
Posted Friday, October 15, 2010 6:14 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 9:09 AM
Points: 2,114,
Visits: 1,073
Assuming that this was not a trick question, I believe that the correct answer is 'it depends'. You can set the status bar for the query window to display a color based on the instance that you are connected to, but in order for this to work, you must connect through the registered servers tree. If you connect through the File|Connect Objects explorer method, the color of the status bar will be the default. Also, if you connect through the registered servers tree and change your connection to another instance, the status bar for the query window will retain the color of the instance originally connected to.
Post #1005088
Daniel Bowlin
Daniel Bowlin
Posted Friday, October 15, 2010 7:05 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 1:10 PM
Points: 2,673,
Visits: 2,418
I think the question is kind of a tricky one, but many QoTD are tricky. I missed the point, but I did learn something...that you can color code the server connections/query window (status bar). I am regularly connected to 2 to 5 servers, and this is a useful tidbit of info. Thanks.
Post #1005129
« Prev Topic
|
Next Topic »
44 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
