Viewing 15 posts - 37,906 through 37,920 (of 49,552 total)
sarvesh singh (7/3/2009)
; WITH CTE ( EM_EmpId, EM_DeptName, seq )
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 3, 2009 at 2:05 am
What is it that you want to find from the transaction log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2009 at 3:22 pm
Can you run CheckDB on all databases that procedure touches?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2009 at 2:03 pm
WayneS (7/2/2009)
Is there a way to tell when / how often a file has grown in the past?
Default trace, for as far back as it goes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2009 at 1:53 pm
Aaahhhh!!!!
I've spend several evenings over the last two weeks trying to figure out why the BDI agent I was working on was ignoring a belief change.
I checked and rechecked...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2009 at 1:51 pm
ALZDBA (7/2/2009)
Keep prod and dev data on separate instances !
Keep prod and dev on different servers!
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2009 at 12:54 pm
Viewing 15 posts - 37,906 through 37,920 (of 49,552 total)