Viewing 15 posts - 166 through 180 (of 375 total)
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 16, 2009 at 9:30 am
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
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 16, 2009 at 6:55 am
Replace the VARCHAR declarations with NVARCHAR and let me know if it helped.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 16, 2009 at 6:38 am
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.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 13, 2009 at 10:05 am
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 13, 2009 at 8:22 am
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 13, 2009 at 7:59 am
What does your VB app use to connect? ODBC?
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 13, 2009 at 7:39 am
PS.
I like my databases alkaline...
PS 2.
Just messing with you.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 2:44 pm
GSquared (3/12/2009)
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 2:40 pm
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 2:05 pm
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 1:44 pm
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 1:25 pm
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 1:01 pm
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 12:48 pm
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 12:37 pm
Viewing 15 posts - 166 through 180 (of 375 total)