August 25, 2015 at 9:02 pm
Comments posted to this topic are about the item PINTABLE
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
August 25, 2015 at 9:09 pm
Nice simple question. No wrong answers yet. (Not many right ones, either).
Surprised it's still there; it's been a NOOP in 2005, 2008, 2008R2, 2012 so I expected it to be gone from 2014. But I guess it does no harm, since it's now a NOOP, and taking out might have broken some legacy code from SQL 2000 or earlier.
Tom
August 25, 2015 at 10:20 pm
TomThomson (8/25/2015)
Nice simple question. No wrong answers yet. (Not many right ones, either).
That changed fairly quickly.
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
August 25, 2015 at 11:38 pm
This was removed by the editor as SPAM
August 25, 2015 at 11:40 pm
This was removed by the editor as SPAM
August 25, 2015 at 11:56 pm
I guess the question has a little mistake in the correct answer options.
When we use EXECUTE function, we have "Command(s) executed successfully" in stead of the default DBCC execution message. I saw this at least...
August 26, 2015 at 1:29 am
That's a quite easy question, it is well-know from SQL Server 2000.
Thanks
August 26, 2015 at 8:38 am
Great question.
I have always laughed when I saw this because it is all caps it is not exactly clear when reading where the word breaks are. I have always read this incorrectly first as PintAble (as in a good beer that is worthy of being in a pint glass). 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 26, 2015 at 8:53 am
ygozudeli (8/25/2015)
I guess the question has a little mistake in the correct answer options.When we use EXECUTE function, we have "Command(s) executed successfully" in stead of the default DBCC execution message. I saw this at least...
If executed exactly as-is in the qotd, it will produce the DBCC text that was an answer option.
If the query was executed in a session in SSMS where you have changed the execution behavior of SSMS to set "NOEXEC" on (or enabled it for the session), then the output would have been what you saw. Even with that, it is not a mistake in the question. The execution message is suppressed due to a setting that has been enabled for your management studio. And since the execution of the statement provided was not actually executed due to the noexec - well none of the answers would be correct because the statement was never actually executed.
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
August 26, 2015 at 8:53 am
Sean Lange (8/26/2015)
Great question.I have always laughed when I saw this because it is all caps it is not exactly clear when reading where the word breaks are. I have always read this incorrectly first as PintAble (as in a good beer that is worthy of being in a pint glass). 😀
Now that is funny - you win the internetz today.
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
August 26, 2015 at 9:28 am
Sean Lange (8/26/2015)
Great question.I have always laughed when I saw this because it is all caps it is not exactly clear when reading where the word breaks are. I have always read this incorrectly first as PintAble (as in a good beer that is worthy of being in a pint glass). 😀
I imagine that's a very rarely used word in the USA. even more rarely than it was in Britain in the 1960s and early 70s (the awfulness during those times of most British beer and the tendency of the British big brewers to drop real beer and manufacture fizzy keg stuff instead led to the founding of CAMRA in 1971).
But as for the DBCC command name, you had as much chance of getting a performance improvment out of using it as you had of gaining a profit out of playing pinball on a pin table, and also the same chance reducing performance as of losing money on a pin table. Of course pin table gambling machines went out of fashion (last time I saw one was about 1955) because it was rather obvious that the coin throughput was much higher with a vertical board with no flippers instead of a nearly horizontal one with flippers. So some of us more ancient types thought pin table was rather a good name for the function.
Tom
August 26, 2015 at 10:13 am
TomThomson (8/26/2015)
Sean Lange (8/26/2015)
Great question.I have always laughed when I saw this because it is all caps it is not exactly clear when reading where the word breaks are. I have always read this incorrectly first as PintAble (as in a good beer that is worthy of being in a pint glass). 😀
I imagine that's a very rarely used word in the USA. even more rarely than it was in Britain in the 1960s and early 70s (the awfulness during those times of most British beer and the tendency of the British big brewers to drop real beer and manufacture fizzy keg stuff instead led to the founding of CAMRA in 1971).
But as for the DBCC command name, you had as much chance of getting a performance improvment out of using it as you had of gaining a profit out of playing pinball on a pin table, and also the same chance reducing performance as of losing money on a pin table. Of course pin table gambling machines went out of fashion (last time I saw one was about 1955) because it was rather obvious that the coin throughput was much higher with a vertical board with no flippers instead of a nearly horizontal one with flippers. So some of us more ancient types thought pin table was rather a good name for the function.
On the contrary, pint is used very commonly in the US. Now when referring to the swill often mistakenly called beer by a large number of people in the US it is a different story entirely. But those are the people who must drink their beverage as close to freezing as possible to avoid actually tasting it. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 27, 2015 at 12:42 am
SQLRNNR (8/26/2015)
ygozudeli (8/25/2015)
I guess the question has a little mistake in the correct answer options.When we use EXECUTE function, we have "Command(s) executed successfully" in stead of the default DBCC execution message. I saw this at least...
If executed exactly as-is in the qotd, it will produce the DBCC text that was an answer option.
If the query was executed in a session in SSMS where you have changed the execution behavior of SSMS to set "NOEXEC" on (or enabled it for the session), then the output would have been what you saw. Even with that, it is not a mistake in the question. The execution message is suppressed due to a setting that has been enabled for your management studio. And since the execution of the statement provided was not actually executed due to the noexec - well none of the answers would be correct because the statement was never actually executed.
I am curious where this "NOEXEC" option?!
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
August 27, 2015 at 12:52 am
SQLRNNR (8/25/2015)
TomThomson (8/25/2015)
Nice simple question. No wrong answers yet. (Not many right ones, either).That changed fairly quickly.
And now its tottaly the opposite as the correct answers are very less comparing to the wrong.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
August 27, 2015 at 1:21 am
Something from before my time 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply