|
|
|
SSCoach
         
Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732,
Visits: 12,329
|
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: 2 days ago @ 9:58 AM
Points: 2,570,
Visits: 1,530
|
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Yesterday @ 11:46 AM
Points: 3,448,
Visits: 2,522
|
|
| I got this one wrong but I learned something...
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176,
Visits: 778
|
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Yesterday @ 10:15 AM
Points: 42,
Visits: 925
|
|
I got it wrong because I was reading 'Data files can be moved...' when I was actually thinking 'Data can be moved..' Welll, reading questions correctly is also part of the challenge 
|
|
|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Saturday, April 27, 2013 9:30 PM
Points: 392,
Visits: 384
|
|
|
|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:10 PM
Points: 307,
Visits: 1,390
|
|
Same here 
Tom.Thomson (8/25/2011) Good question.
I thought about this one for quite a bit. Obviously I can move indices between filegroups, unless they support unmovable constraints (which can be fixed using DROP EXISTING) but I can't think of any way to move a file except to remove it and then add it back elsewhere - and I'm not at all sure that that will preserve the content (maybe it deletes the file and creates a new one? - one can't specify a filegroup when modifying a file , only when adding it); so the answer was probably "no" - so I got my point, not because I knew the answer but because to me it seemed to be the most probably correct answer.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Friday, May 10, 2013 1:15 AM
Points: 1,216,
Visits: 295
|
|
| Simple and easy question.
|
|
|
|