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 «««4,3074,3084,3094,3104,311»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, February 25, 2014 11:02 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 2:57 PM
Points: 23,009, Visits: 31,508
SQLRNNR (2/25/2014)
Lynn Pettis (2/25/2014)
Last night home. Start my journey back to Afghanistan Tuesday morning.



Good luck and safe travels.

Hope it was a good time back home.



It was a great time home. It was hard to leave. I had a great time getting to know my grandsons and help my oldest daughter when her oldest had croup and had to stay in the hospital a couple of days.




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 #1545067
Posted Tuesday, February 25, 2014 12:54 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:12 PM
Points: 4,000, Visits: 6,057
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
[quote][b]

I went to the Rock and Roll Hall of Fame in Cleveland a few weeks ago. It was pretty neat to see the history of some bands and people. Large Rolling Stones exhibit there. Amazed to think how they've changed, from being Beatles-like in the 60s to where they are today.


Sounds like a good place to visit.
The Stones - and most people think they have always just sounded like the "Stones"

Rodders...


HERESY.... the Stones were always grounded in the blues.

"Satisfaction" sounds nothing like "She Loves You (Yah Yah Yah)"


__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #1545120
Posted Tuesday, February 25, 2014 6:47 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 8,556, Visits: 9,047
The Dixie Flatline (2/25/2014)
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
[quote][b]

I went to the Rock and Roll Hall of Fame in Cleveland a few weeks ago. It was pretty neat to see the history of some bands and people. Large Rolling Stones exhibit there. Amazed to think how they've changed, from being Beatles-like in the 60s to where they are today.


Sounds like a good place to visit.
The Stones - and most people think they have always just sounded like the "Stones"

Rodders...


HERESY.... the Stones were always grounded in the blues.

"Satisfaction" sounds nothing like "She Loves You (Yah Yah Yah)"

Nonsense! They wouldn't have understood the blues even if someone had sprayed them with it. They just liked loud uninteresting noises (sometimes discordant ones) with no decent lyrics to support them.

But you are dead right that "Satisfaction" sounds nothing like "She loves you". But of course saying that is about as useful as saying that "Little Red Rooster" doesn't sound much like "She's leaving home" and that's an equally reasonable comparison.


Tom
Post #1545188
Posted Tuesday, February 25, 2014 7:46 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:08 PM
Points: 2,751, Visits: 7,164
The Dixie Flatline (2/25/2014)
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
[quote][b]

I went to the Rock and Roll Hall of Fame in Cleveland a few weeks ago. It was pretty neat to see the history of some bands and people. Large Rolling Stones exhibit there. Amazed to think how they've changed, from being Beatles-like in the 60s to where they are today.


Sounds like a good place to visit.
The Stones - and most people think they have always just sounded like the "Stones"

Rodders...


HERESY.... the Stones were always grounded in the blues.

"Satisfaction" sounds nothing like "She Loves You (Yah Yah Yah)"


What amazes me about the Stones is that Mick Jagger has always sounded like a parody of Mick Jagger.


--------------------------------------
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 #1545198
Posted Wednesday, February 26, 2014 1:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:56 AM
Points: 7,120, Visits: 13,491
Stefan Krzywicki (2/25/2014)
The Dixie Flatline (2/25/2014)
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
[quote][b]

I went to the Rock and Roll Hall of Fame in Cleveland a few weeks ago. It was pretty neat to see the history of some bands and people. Large Rolling Stones exhibit there. Amazed to think how they've changed, from being Beatles-like in the 60s to where they are today.


Sounds like a good place to visit.
The Stones - and most people think they have always just sounded like the "Stones"

Rodders...


HERESY.... the Stones were always grounded in the blues.

"Satisfaction" sounds nothing like "She Loves You (Yah Yah Yah)"


What amazes me about the Stones is that Mick Jagger has always sounded like a parody of Mick Jagger.


Alledgedly his mum used to stop him running riot in the local supermarket by licking him on the lips and sticking him to the window.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1545261
Posted Wednesday, February 26, 2014 1:58 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:01 PM
Points: 3,609, Visits: 5,222
ChrisM@Work (2/26/2014)
Stefan Krzywicki (2/25/2014)
The Dixie Flatline (2/25/2014)
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
[quote][b]

I went to the Rock and Roll Hall of Fame in Cleveland a few weeks ago. It was pretty neat to see the history of some bands and people. Large Rolling Stones exhibit there. Amazed to think how they've changed, from being Beatles-like in the 60s to where they are today.


Sounds like a good place to visit.
The Stones - and most people think they have always just sounded like the "Stones"

Rodders...


HERESY.... the Stones were always grounded in the blues.

"Satisfaction" sounds nothing like "She Loves You (Yah Yah Yah)"


What amazes me about the Stones is that Mick Jagger has always sounded like a parody of Mick Jagger.


Alledgedly his mum used to stop him running riot in the local supermarket by licking him on the lips and sticking him to the window.


In this day and age, they'd probably call that child abuse.



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1545264
Posted Wednesday, February 26, 2014 6:02 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 @ 2:18 PM
Points: 42,449, Visits: 35,504
AAAHHHH!!!!! http://www.sqlservercentral.com/Forums/FindPost1545323.aspx


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 #1545354
Posted Wednesday, February 26, 2014 7:11 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:01 AM
Points: 1,539, Visits: 8,133


It's bad enough trying to sort out the original suggestion without fending off 'helpful' bystanders.

I assume this is the one you tweeted about earlier.


BrainDonor
Linkedin
Blog Site
Post #1545377
Posted Wednesday, February 26, 2014 11:11 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:00 PM
Points: 33,062, Visits: 15,175


Yeah, we need better disclosure on the "repair" strategy being bad.

I wish this was a TF enabled item and not just something people can run







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1545511
Posted Wednesday, February 26, 2014 11:15 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 @ 2:18 PM
Points: 42,449, Visits: 35,504
BrainDonor (2/26/2014)
I assume this is the one you tweeted about earlier.


Yup.

I strongly suspect it's not repairable. The page number the error gives is within the range I'd expect system tables to have. Also CheckDB is supposed to consume the 824 errors and produce corruption-related informational messages. CheckDB actually throwing an 824 suggests that it's a very low-level component of the storage engine that's choking on the corruption and failing catastrophically and that does not bode well for the state of the data.



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 #1545514
« Prev Topic | Next Topic »

Add to briefcase «««4,3074,3084,3094,3104,311»»»

Permissions Expand / Collapse