February 19, 2013 at 1:31 pm
Has anyone here had experience with DB recovery companies/consultants on a Sybase database? The DB is corrupted, backups are too (except for one 9 months old), and they want to salvage as much data as possible. It's not MSSQL, but I told them I'd ask my friends (yes, that's you!) if they knew anyone reputable with experience in the Sybase arena.
Thanks,
Chad
February 20, 2013 at 10:53 am
Hey folks, can I get some help here: http://www.sqlservercentral.com/Forums/Topic1421888-392-1.aspx#bm1421965
A very pleasant newbie... I just don't understand what he's trying to say. New eyes on the problem might make sense of what he's attempting.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 20, 2013 at 11:01 am
Evil Kraig F (2/20/2013)
Hey folks, can I get some help here: http://www.sqlservercentral.com/Forums/Topic1421888-392-1.aspx#bm1421965A very pleasant newbie... I just don't understand what he's trying to say. New eyes on the problem might make sense of what he's attempting.
He wants to create a report from two tables. He's getting his header info from one table and the body info from another. The queries are straightforward, it comes down to how he's creating the report.
--------------------------------------
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 20, 2013 at 3:55 pm
Guys,
Have you realized that:
- there are over 1.6M members in this community as of today?
- we're getting closer to 39K posts on this thread?
Congratulations, everyone. Way to go!!!
Saludos,
February 20, 2013 at 4:05 pm
Close to 39k? No, there's still 100+(39*24) to go. 😀
Tom
February 21, 2013 at 1:43 am
Evil Kraig F (2/20/2013)
Hey folks, can I get some help here: http://www.sqlservercentral.com/Forums/Topic1421888-392-1.aspx#bm1421965A very pleasant newbie... I just don't understand what he's trying to say. New eyes on the problem might make sense of what he's attempting.
I posted a suggestion, don't know if it will help though :ermm:
Far away is close at hand in the images of elsewhere.
Anon.
February 21, 2013 at 2:28 pm
Right now, I'm feeling embarrassingly stupid. :blush:
I was trying to put together a submission for QotD. But I thought I'd seen too many comments recently where people had run code where really if running that code was necessary to get the answer they need a very basic remedial SQL course, so I wanted to forulate the code in such a way that they couldn't reasonably run it because it would run for too long (or at least restrict the ability to run it to people who had enough personal resources to run it without getting fed up with waiting for a result, rather than running it on company machines because it would take a nasty chunk of machine power). At the same time, I wanted to be able to run it to make sure that my answer was correct. So I put together the first part of the code, which would generate data for a table or CTE (hadn't decided yet) that would take a silly amount of both CPU and disc activity to generate, in a form that I thought I could sensibly run on my rather underpowered machine and leave to complete while I went off to make and drink some coffee, make and eat some sandwiches, and pour and swallow a couple of jars.
I came back to my machine and found that the code had finished in less than two minutes - and failed horribly: the error message was
Msg 1101, Level 17, State 10, Line 12
Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
The problem was incredibly stupid (:blush:). An intermediate result had to be either explicitly materialised as a (temp) table or spooled by the optimiser (the latter was the case in the version of the set-up that I tried). I had only a few 10s of gigabytes to spare. The intermediate result, if the machine had managed to generate and store it, would have had - as I discovered by doing some straightforwards arithmetic, which I ought to have done before setting it running :blush: - a little more than 2**48 (256 trillion - counting 1024 instead of 1000 as thousand) rows (actually 281475010265089, which is 1+2**25+2**48). :w00t:
Maybe that possible QotD will never see the day - I'll have to see if I can make it smaller without turning it into trivia (the crux was going to be a MERGE statement with three merge clauses, all of them with clause search conditions - maybe I should try to curb my liking for bizarre questions).
Tom
February 21, 2013 at 2:46 pm
L' Eomot Inversé (2/21/2013)
Right now, I'm feeling embarrassingly stupid. :blush:I was trying to put together a submission for QotD. But I thought I'd seen too many comments recently where people had run code where really if running that code was necessary to get the answer they need a very basic remedial SQL course, so I wanted to forulate the code in such a way that they couldn't reasonably run it because it would run for too long (or at least restrict the ability to run it to people who had enough personal resources to run it without getting fed up with waiting for a result, rather than running it on company machines because it would take a nasty chunk of machine power). At the same time, I wanted to be able to run it to make sure that my answer was correct. So I put together the first part of the code, which would generate data for a table or CTE (hadn't decided yet) that would take a silly amount of both CPU and disc activity to generate, in a form that I thought I could sensibly run on my rather underpowered machine and leave to complete while I went off to make and drink some coffee, make and eat some sandwiches, and pour and swallow a couple of jars.
I came back to my machine and found that the code had finished in less than two minutes - and failed horribly: the error message was
Msg 1101, Level 17, State 10, Line 12
Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
The problem was incredibly stupid (:blush:). An intermediate result had to be either explicitly materialised as a (temp) table or spooled by the optimiser (the latter was the case in the version of the set-up that I tried). I had only a few 10s of gigabytes to spare. The intermediate result, if the machine had managed to generate and store it, would have had - as I discovered by doing some straightforwards arithmetic, which I ought to have done before setting it running :blush: - a little more than 2**48 (256 trillion - counting 1024 instead of 1000 as thousand) rows (actually 281475010265089, which is 1+2**25+2**48). :w00t:
Maybe that possible QotD will never see the day - I'll have to see if I can make it smaller without turning it into trivia (the crux was going to be a MERGE statement with three merge clauses, all of them with clause search conditions - maybe I should try to curb my liking for bizarre questions).
DON'T give up...... I have had to "dumb down" many a QOD -
AND remember one of the main purposes of a QOD is to TEACH.
So you could/can relate your above experience in the discussion that normally follows any QOD. That experience is good teaching.
February 21, 2013 at 5:23 pm
L' Eomot Inversé (2/21/2013)
a little more than 2**48 (256 trillion - counting 1024 instead of 1000 as thousand) rows (actually 281475010265089, which is 1+2**25+2**48). :w00t:
Now that's a test harness! Jeff take notice. 😛
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 22, 2013 at 12:19 pm
Heh, this seems to be becoming thematic for my posts in the thread...
Anyone around here worked much with Extended Events? It's way out of my scope, I only know the name.
If you have, would you mind poking at here: http://www.sqlservercentral.com/Forums/Topic1421470-3077-1.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 22, 2013 at 2:26 pm
dwain.c (2/21/2013)
L' Eomot Inversé (2/21/2013)
a little more than 2**48 (256 trillion - counting 1024 instead of 1000 as thousand) rows (actually 281475010265089, which is 1+2**25+2**48). :w00t:Now that's a test harness! Jeff take notice. 😛
BWAA-HAAA!!!! Tom claims to have an "underpowered" machine but he has the HD space to store 1/4 Quadrillion rows? "Underpowered" my patooti! 😛
If his machine is as underpowered as my desktop, it will take approximately 40 minutes to gen a billion rows. I know because I tried it a couple of years ago. That means that it would take approximately 19.469 years to generate that many rows on his machine and only if he could avoid the log file from exploding by building the rows in sets of a mere billion or so. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2013 at 2:30 pm
Evil Kraig F (2/22/2013)
Heh, this seems to be becoming thematic for my posts in the thread...Anyone around here worked much with Extended Events? It's way out of my scope, I only know the name.
If you have, would you mind poking at here: http://www.sqlservercentral.com/Forums/Topic1421470-3077-1.aspx
I've not had the opportunity to work on Extended Events nor to even read up on them. My only comment is one of shear shock and mortification... "REALLY???!!!!! XML???!!!!!" What the hell were they thinking when they wrote the spec on that little pearl? Even a CSV would have been better so they could avoid the tag-bloat! What's next? A bloody Ribbon-Bar????
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2013 at 3:27 pm
Jeff Moden (2/22/2013)
dwain.c (2/21/2013)
L' Eomot Inversé (2/21/2013)
a little more than 2**48 (256 trillion - counting 1024 instead of 1000 as thousand) rows (actually 281475010265089, which is 1+2**25+2**48). :w00t:Now that's a test harness! Jeff take notice. 😛
BWAA-HAAA!!!! Tom claims to have an "underpowered" machine but he has the HD space to store 1/4 Quadrillion rows? "Underpowered" my patooti! 😛
No, it never had to store that many rows as it never managed to generate them (because it ran out of space while trying).
If his machine is as underpowered as my desktop, it will take approximately 40 minutes to gen a billion rows. I know because I tried it a couple of years ago.
I'll generate a billion row table and see how long it takes on my (definitely underpowered) machine.
Tom
February 22, 2013 at 4:45 pm
Brandie Tarvin (2/13/2013)
Grant Fritchey (2/13/2013)
I think we're back to the Roadhouse rule set here. Be nice.And always keep a set of spare tires in the trunk.
SO long as it is a semi beatup muscle car.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 22, 2013 at 4:49 pm
Viewing 15 posts - 38,986 through 39,000 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply