SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by SA / File Groups / Latest Posts

RE: File Groups

bhushanvinay — Sat, 27 Feb 2010 03:57:36 GMT

Any DBCC PAGE output on this.

RE: File Groups

David Todd-242471 — Thu, 10 Dec 2009 19:21:26 GMT

Hi,I accept that others have tested and found that everything is created on FG1.>> from SQL 2008 BOLIf 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

RE: File Groups

rchantler — Fri, 13 Nov 2009 08:57:29 GMT

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.

RE: File Groups

L' Eomot Inversé — Thu, 05 Nov 2009 06:18:25 GMT

Ouch -you got me - I didn't notice "clustered".And I've complained about people not reading questions carefully:blush:!

RE: File Groups

Pam Brisjar — Mon, 26 Oct 2009 15:49:49 GMT

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.

RE: File Groups

BudaCli — Wed, 21 Oct 2009 05:43:25 GMT

[quote][b]GabyYYZ (10/19/2009)[/b][hr][quote][b]SanjayAttray (10/19/2009)[/b][hr]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.[/quote]Why would that be faster than say, creating a target table on file2 and inserting all into it from the source table?[/quote]I suppose part of the question was easiest and fastest...Otherwise nice questions after all.

RE: File Groups

Toby White — Tue, 20 Oct 2009 14:44:42 GMT

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.

RE: File Groups

john.arnott — Mon, 19 Oct 2009 17:25:39 GMT

[quote][b]Steve Jones - Editor (10/19/2009)[/b][hr]nice question, I missed the clustered part.The engine definitely should inform someone if this doesn't work.[/quote]Funny thing. I missed this because I [b]DID[/b] see the clustered part and figured that SQL would complain about it. Oh, well; learned something here for sure.

RE: File Groups

AlexSQLForums — Mon, 19 Oct 2009 14:30:55 GMT

Give us more i love these kind of questions.

RE: File Groups

KevinC. — Mon, 19 Oct 2009 11:16:20 GMT

Great question. I learned something new.:-D

RE: File Groups

GabyYYZ — Mon, 19 Oct 2009 09:50:34 GMT

[quote][b]SanjayAttray (10/19/2009)[/b][hr]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.[/quote]Why would that be faster than say, creating a target table on file2 and inserting all into it from the source table?

RE: File Groups

SanjayAttray — Mon, 19 Oct 2009 09:05:33 GMT

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.

RE: File Groups

Steve Jones - SSC Editor — Mon, 19 Oct 2009 07:51:39 GMT

nice question, I missed the clustered part.The engine definitely should inform someone if this doesn't work.

RE: File Groups

Robert Frasca — Mon, 19 Oct 2009 07:39:24 GMT

So it just ignores the FG2 reference? The fact that it essentially corrects the developer's mistake is great, I guess, but shouldn't the engine inform the developer that it's doing so?

RE: File Groups

Chris Houghton — Mon, 19 Oct 2009 04:33:53 GMT

[quote][b]ChiragNS (10/19/2009)[/b][hr]knew the answer but clicked on the wrong button :([/quote]I didn't, although I should have.:Whistling: Overlooked the fact that the constraint was clustered. Good question :-P

RE: File Groups

ChiragNS — Mon, 19 Oct 2009 02:09:19 GMT

knew the answer but clicked on the wrong button :(

File Groups

SA-1 — Sat, 17 Oct 2009 13:39:42 GMT

Comments posted to this topic are about the item [B]File Groups[/B]