Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9753,9763,9773,9783,979»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, May 17, 2013 8:33 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:50 PM
Points: 23,299, Visits: 32,039
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?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1454041
Posted Friday, May 17, 2013 9:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:14 AM
Points: 7,197, Visits: 6,341
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.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1454059
Posted Friday, May 17, 2013 9:27 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:44 AM
Points: 42,822, Visits: 35,953
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1454062
Posted Friday, May 17, 2013 10:39 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 5:32 PM
Points: 8,738, Visits: 9,284
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
Post #1454091
Posted Friday, May 17, 2013 10:54 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:34 PM
Points: 15,661, Visits: 28,051
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1454100
Posted Friday, May 17, 2013 11:13 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:50 PM
Points: 23,299, Visits: 32,039
And we have another winner:

After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't .How to check the next schedule?


Really, you don't know how to check your jobs with Job Activity Monitor? Maybe it is a good thing I am going to an actual desert soon.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1454113
Posted Friday, May 17, 2013 11:22 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:50 PM
Points: 23,299, Visits: 32,039
Lynn Pettis (5/17/2013)
And we have another winner:

After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't .How to check the next schedule?


Really, you don't know how to check your jobs with Job Activity Monitor? Maybe it is a good thing I am going to an actual desert soon.


OMG:

Yes the next run is scheduled to 2032. How can I change things back to normal.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1454124
Posted Friday, May 17, 2013 11:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:07 PM
Points: 2,766, Visits: 7,241
Lynn Pettis (5/17/2013)
Lynn Pettis (5/17/2013)
And we have another winner:

After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't .How to check the next schedule?


Really, you don't know how to check your jobs with Job Activity Monitor? Maybe it is a good thing I am going to an actual desert soon.


OMG:

Yes the next run is scheduled to 2032. How can I change things back to normal.


Wait 19 years


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1454140
Posted Friday, May 17, 2013 11:45 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:44 AM
Points: 42,822, Visits: 35,953
Stefan Krzywicki (5/17/2013)
Lynn Pettis (5/17/2013)
Lynn Pettis (5/17/2013)
And we have another winner:

After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't .How to check the next schedule?


Really, you don't know how to check your jobs with Job Activity Monitor? Maybe it is a good thing I am going to an actual desert soon.


OMG:

Yes the next run is scheduled to 2032. How can I change things back to normal.


Wait 19 years


RotFL



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1454142
Posted Friday, May 17, 2013 11:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 2:17 PM
Points: 53, Visits: 161
Lynn Pettis (5/17/2013)
Lynn Pettis (5/17/2013)
And we have another winner:

After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't .How to check the next schedule?


Really, you don't know how to check your jobs with Job Activity Monitor? Maybe it is a good thing I am going to an actual desert soon.


OMG:

Yes the next run is scheduled to 2032. How can I change things back to normal.


Perhaps it's time for them to invoke the Alternate Reality/Timewarp sp.
Post #1454145
« Prev Topic | Next Topic »

Add to briefcase «««3,9753,9763,9773,9783,979»»»

Permissions Expand / Collapse