I want to drop and recreate indexes and partition some tables on the clustered server.

Do you want me to run the stats on the production box on the one that is already fixed?

Tried rebuilding. Fragmentation didn't change very much. The drop and recreate gave us 0% fragmentation.

On the new system we dropped and recreated all the indexes. On the production I tried a script that checks fragmentation levels and decides based on that whether or not...

Tried to reindex them but they were still over 50%.

The primary keys are fragmented too and can't drop them without dropping constraints and that's not a good idea to do on live production.

Performance is terrible at this point. I have one table that has 1.8 billion records and several others that are pretty big but not that big. The indexes are fragmented...

Have you tried the updated version that is NOT a procedure?

Sorry. But this is what I was looking for and it works.

Ths is the correct solution.

Declare DDOKRaw cursor for

Select [field name],startingposition, fieldlength from dbo.TablefieldPositionLength

DECLARE @insert_part varchar(4000)

DECLARE @value_part varchar(4000)

DECLARE @loop int

Declare @fn varchar(128)

Declare @sp-2 varchar(128)

Declare @fl varchar(128)

Open DDOKRAW

Fetch...

Ok. I changed the name of the file to file.xdr. I opened it in Visual Studio. I used the XML file command to change it to xml....

Are you saying that I can't use that xml data to create the schema? That file should be used to create the table itself. And I tried the example that...