Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

File Groups Expand / Collapse
Author
Message
Posted Saturday, October 17, 2009 1:39 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:58 PM
Points: 1,141, Visits: 944
Comments posted to this topic are about the item File Groups
Post #804714
Posted Monday, October 19, 2009 2:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
knew the answer but clicked on the wrong button

"Keep Trying"
Post #804926
Posted Monday, October 19, 2009 4:33 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:17 AM
Points: 558, Visits: 1,495
ChiragNS (10/19/2009)
knew the answer but clicked on the wrong button


I didn't, although I should have. Overlooked the fact that the constraint was clustered. Good question
Post #804956
Posted Monday, October 19, 2009 7:39 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 11:57 AM
Points: 561, Visits: 687
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?



"Beliefs" get in the way of learning.
Post #805030
Posted Monday, October 19, 2009 7:51 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:11 PM
Points: 31,368, Visits: 15,837
nice question, I missed the clustered part.

The engine definitely should inform someone if this doesn't work.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #805040
Posted Monday, October 19, 2009 9:05 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
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.


SQL DBA.
Post #805122
Posted Monday, October 19, 2009 9:50 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:42 PM
Points: 644, Visits: 2,151
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?


Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein
Post #805145
Posted Monday, October 19, 2009 11:16 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 7, 2010 12:55 AM
Points: 771, Visits: 504
Great question. I learned something new.
Post #805198
Posted Monday, October 19, 2009 2:30 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 1:41 PM
Points: 1,298, Visits: 1,891
Give us more i love these kind of questions.

Alex S
Post #805275
Posted Monday, October 19, 2009 5:25 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:53 PM
Points: 1,388, Visits: 3,039
Steve Jones - Editor (10/19/2009)
nice question, I missed the clustered part.

The engine definitely should inform someone if this doesn't work.
Funny thing. I missed this because I DID see the clustered part and figured that SQL would complain about it. Oh, well; learned something here for sure.
Post #805335
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse