Thanks for the notes.

I, too, do not think any SQL operations could have caused this kind of corruption. Will focus on IO, etc.

thanks.

LCAD (1/27/2009)

---

We'll, I do say that this is OK.

......

So, instead of trying to argue that the application shouldn't function in a certain way, or that it is wrong to...

regardless of how you define the rest of your table, an identity column wouldn't be a problem for 50k per day.

do you think the problem is on the OS side or on the storage side?

sorry. first time post a topic here. only replied a couple previously.

for pure insert purpose, identity column wouldn't be a big overhead.

however, whether to make it a clustered index depends on other factors such as data distribution and how you...