Are the posted questions getting worse?
- Eirikur Eiriksson wrote:Jeff Moden wrote:Eirikur Eiriksson wrote:
Gents, you can do better than that!
😎
Now think inside your (tool)box!
Heh... lordy. You need to use the tool to spell the tool...
SELECT CONCAT(CHAR(838176/10000),CHAR(838176/100%100),CHAR(838176%100));
--===== Or, if you want to do it all auto-magically
DECLARE @Value INT = 838176;
SELECT REVERSE(STRING_AGG(CHAR(@Value/POWER(10,t.N*2)%100),''))
FROM dbo.fnTally(0,CEILING(LOG(@Value)/LOG(10))/2-1) t
;Kind of obvious isn't it 😉
😎
Once the last vestiges of the day's supply of caffeine tried one final and almost unsuccessful time to energize my brain, yes. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden wrote:Eirikur Eiriksson wrote:Jeff Moden wrote:Eirikur Eiriksson wrote:
Gents, you can do better than that!
😎
Now think inside your (tool)box!
Heh... lordy. You need to use the tool to spell the tool...
SELECT CONCAT(CHAR(838176/10000),CHAR(838176/100%100),CHAR(838176%100));
--===== Or, if you want to do it all auto-magically
DECLARE @Value INT = 838176;
SELECT REVERSE(STRING_AGG(CHAR(@Value/POWER(10,t.N*2)%100),''))
FROM dbo.fnTally(0,CEILING(LOG(@Value)/LOG(10))/2-1) t
;Kind of obvious isn't it 😉
😎
Once the last vestiges of the day's supply of caffeine tried one final and almost unsuccessful time to energize my brain, yes. 😀
And here I was thinking that
0x383338313736
8 3 8 1 7 6was far too obvious of a hint
😎
- Eirikur Eiriksson wrote:
And here I was thinking that
0x383338313736
8 3 8 1 7 6was far too obvious of a hint
😎
It absolutely was obvious... it just couldn't find a target in my brain because there was no caffeine to hit. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
On the same note, you're not yet told me what you think the 3|8 number means in the life of a DBA. My hint would be "It Depends" on how you look at it. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden wrote:
On the same note, you're not yet told me what you think the 3|8 number means in the life of a DBA. My hint would be "It Depends" on how you look at it. 😀
I should remember this as you've told me this before, the problem is that my memory is as leaky as an old coffee filter.
😎
The first thought is that 3 OR 8, the number of normal DBA duties. The second one is 3 times 8, the number of hours per day that the DBA is expected to perform those duties. The third one is 3 divided by 8 (times 1000), roughly the number of days in a year that the DBA must do his job. The last one is 3 in the 8th power, roughly what the DBA should be paid per hour 😉
Further on the first thought:
1. Software installation and Maintenance
2. Data Extraction, Transformation, and Loading
3. Specialised Data Handling
4. Database Backup and Recovery
5. Security
6. Authentication
7. Capacity Planning
8. Performance Monitoring
9. Database Tuning
10. Troubleshooting
11. Education, education, education
-
Good luck, Lynn, Hope you find something.
- Eirikur Eiriksson wrote:Jeff Moden wrote:
On the same note, you're not yet told me what you think the 3|8 number means in the life of a DBA. My hint would be "It Depends" on how you look at it. 😀
I should remember this as you've told me this before, the problem is that my memory is as leaky as an old coffee filter.
😎
The first thought is that 3 OR 8, the number of normal DBA duties. The second one is 3 times 8, the number of hours per day that the DBA is expected to perform those duties. The third one is 3 divided by 8 (times 1000), roughly the number of days in a year that the DBA must do his job. The last one is 3 in the 8th power, roughly what the DBA should be paid per hour 😉
Further on the first thought:
1. Software installation and Maintenance
2. Data Extraction, Transformation, and Loading
3. Specialised Data Handling
4. Database Backup and Recovery
5. Security
6. Authentication
7. Capacity Planning
8. Performance Monitoring
9. Database Tuning
10. Troubleshooting
11. Education, education, education
All great thoughts but that's not it. Remember the hint was "It Depends on how you look at it". Look at it like this and with the understanding that it's not actually a number but a glyph...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden wrote:Eirikur Eiriksson wrote:Jeff Moden wrote:
On the same note, you're not yet told me what you think the 3|8 number means in the life of a DBA. My hint would be "It Depends" on how you look at it. 😀
I should remember this as you've told me this before, the problem is that my memory is as leaky as an old coffee filter.
😎
The first thought is that 3 OR 8, the number of normal DBA duties. The second one is 3 times 8, the number of hours per day that the DBA is expected to perform those duties. The third one is 3 divided by 8 (times 1000), roughly the number of days in a year that the DBA must do his job. The last one is 3 in the 8th power, roughly what the DBA should be paid per hour 😉
Further on the first thought:
1. Software installation and Maintenance
2. Data Extraction, Transformation, and Loading
3. Specialised Data Handling
4. Database Backup and Recovery
5. Security
6. Authentication
7. Capacity Planning
8. Performance Monitoring
9. Database Tuning
10. Troubleshooting
11. Education, education, education
All great thoughts but that's not it. Remember the hint was "It Depends on how you look at it". Look at it like this and with the understanding that it's not actually a number but a glyph...
Work over infinity, Jeff, you will have to elaborate further on this one 😉
😎
- Eirikur Eiriksson wrote:
I thought, baggy eyes, toothless grin and a double chin.
Far away is close at hand in the images of elsewhere.
Anon. -
It's a half eaten pretzel balanced on top of 2 rolls of toilet paper. Not the worst ERD I've seen!
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
-
Now Steve, you just made me spill my coffee!
😎
-
Heh... all good guesses but... nope.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
If the symbols were the other way around it could be a graphic of a euphemism for falling over.
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
Ok... one final set of hints...
If something goes wrong, they call the DBA and that's 24/7/365.
They also blame the DBA and the database for everything until the DBA can prove otherwise.
The top symbol is a body part that both men and women have. The thing that looks like a horizontal line is just exactly that.
And, of course the bottom symbol is the sign of infinity. There's a 7 letter word that begins with "F" that also means "infinity".
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 15 posts - 65,071 through 65,085 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply