Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,101 through 5,115 (of 59,089 total)

Reply To: Evaluting a DBA

David.Poole wrote:
will 58232 wrote:
Anyone yet to take me up on explaining why a relational DBMS is called "relational"? It's a pretty fundamental question for a DBA.
Dr Codd described a relation in...
--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)

June 19, 2021 at 3:42 am

#3898228
Reply To: How to break zipcodes fileds with leading zeros

Dunno if it helps or not but I do agree that this specific thing smells fishy to begin with. And I wouldn't make the table... I would force someone else...
--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)

June 19, 2021 at 3:39 am

#3898227
Reply To: How to break zipcodes fileds with leading zeros

ScottPletcher wrote:
And I still say you need business input before deciding on what to put in any table you create. I don't think you can properly model the data until...
--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)

June 18, 2021 at 7:45 pm

#3898150
Reply To: Evaluting a DBA

will 58232 wrote:
It just because data is related to other data.
Codd called his invention relational because it is based on the mathematical construct of a relation. This represents a relation between...
--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)

June 18, 2021 at 7:34 pm

#3898149
Reply To: Evaluting a DBA

will 58232 wrote:
Anyone yet to take me up on explaining why a relational DBMS is called "relational"? It's a pretty fundamental question for a DBA.
It just because data is related to...
--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)

June 18, 2021 at 6:39 pm

#3898115
Reply To: Evaluting a DBA

ZZartin wrote:
will 58232 wrote:
would you actually want to hire someone that claims to know T-SQL if you ask them how to get the current date and time using T-SQL and they...
--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)

June 18, 2021 at 6:30 pm

#3898110
Reply To: Reading multiple audit files

mtz676 wrote:
No more an issue
So, how did you fix it? What did you do?
--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)

June 18, 2021 at 5:40 pm

#3898097
Reply To: Evaluting a DBA

Steve Jones - SSC Editor wrote:
I don't like the "what's a clustered index?" or other trivia questions. Not because the knowledge isn't important, but it wastes time. As Eric noted, I want to ask...
--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)

June 18, 2021 at 5:26 pm

#3898085
Reply To: Evaluting a DBA

If you want to have some fun with a Performance Tuning "Expert", provide them with the following questions... (there's more... these are a bit more advanced that "What's a Clustered...
--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)

June 18, 2021 at 5:01 pm

#3898077
Reply To: Evaluting a DBA

ZZartin wrote:
Eric M Russell wrote:
Jeff Moden wrote:
Developers routinely look to the DBA for advice about data modeling (often times after it's been deployed to production), but I don't get questions on the job...
--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)

June 18, 2021 at 4:51 pm

#3898075
Reply To: Evaluting a DBA

Eric M Russell wrote:
Jeff, before I even clicked on the comments, I knew you'd be here with GETDATE(). 🙂
Heh.. I certainly have cut the rug for that one. 😀
Eric M Russell wrote:
The way I...
--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)

June 18, 2021 at 3:48 pm

#3898049
Reply To: Evaluting a DBA

will 58232 wrote:
Ask someone if they know why an RDBMS is called relational.
The majority of candidates will give the wrong answer. This doesn't mean they should be rejected - they just...
--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)

June 18, 2021 at 3:41 pm

#3898047
Reply To: Evaluting a DBA
David.Poole wrote:
If I was looking for a lead DBA beyond the technical experience I would be looking for someone who
- Keeps calm under pressure
- Is good at explaining things to...
--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)
June 18, 2021 at 3:38 pm

#3898046
Reply To: Evaluting a DBA

joe.lebaron wrote:
David.Poole wrote:
...
It reminds me of when I was interviewing someone who had a Phd in Mathematics (and I DID verify that). You might think that someone applying for the...
--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)

June 18, 2021 at 3:33 pm

#3898043
Reply To: Does Every BEGIN require an END

K. Thanks for the feedback. Me neither, for the record.
--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)

June 18, 2021 at 5:53 am

#3897852

Viewing 15 posts - 5,101 through 5,115 (of 59,089 total)