beginner_dk (3/19/2013)
Regarding sorting order, i went through the BOL over clause and tested on a table created my self and it worked. so i thought it might be true.
"It worked for me once" != "It's guaranteed to work". No order by, no guarantee of order, end of story.
Now, a simple query like that will probably come back in the correct order, but that's a side effect of how the query execution engine works, not a guaranteed behaviour
Coming to full text indexes there is a book "Mastering SQL Server 2008 By Michael Lee, Gentry Bieker" on page 626, chapter 21, second para of the new alter feature box, it is stated that FTI's are backed up with every SQL Server Back up processes because they are included in the standard catalog
so again with minimal knowledge about it, i assumed it to be true
.
It is true, but that quote in no way implies that prior to SQL 2008 FTIs were not backed up with the database because they're not included in the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability