<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 Stewart Campbell
»
To switch or not to switch
25 posts, Page 2 of 3
««
1
2
3
»»
To switch or not to switch
Rate Topic
Display Mode
Topic Options
Author
Message
OCTom
OCTom
Posted Thursday, November 11, 2010 6:55 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:55 PM
Points: 2,015,
Visits: 2,847
Trick or tricky question? The incorrect got me as it did others. I should have had my coffee first.
Post #1019307
Daniel Bowlin
Daniel Bowlin
Posted Thursday, November 11, 2010 7:08 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 1:10 PM
Points: 2,673,
Visits: 2,418
Good question, I definitely had to do some research.
Post #1019314
SanDroid
SanDroid
Posted Thursday, November 11, 2010 7:18 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232,
Visits: 1,046
Hugo Kornelis (11/11/2010)
2. The rule "Partitions can be on any column" is ambiguous. I was sure I had the rest right, but felt like taking a 50% gamble with this one - did the question author want this to be interpreted as "There are restrictions on the type of partitioning column you choose in both tables", or as "There are no restrictions no the type of partitioning column chosen, except that it has to be the same in both".
This also got me.
Once again I had to guess and use my ESP to answer the QOTD.
It was very difficult to understand that the author was asking if you could create a partion on column a in source table to column b in target table. Instead of meaning are there any limitations on the columns that can be used to create the partition.
I gift the questions No stars for trying to trick people with ambiguous answers and a weirdly positioned incorrect statement.
Questions like these on the MS certification exams are what inspire people to buy study exams.
Post #1019323
KWymore
KWymore
Posted Thursday, November 11, 2010 9:08 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 2,575,
Visits: 1,533
I felt that the "Partitions can be on any column" choice was ambiguous too and knew that I had a 50-50 chance of missing it based on that answer alone. I'm glad this one was only worth one point.
On the upside, I did learn about a new feature so that is good!
Post #1019392
Oleg Netchaev
Oleg Netchaev
Posted Thursday, November 11, 2010 9:09 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 10:53 AM
Points: 1,662,
Visits: 1,709
A little ambiguity around
Partitions can be on any column
part aside, this was a very good question, thank you Stewart. Interestingly, we had a question on ASK side asking about guidelines and considerations for deleting in excess of a billion records from existing table, and the
answer by Scot Hauder
suggested using
switch
, and included a thoroughly commented sample. I am not sure wherer OP opted to use Scot's solution or not, but the answer clearly demonstrated a practical application of the technique in real life scenario, saving someone from quite a lot of hustle.
Oleg
Post #1019394
Halcyon
Halcyon
Posted Thursday, November 11, 2010 10:04 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, July 19, 2012 8:47 AM
Points: 260,
Visits: 366
read the specification, read the specification:)
Post #1019433
Cliff Jones
Cliff Jones
Posted Thursday, November 11, 2010 12:03 PM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 3,397,
Visits: 3,405
So what would be an example of a column that could not be partitioned? My coin toss also went the wrong way.
Post #1019506
Cliff Jones
Cliff Jones
Posted Thursday, November 11, 2010 12:09 PM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 3,397,
Visits: 3,405
Oleg Netchaev (11/11/2010)
A little ambiguity around
Partitions can be on any column
part aside, this was a very good question, thank you Stewart. Interestingly, we had a question on ASK side asking about guidelines and considerations for deleting in excess of a billion records from existing table, and the
answer by Scot Hauder
suggested using
switch
, and included a thoroughly commented sample. I am not sure wherer OP opted to use Scot's solution or not, but the answer clearly demonstrated a practical application of the technique in real life scenario, saving someone from quite a lot of hustle.
Oleg
Thanks for the link. That is a very useful technique.
Post #1019513
UMG Developer
UMG Developer
Posted Thursday, November 11, 2010 5:32 PM
SSCrazy
Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163,
Visits: 2,148
Thanks for the question. I missed one of the three, so I should get 66% of a point. ;)
Post #1019659
steven.malone
steven.malone
Posted Friday, November 12, 2010 8:00 AM
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, April 18, 2013 6:58 AM
Points: 96,
Visits: 210
1. The negation in the question is a needless extra complication. It would have been better to ask which of the listed rules are correct. (Even after realizing that the question asked for incorrect, I still found myself ticking the correct ones - human psychology works like that).
Me too! I read the "incorrect" then had to take a call as I was about to answer. After the call I checked off the "correct" answers and hit the button.
Post #1019946
« Prev Topic
|
Next Topic »
25 posts, Page 2 of 3
««
1
2
3
»»
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.
