May 16, 2013 at 2:54 pm
OK.... so what are the parameters for DBCC TIMEWARP in SQL 2005 again? I"m about to derive to a point and disappear from this conversation.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 16, 2013 at 3:14 pm
The Dixie Flatline (5/16/2013)
OK.... so what are the parameters for DBCC TIMEWARP in SQL 2005 again? I"m about to derive to a point and disappear from this conversation.
Don't do that, we've missed you. Honestly, it has been a while since you visited us here.
May 16, 2013 at 3:55 pm
With an announcement from the Oracle DBA I work with, I now know what the people I used to work with felt like when I announced I was leaving...
Worse, he's leaving half-way through my vacation, leaving a very novice guy in charge of both MS SQL and Oracle...
Oh boy...
May 16, 2013 at 4:34 pm
jasona.work (5/16/2013)
With an announcement from the Oracle DBA I work with, I now know what the people I used to work with felt like when I announced I was leaving...Worse, he's leaving half-way through my vacation, leaving a very novice guy in charge of both MS SQL and Oracle...
Oh boy...
Sounds like fun when you get back from vacation. 😉
May 16, 2013 at 7:40 pm
Lynn Pettis (5/16/2013)
jasona.work (5/16/2013)
With an announcement from the Oracle DBA I work with, I now know what the people I used to work with felt like when I announced I was leaving...Worse, he's leaving half-way through my vacation, leaving a very novice guy in charge of both MS SQL and Oracle...
Oh boy...
Sounds like fun when you get back from vacation. 😉
Just a demonstration of the Murphy's Law, nothing more. 🙂
edit: an overlooked typo
May 17, 2013 at 4:51 am
Lynn Pettis (5/16/2013)
Second PM:no, they derail my posts. The post is first and foremost for me, secondly for all others having same problem.
The post is for him?
That makes it sound like he doesn't want anyone to answer, that he's just posting to see himself type.
That's the way I'm reading that.
May 17, 2013 at 7:09 am
Brandie Tarvin (5/17/2013)
Lynn Pettis (5/16/2013)
Second PM:no, they derail my posts. The post is first and foremost for me, secondly for all others having same problem.
The post is for him?
That makes it sound like he doesn't want anyone to answer, that he's just posting to see himself type.
That's the way I'm reading that.
naw, he's saying he needs help first, screw the other people, they can figure it out later on their own.
Lynn should change his post to:
"EDITED: removed solution at the request of the OP, if you are having the same issues and want to know how to fix it, please contact OP to find out what they did"
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 17, 2013 at 7:24 am
"I know the drawbacks of nolock, in our case it cannot be avoided"
Hmm...
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
May 17, 2013 at 7:32 am
GilaMonster (5/17/2013)
"I know the drawbacks of nolock, in our case it cannot be avoided"Hmm...
Probably doesn't wear a seatbelt on the autobahn either. 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 17, 2013 at 8:31 am
jcrawf02 (5/17/2013)
Brandie Tarvin (5/17/2013)
Lynn Pettis (5/16/2013)
Second PM:no, they derail my posts. The post is first and foremost for me, secondly for all others having same problem.
The post is for him?
That makes it sound like he doesn't want anyone to answer, that he's just posting to see himself type.
That's the way I'm reading that.
naw, he's saying he needs help first, screw the other people, they can figure it out later on their own.
Lynn should change his post to:
"EDITED: removed solution at the request of the OP, if you are having the same issues and want to know how to fix it, please contact OP to find out what they did"
Actually had a couple of constructive PMs yesterday. I woke up to this one:
You are like my new little brother. I have to take you everywhere fun I want to go. See you next topic!
Think I may be forgiven for perceived past transgressions?
May 17, 2013 at 8:33 am
GilaMonster (5/17/2013)
"I know the drawbacks of nolock, in our case it cannot be avoided"Hmm...
Hmm, recall seeing that somewhere before....
Is that from the same person who thinks that NOLOCK makes queries run faster?
May 17, 2013 at 9:20 am
Lynn Pettis (5/17/2013)
GilaMonster (5/17/2013)
"I know the drawbacks of nolock, in our case it cannot be avoided"Hmm...
Hmm, recall seeing that somewhere before....
Is that from the same person who thinks that NOLOCK makes queries run faster?
You're going to have to be more specific. I have 20 of those in my immediate workplace. Maybe more.
May 17, 2013 at 9:27 am
Lynn Pettis (5/17/2013)
Is that from the same person who thinks that NOLOCK makes queries run faster?
Which one of them?
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
May 17, 2013 at 10:39 am
patrickmcginnis59 10839 (5/15/2013)
Now can someone tell me what all the fuss is about? Please?
Not a big web user eh? Its not like people haven't been discussing this to death.
I'm not really sure how I should react to that.
People have indeed been discussing it to death. It appears to me to have been a discussion with much heat, little light, and far too much blind resistance to change. I suspect that having first played with computers in the early 60s and having worked with them since the mid-60s that I've both seen rather more changes in software (and hardware, of course) than most of the people participating in the discussion and have a lot more chance of distinguishing bad change from good change. That's the polite reaction to your arrogant and ignorant condescension, I won't treat you to the alternative version.
.....
I think you can dismiss the significant proportion of detractors however you like, but you'll have a hard time convincing me that there aren't real issues with this release.
There probably are some real issues, but not enough to justify the volume of vituperation of windows 8 that is being spouted out there. When was the last time MS (or IBM, or Apple, or Adobe, or anyone else in the software business) made a big release that had absolutely no real issues?
Tom
May 17, 2013 at 10:54 am
GilaMonster (5/17/2013)
"I know the drawbacks of nolock, in our case it cannot be avoided"Hmm...
And we have a really good reason to not run backups, to have the database in simple recovery, to never test the backups that we do run, and yeah, I can justify that 150 column heap table that is called by every query in the system...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 39,751 through 39,765 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply