Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,116 through 5,130 (of 59,101 total)

Reply To: Evaluating a DBA (or AI)

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: Evaluating a DBA (or AI)

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: Evaluating a DBA (or AI)

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: Evaluating a DBA (or AI)

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: Evaluating a DBA (or AI)

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: Evaluating a DBA (or AI)

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: Evaluating a DBA (or AI)

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: Evaluating a DBA (or AI)

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: Evaluating a DBA (or AI)
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: Evaluating a DBA (or AI)

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
Reply To: Evaluating a DBA (or AI)

Heh... I'll give you another one... I interviewed a guy that claimed to be an expert at tuning SQL and T-SQL. I asked him what a clustered index was and...
--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:48 am

#3897851
Reply To: Evaluating a DBA (or AI)

Heh... so a DBA doesn't need to know what a Clustered Index is???
Sorry... Unless you're trying to hire a TRUE SYSTEM ONLY DBA, I find that laughable and even a...
--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:31 am

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

Jeffrey Williams wrote:
ScottPletcher wrote:
Why? If what you're saying is true, then just use the first char in the value as the category, that's less overhead than any kind of table lookup.
Because...
--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 12:10 am

#3897779

Viewing 15 posts - 5,116 through 5,130 (of 59,101 total)