Viewing 15 posts - 7,906 through 7,920 (of 8,416 total)
Bruce W Cassidy (5/21/2009)
[font="Verdana"]Just because we agree doesn't mean we can't have a good argument![/font]
Oh I couldn't disagree more! :w00t:
May 21, 2009 at 5:59 pm
Bruce,
Darn it. I was looking forward to an energetic debate there but it seems we all agree - oh well 😀
I'm a huge fan of RLV isolation levels too...
May 21, 2009 at 5:03 pm
Michael Valentine Jones (5/21/2009)
I just hate seeing NOLOCK put out there as the bad practice of first resort for solving concurrency problems, especially before trying SNAPSHOT isolation.
Agreed. NOLOCK as...
May 21, 2009 at 4:20 pm
Would be fascinating to know who 'flamed' Gail. Personally I would love to take a look at the discussion that prompted it and take the opportunity to vent some...
May 21, 2009 at 4:19 pm
Hey Bruce,
I'm not usually one to disagree 😉 but:
Read uncommitted is just as valid as any other isolation level. It depends on the business requirements. Sure, from a...
May 21, 2009 at 3:49 pm
naveenreddy.84 (5/20/2009)
Will using NOLOCK in the Stored procedure for SELECT State would provide performance beneficit?
It may. Not acquiring locks or reading row-versioned rows is always faster than acquiring locks...
May 21, 2009 at 4:37 am
Would paying everyone NULL work?
:w00t:
May 21, 2009 at 4:26 am
Michael Valentine Jones (5/18/2009)
Have you seen the specs on their new ioDriveDuo products?
Yeah I've ordered a couple for home use :w00t: 😀
Seriously, yes they are very impressive but there are...
May 18, 2009 at 8:01 pm
john.arnott (5/17/2009)
Paul White (5/17/2009)
Lynn Pettis (5/16/2009)
O Please great and wise gurus, for what reasons may SQL Server not allow me to create a nonclustered index?Deja vu!!!
Good find, Paul. I...
May 17, 2009 at 11:45 pm
Heh. We are not buying 2.5TB...
I forget the exact pricing but it was something like seven thousand (NZ) dollars for 160 GB. We would probably look to use...
May 17, 2009 at 9:52 pm
Jeff:
This was what I was referring to: (with emphasis this time!)
EdVassie (5/5/2009)
The only definite answer to this problem is 'it depends'.
So 'it depends' is a definite answer... 😀
May 17, 2009 at 9:44 pm
Florian Reischl (5/17/2009)
Nice new avatar! Is it Raumati Beach?
It is indeed! It is a view from Matatua Road over the sea toward Kapiti Island.
Thought it time for an avatar...
May 17, 2009 at 5:33 am
Lynn Pettis (5/16/2009)
O Please great and wise gurus, for what reasons may SQL Server not allow me to create a nonclustered index?
Deja vu!!!
May 17, 2009 at 5:31 am
Hi Hassie,
Actually the drives were only on evaluation and had to go back before we had chance to really give them a proper go.
We've asked for them back again for...
May 16, 2009 at 6:07 am
WayneS (5/15/2009)
Now THAT looks like a nice place to relax
Thanks Wayne (and Flo from earlier). It's fascinating to see where everyone is from - can't believe this hasn't been...
May 16, 2009 at 3:17 am
Viewing 15 posts - 7,906 through 7,920 (of 8,416 total)