RESOLUTION: Fill Factor was 2% for some odd reason.

:D:D:D

Using the exec sp_mshelpindex command I got 2% as the OrigFillFactor.

Use SSMS, I set the Fill Factor to 100%, just for...

The table consists of 4 columns: 2 int, 2 datetime

The mdf file size does indeed match the report.

There is only the PK Clustered Index going over. It has 0.00% total fragmentation.

The subscriber database's table shows 105Million rows using 184GB used

The publisher database's table for 300Million rows...

Please provide as much information as possible for us to help you. What errors do you receive? Have you looked in the SQL Error Log and Windows Application...

A few thoughts for you:

1 transaction will have x replication commands. So if your update affects 10000 rows, you have 1 transaction with 10000 commands.

Hence, replication distribution to a...

I did this once, and I scripted out all of the indexes. Most likely find script here to help generate CREATE INDEX code for your (non-clustered indexes) and execute...

You give me an excited, talented, motivated, eager candidate with good work ethics and experience, and academic credentials become less of an issue - it's the desire to learn and...