<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 SA
»
File Groups
17 posts, Page 2 of 2
««
1
2
File Groups
Rate Topic
Display Mode
Topic Options
Author
Message
Toby White
Toby White
Posted Tuesday, October 20, 2009 2:44 PM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, November 09, 2012 2:48 PM
Points: 493,
Visits: 636
I knew the data would be with the clustered index, but I wasn't sure whether the inner reference or outer reference would win, or whether an error would be thrown. I spent 10 minutes setting up a test environment to make sure. I would have been guessing among my three options otherwise.
Post #806098
BudaCli
BudaCli
Posted Wednesday, October 21, 2009 5:43 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 1,046,
Visits: 575
GabyYYZ (10/19/2009)
SanjayAttray (10/19/2009)
Very good question. I was asked this question in an interview.
Q). What's the easiest and fastest way to move data of a table from file1 to file2?
A). Move the clustered index from file1 to file2.
Why would that be faster than say, creating a target table on file2 and inserting all into it from the source table?
I suppose part of the question was easiest and fastest...
Otherwise nice questions after all.
What you don't know won't hurt you but what you know will make you plan to know better
Post #806397
Pam Brisjar
Pam Brisjar
Posted Monday, October 26, 2009 3:49 PM
SSC Eights!
Group: General Forum Members
Last Login: Thursday, April 18, 2013 5:52 AM
Points: 908,
Visits: 2,797
I knew this one because I've been "bit" by it before. Would indeed be better if there was a warning.
And for the why not create another table and move the data into that, there's DDL issues and possibly space issues, too. It's also many more steps.
Post #809014
L' Eomot Inversé
L' Eomot Inversé
Posted Thursday, November 05, 2009 6:18 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 4:53 PM
Points: 7,182,
Visits: 7,281
Ouch -you got me - I didn't notice "clustered".
And I've complained about people not reading questions carefully
!
Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
http://es.linkedin.com/in/tomthomsonsoftware
Post #814182
rchantler
rchantler
Posted Friday, November 13, 2009 8:57 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 12:32 PM
Points: 104,
Visits: 303
Got this one wrong. I figured since there was a contradiction in the statement, SQL should complain. Why does it choose FG1 over FG2? Seems arbitrary to me.
Post #818593
David Todd-242471
David Todd-242471
Posted Thursday, December 10, 2009 7:21 PM
Say Hey Kid
Group: General Forum Members
Last Login: Monday, December 26, 2011 4:13 PM
Points: 689,
Visits: 410
Hi,
I accept that others have tested and found that everything is created on FG1.
>> from SQL 2008 BOL
If CLUSTERED is specified or the constraint otherwise creates a clustered index, and a <partition_scheme> is specified that differs from the <partition_scheme> or filegroup of the table definition, or vice-versa, only the constraint definition will be honored, and the other will be ignored.
<<
I read that and figured that both would be created on FG2, that is, the filegroup specification on the clustered indexed is ignored.
But looking at it again, it could be read either way ...
Cheers
David
Post #832674
bhushanvinay
bhushanvinay
Posted Saturday, February 27, 2010 3:57 AM
Old Hand
Group: General Forum Members
Last Login: Wednesday, July 11, 2012 6:35 AM
Points: 329,
Visits: 194
Any DBCC PAGE output on this.
Regards
Vinay
Post #873946
« Prev Topic
|
Next Topic »
17 posts, Page 2 of 2
««
1
2
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.
