It's ok for appending but if your record goes at the middle of the table (when PK = Clustered).... SQL have to physically move all the lines above.

I tried this before also and the result is the same that sp_helpdb: 'Applive_Data'

quote:

---

I just tried and had no issues.

Run

SELECT * FROM...