Viewing 15 posts - 1,441 through 1,455 (of 18,926 total)
Kiara (11/10/2011)
Ninja's_RGR'us (11/10/2011)
SQL Kiwi (11/10/2011)
Ninja's_RGR'us (11/10/2011)
Actually I caught the very moment it happened!You need a hobby.
Right back at ya :hehe:.
Father in hospital, house flooded. Need some R&R atm.
Sorry to...
November 10, 2011 at 7:04 am
Dev @ +91 973 913 6683 (11/10/2011)
That beind said if you plan to become the next google, then maybe you need to rethink your strategy.
???
It works well for smaller shops...
November 10, 2011 at 6:41 am
Jack Corbett (11/10/2011)
Ninja's_RGR'us (11/10/2011)
SQL Kiwi (11/10/2011)
Ninja's_RGR'us (11/10/2011)
Actually I caught the very moment it happened!You need a hobby.
Right back at ya :hehe:.
Father in hospital, house flooded. Need some R&R atm.
Sorry...
November 10, 2011 at 6:31 am
forsqlserver (11/10/2011)
Yes dear...Hmmm
Nice way to say you don't agree but don't know why and are out of arguments.
For some people that might not be received too well.
:Whistling:
November 10, 2011 at 6:28 am
GilaMonster (11/10/2011)
Lexa (11/2/2011)
So basically you cannot "over" update statistics, right?
No, but there's a point of diminishing returns, where the gain from the new stats has no effect on the query...
November 10, 2011 at 6:25 am
Also keep in mind that stats is a guess tool with partial scan of the data (unless requiring fullscan).
So nolock makes sense here since all you want in a good...
November 10, 2011 at 6:05 am
Greg Edwards-268690 (11/10/2011)
Ninja's_RGR'us (11/10/2011)
SQL Kiwi (11/10/2011)
Ninja's_RGR'us (11/10/2011)
Actually I caught the very moment it happened!You need a hobby.
Right back at ya :hehe:.
Father in hospital, house flooded. Need some R&R atm.
Hope...
November 10, 2011 at 6:00 am
I've pinged Gail for this one as she knows more about those internals.
AFAIK, the lock taken by update stat is a schema lock. Meaning you can't alter the object...
November 10, 2011 at 5:57 am
Access is a decent front end epecially for quick developement. That beind said if you plan to become the next google, then maybe you need to rethink your strategy.
November 10, 2011 at 5:51 am
Lookup access data project.
The data always sits on sql server. Access serves solely as front end. No need to import or sync data all the time.
#2 if you...
November 10, 2011 at 5:35 am
SQL Kiwi (11/10/2011)
Ninja's_RGR'us (11/10/2011)
Actually I caught the very moment it happened!You need a hobby.
Right back at ya :hehe:.
Father in hospital, house flooded. Need some R&R atm.
November 10, 2011 at 5:32 am
Koen Verbeeck (11/10/2011)
Ninja's_RGR'us (11/10/2011)
Jeff Moden (11/10/2011)
[font="Arial Black"]Congrats Gail!!!...
November 10, 2011 at 5:31 am
Viewing 15 posts - 1,441 through 1,455 (of 18,926 total)