Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Wednesday, May 25, 2016 1:11 PM
Points: 2,365, Visits: 1,865
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: Today @ 1:56 AM
Points: 584, Visits: 1,643
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: Friday, February 26, 2016 4:09 AM
Points: 568, Visits: 716
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: Today @ 1:07 PM
Points: 34,170, Visits: 18,319
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: Wednesday, January 6, 2016 1:49 PM
Points: 3,925, Visits: 1,619
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: Tuesday, September 20, 2016 8:47 AM
Points: 653, Visits: 2,332
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: Today @ 1:26 PM
Points: 1,346, Visits: 2,201
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: Monday, June 6, 2016 1:51 PM
Points: 1,400, Visits: 3,059
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