@ypercube ha ha awesome. It happens with all the dev not just with DBA. Being a BI dev i hate when my manager sits beside me and looks at my monitor :(
I have this ORA error in our logs:
Caused by: java.sql.BatchUpdateException: ORA-01578: ORACLE data block corrupted (file # 8, block # 22921) ORA-01110: data file 8: '/data/app/oracle/oradata/MYSRVR/datafile/o1_mf_mysrvr_88m82mdj.dbf'
I tried running this in sqlplus:
select segment_name,segmen...
I have this ORA error in our logs:
Caused by: java.sql.BatchUpdateException: ORA-01578: ORACLE data block corrupted (file # 8, block # 22921)
ORA-01110: data file 8: '/data/app/oracle/oradata/MYSRVR/datafile/o1_mf_mysrvr_88m82mdj.dbf'
I tried running this in sqlplus:
select segment_name,segmen...
The trailing "zero-bytes" 0x00 in a varbinary column is as insignificant as the trailing spaces " " in a varchar column. Therefore, your values are actually duplicates.
In other words, your two values are (in byte order)
1 2 3 4 5 6 7 --- bytes in the binary value
59 42 C8 03 66 4B
59 4...
I was going to demonstrate comparing VARCHARs (one with extra trailing space) using Latin1_General_Bin and expecting the space to count... it didn't.
I have a situation in a select, where it gets faster if I move dateadd() from the on-condition to the where-clause.
But sometimes it may not be possible to move it from the on-condition and to where-clause. My solution was to move the dateadd() from the on-condition to a temporary table instead...
writing test cases for my framework of encrypting root passwords for vm's such that only senior-senior level admins can decrypt them.
the key management is turning out to be.... challenging
I now have everything working except for the function that replaces a user's public and private keys.
I keep wondering if there is a market for a general (perhaps open source) toolkit for in-db key management so others don't have to reinvent what we've had to
whee, and rubber duckies to the rescue. All tests passing :-)
@DerekDowney yes but I am a glutton for punishment and somehow keep finding my way back there. I need to remove the shortcut from my toolbar because I click it instinctually multiple times a day.
@AaronBertrand yes. i do. he was who, when i expressed concern about the proliferation of SVFs in his code and how the optimizer handled it, retorted, "oh, you mean sql server's magical 'black box?'"
We were allowed to refund money on cases that took 15 min or less to resolve. I however refused to do so if the customer was processionally employed in the field and insufficiently competent.
I figured we shouldn't be the subsidy for hiring incompetent sysadmins, network admins, and dbas....
@ChrisTravers it's not hard to turn the tables and make the call last longer than 15 minutes. For example, if the computer was unplugged, you could detail the intricacies of electricity, modern wiring, etc.
@ChrisTravers PS I'm not talking about the clueless / less experienced. I'm talking about the people who refuse to take sound advice after having enough wits to come to a site that promises exactly that.
I used to work with a guy who would just say "it's broke." Took three or four relays either in e-mail or the ticket system to suss out an actual error message. EVERY TIME.
@Phil no that was a different guy. We had to pull him out of the nightly Exchange backup because all of his uncompressed BMP full-screen screenshots of error dialogs 1/20th of the screen were in his sent items folder and he would never delete a thing and the backups were taking 25 hours.
@FreshPrinceOfSO well then I'm not sure what to tell you. If people want you to get this done, they need to help you get it done. I can't mop the floor if you've locked the mop away.
@Lamak Google would also tell you performant is a word depending on how critical you are of the results. Doesn't mean you wouldn't get laughed at when using it. :-)
@FreshPrinceOfSO: well u may find some people in India like that. They ll sit on top of ur head and ll ask u to do some stuff which they themselves wont be sure how to do it
@AaronBertrand he asked me for driver support help. i did what i could (but i'm in the middle of moving from 2000->2008R2) but then said "take it to SO" :)
@AaronBertrand and then lo and behold ... the question came up with the same error ... then he came over and told me that he had and that someone was giving him a hard time about select * and somesuch
> Posted by aaronbertrand on 8/11/2009 at 4:35 AM In Connect #125347, Microsoft said, "too late for 2005, we will fix for 2008!" Now, "too late for 2008, we'll fix in vNext!" Please consider fixing this in the next release for real.
@ConcernedOfTunbridgeWells I think the major pushback (and I didn't hear this from anyone specifically, and you didn't hear it from me): if you identify a specific value that failed (presumably the "first"), then folks might go fix that value, then wash, rinse, repeat, ad nauseum.
@ConcernedOfTunbridgeWells I'm not saying that's a worse scenario, at least it gives you a place to start, especially if there's really only one value causing the problem.
I am trying to create a sql statement that returns a single record from data over multiple records. In a way, I am trying to concatenate arbitrary selects on the same table as columns to the result set.
The table looks like this, with PK: A, B, C:
A B C D E
----------------------...
Burninate it! It is a stupid question and if he cleans it up enough to suss out some syntax, it will probably require CASE / PIVOT etc. and therefore won't be applicable to mysql, SQL Server and Oracle all at the same time.
It's a terrible question based on a terrible premise and isn't even solvable. He's stated that he doesn't want it solved, he wants a general "how do I approach this kind of problem that I can't even accurately describe" answer. Not useful for the site.
I am trying to create a sql statement that returns a single record from data over multiple records. In a way, I am trying to concatenate arbitrary selects on the same table as columns to the result set.
The table looks like this, with PK: A, B, C:
A B C D E
----------------------...