IS there one perference over another?

Do I need specify like INIT or NOINIT?

So I would copy that script into a SQL Server Agent Job?

Does it do any good to defrag BLOB indexes? I also have several cases I have heap table (no clustered indexes )? These table do not have clustered indexes because...

I found the following script that I have been testing and it seems to work except for an issue with BLOBs.

SET NOCOUNT ON

--Create temporary table to hold DBCC SHOWCONTIG output

CREATE...

Another question that I have that is related to indexing is we have a number of tables with Text datatype (blob) which seems to be be picked up in the...

That sounds right where I want to go with this. Do have any examples of how this could be done. I really don't want to re-invent the wheel.

I am wondering is if a restore to tis server from another server would have stepped on it. If so should I un-install full-text indexing or something.

I did not do it. I am just coming in and this is what was in place when I got here.

Then this sounds like its going to lead me down the path of file groups. I have a 590GB PRIMARY data file along with a 30GB t-log. I need to...

Exactly.

Thank you for clearing that up. I appreciate the input.

Doesn't creating the FK back it up with an index?

Thanks a lot for the information.

The SQLServer is running on a DOMAIN Account.