Obviously row length etc will affect the capacity of transactional replication but I would expect 500,000 rows a day to be problematic.

Solutions I have worked on with...

Any chance that the data file these tables are in is full and not set to autogrow?

According to BOL this is not how you use OPENROWSET.

I am presuming here that TABLE_A has multiple columns and the data file represents this in a suitable format like .csv

You...

When you say large what do you mean?

Also are you trying to reindex a table (therefore all indexes) or an individual index. you could use a targeted index...

Steve,

Thanks but it seems that it is still not quite working right.

It says I answered True not False and was therefore wrong.

I clicked back and False is...

Use Query Analyser to run the sql against the desired db.

From Book On-line:

DBCC SHRINKFILE

( { file_name | file_id }

...

Another strategy you might try is to reindex each index individually rather than the whole table.

If there is a clustered index then it may be the re-indexing of that which...

Part of what you need to think about is why you want to shrink the file.

Why did the data grow to 80GB?

Will that happen again?

It is generally best to keep...

The reason the first shrink left 27GB is because these are not the last 27GB at the end of the file.

After this I have found that attempting to shrink files...

snaphot takes a point in time copy of a publication

Transactional allows multiple subscribers with/without updates.

Merge allows bidirectional replication with rules to determine whose changes persist.

Books on-line has a lot more...

The diagram is at:

http://www.microsoft.com/learning/mcp/newgen/default.mspx

Are you sure this is caused by clustering?

Is your other server taking the same load?

Also have you checked all the server wide settings to ensure...

Thanks,

I have found it helpful to show people the MCTS, MCITP (DBA / Developer), Architect diagram. You then tell them the architect costs $10,000 and requires 10+ years...

Hopefully MCITP since that was the one I passed on Friday.

Personally I would assume that it depends a lot on who is looking...

The precise logic of google is a well hidden secret and beyond the capacity of most of us to understand anyway, I suspect.

However looking up full-text indexing in...