Ok, good.

So going back to my question about Identity (INT - fixed lenght datatype) with Fill Factor of 100% - that should work fine and avoid the page splits.

(Actually...

Gail,

Does your answer assume the index is clustered? Nonclustered index on identify should not be affected by the row's growth - or I am missing something here?

Josehp,

Nice link.

Thanks

Replace the VARCHAR declarations with NVARCHAR and let me know if it helped.

In Query Analyzer, from the Tools menu select Options.

Go to Connections tab.

Unclick Use regional settings when displaying currency, number, dates and times.

That might fix it.

Hi Gail

Quick question about the splits.

If the index is on the identify field and you use 100% fill factor (with identity, you can go only one way so 100% should...

OK. I think my brain is still a bit asleep, so I missed the DSN answer.

And because I have not been dealing with ODBC for quite some time if my...

What does your VB app use to connect? ODBC?

PS.

I like my databases alkaline...

PS 2.

Just messing with you.

GSquared (3/12/2009)

---

That would violate one of the key properties of a database, its ACIDity. Not a good idea. Read up on why ACID matters. It's just about...

That is not a bad idea if you do not deal with many levels of SPs calling other SPs. Otherwise you have to haul that table all across all SPs...

Lynn,

That's my point. The proper nesting is not supported by the SQL. Maybe it's because of the violation of the ACID rules but it is not there.

I had...

Lynn,

If I am not mistaken the SAVE POINTS still does not provide you with an option to nest. It allows you to rollback to a certain point but it...

J,

Return can only return INT values, so if you need to get back something else it does not work. Also I would use return to indicate if the SP failed...

Sorry GSquared, no offense, but I am not buying this. Your explanation is very theoretical and does not provide an example when 'nested' transaction is useful. Using your second example...

For example just two of the cases when I use OUTPUT params:

1. Sometimes when returning one or few fields back to the UI for one record because it is less...