Viewing 15 posts - 37,921 through 37,935 (of 49,571 total)
I would suggest that you first get used to SQL's native locking mode, understand how it works, when there are problems with it and why. Snapshot isolation is not the...
July 3, 2009 at 6:08 am
Fairly often on holidays the Question of the day will relate to the holiday, not to SQL. I've seen halloween-related questions, christmas-related questions, etc. It's just a bit of fun.
Those...
July 3, 2009 at 6:01 am
SQL by default uses locks for transaction isolation, while Oracle uses a form of row-versions.
In SQL, if you issue an update within a transaction, the locks taken by that update...
July 3, 2009 at 5:57 am
river (7/3/2009)
UPDATE STATISTICS table_name WITH FULLSCAN
Should i update only tables statistics? or should i update every table and every...
July 3, 2009 at 5:49 am
What is it that you want to find from the transaction log?
July 3, 2009 at 2:01 am
Lynn Pettis (7/3/2009)
Maybe I am letting things get to me more right now, but in this case I really don't think so.
It's more a general impression across several threads than...
July 3, 2009 at 1:42 am
Lynn Pettis (7/2/2009)
Okay, now he has crossed the line!! Who the hell does he think he is calling me a liar!!!!
I read that post as him apologising to you for...
July 3, 2009 at 12:20 am
RBarryYoung (7/3/2009)
Uh, ... little help here Steve? Seems like I got 3 more posts than I needed...
Steve's on vacation. Will be back sunday
July 3, 2009 at 12:15 am
Paul White (7/2/2009)
You should disregard the estimated cost percentages when looking at plans - they are wildly inaccurate much of the time (for good reasons).
And they are always wildly inaccurate...
July 3, 2009 at 12:03 am
I would still suggest running a checkDB on all the databases involved. Are you running regular integrity checks?
July 3, 2009 at 12:02 am
Bruce W Cassidy (7/2/2009)[h]
Alvin Ramard (7/2/2009)
Do you want yours black, or with cream and/or sugar?[font="Verdana"]With steamed non-fact milk, by preference. :cool:[/font]
Hmm, if it's not a fact, then it cannot...
July 2, 2009 at 3:29 pm
Lee Hart (7/2/2009)
QUESTIONIn the event I run the DBCC CheckDB on all the db's involved and they also come back with no issues where would you recommend looking next?
Not sure....
July 2, 2009 at 3:25 pm
Bruce W Cassidy (7/2/2009)
john.arnott (7/2/2009)
name="knownAsteroids" class ="Asteroid">
... 40 or so lines of xml
$beliefbase.getBeliefSet("known_asteroids").size()>0
A tiny part of me of which I am not proud was...
July 2, 2009 at 3:24 pm
john.arnott (7/2/2009)
name="knownAsteroids" class ="Asteroid">
... 40 or so lines of xml
$beliefbase.getBeliefSet("known_asteroids").size()>0
A tiny part of me of which I am not proud was glad to see...
July 2, 2009 at 3:22 pm
Viewing 15 posts - 37,921 through 37,935 (of 49,571 total)