February 25, 2014 at 11:02 am
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.
February 25, 2014 at 12:54 pm
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
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? Everybody look what's going down. -- Stephen Stills
February 25, 2014 at 6:47 pm
The Dixie Flatline (2/25/2014)
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
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
February 25, 2014 at 7:46 pm
The Dixie Flatline (2/25/2014)
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
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
February 26, 2014 at 1:52 am
Stefan Krzywicki (2/25/2014)
The Dixie Flatline (2/25/2014)
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
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.
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
February 26, 2014 at 1:58 am
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)
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 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?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
February 26, 2014 at 6:02 am
AAAHHHH!!!!! http://www.sqlservercentral.com/Forums/FindPost1545323.aspx
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
February 26, 2014 at 7:11 am
GilaMonster (2/26/2014)
AAAHHHH!!!!! http://www.sqlservercentral.com/Forums/FindPost1545323.aspx
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.
February 26, 2014 at 11:11 am
GilaMonster (2/26/2014)
AAAHHHH!!!!! http://www.sqlservercentral.com/Forums/FindPost1545323.aspx
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
February 26, 2014 at 11:15 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 26, 2014 at 11:28 am
GilaMonster (2/26/2014)
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.
When we get errors in this range, it usually mean the RAID controller or drives are failing. Yes, restore the data, after they verify the underlying storage.
February 26, 2014 at 11:54 am
EricEyster (2/26/2014)
When we get errors in this range, it usually mean the RAID controller or drives are failing. Yes, restore the data, after they verify the underlying storage.
All corruption-related errors (823, 824 and 825) imply that there is something wrong with the IO subsystem, no matter where in the database file the corruption happens to land.
Not necessarily the drives, can be anything in the IO stack from filter drivers all the way down to the disk.
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
February 26, 2014 at 12:26 pm
Yep, just saying we have field technicians that restore databases and walk away. Then we get a very upset store manager call back in 2 weeks with the same problem and more data loss.
February 26, 2014 at 2:33 pm
TomThomson (2/25/2014)[/b]
The Dixie Flatline (2/25/2014)
rodjkidd (2/25/2014)
Steve Jones - SSC Editor (2/24/2014)
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)"
[/quote-2]
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.
[/b]
Tom, as a native of Mississippi for 43 of my 58 years, I've heard my fair share of the blues in my lifetime, and my fair share of the Stones. so I must beg to differ. If you want more authoritative support for my statement, start here.
As for the rest of your comments, they simply amount to the fact that you don't like the Stones' music. That's your personal preference and you are certainly entitled to it. Some people don't like curling or haggis, or bagpipes. I personally like bagpipes but I'm sure many people find their sound to be loud, uninteresting, and discordant. As a great philosopher once said... It don't matter.
Best regards.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 26, 2014 at 2:45 pm
Blog and email working again. Finally.
I hate DNS-related problems.
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
Viewing 15 posts - 43,081 through 43,095 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply