Excuse this reply as it is not a complete answer to your question, but hopefully it will give you a place to start.

For date of last update of statistics for...

Ran across this article which might spread some light on your problem:

http://blogs.msdn.com/data/archive/2007/06/05/64-bit-oledb-provider-for-odbc-msdasql-available-in-longhorn-server-starting-beta-3.aspx

I believe the required driver is also available to download from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

If you are using EXCEL earlier than 2007 have you tried OPEN ROWSET .

An example:

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=D:\MSSQL\Test.xls', SELECT * FROM [Sheet1$]')

SELECT * FROM Keywords

You would have to use...

This link might provide you with the information you are looking for

http://www.tek-tips.com/viewthread.cfm?qid=832355

and

http://jtds.sourceforge.net/apiCursors.html

This probably as good a place to start as any other

http://technet.microsoft.com/en-us/library/cc179188.aspx

Not knowing your actual data and its sequence across a row of...

While waiting for some one with a better understanding of data storage you might while away your time reading the following, in particular how the database engine stores VARCHAR(Max) data.

http://msdn.microsoft.com/en-us/library/ms178158.aspx

If you present your data as discussed in the link in my signature block, and be very specific about what you desire to do with this data I would be...

I am making the assumption that you wish to perform tasks such as selects, updates, inserts, deletes on DBs located on a linked server.

If that is the situation...

Might I suggest that you use GOOGLE, MIcrosoft's TECH NET and MSDN (Microsoft Developer Network) to search for what you want and then if you have a specific problem...

You might wantto review this dynamic management view before and after your rebuild

SQL Server 2005 Books Online (September 2007)

sys.dm_db_index_physical_stats

Here is a method to "adjust" all the addresses to match by removing any unwanted periods .

CREATE TABLE #Table(Id INT, Address VARCHAR(20),Description VARCHAR(40))

INSERT INTO #Table

SELECT 1,'1111 E.Valley St','Period w/o...

Barry go to this site for a preview of your new car

http://www.modelcars.com/modelcar3162.php

My suggestion to you would be to create a requirements document.

Some simple questions which need to be answered before starting the database design would be:

1. What model...

Might I suggest you use Books On Line

SQL Server 2005 Books Online (September 2007)

SQL Server Profiler Terminology

It will explain how you can set up a trace...