Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,086 through 5,100 (of 59,072 total)

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
Reply To: Evaluting a DBA

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: Evaluting a DBA

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
Reply To: Does Every BEGIN require an END
Jeffrey Williams wrote:
Here are a couple more that won't have a corresponding END.
BEGIN CONVERSATION TIMER;
BEGIN DIALOG CONVERSATION;
BEGIN DISTRIBUTED TRANSACTION;
Just curious... have you actually ever used any of those?
--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 17, 2021 at 11:13 pm

#3897768
Reply To: table script to dump to csv with foreign key order

Bruin wrote:
I have used that before.. but was looking for something that would dump tables in order with foreign key reference in mind, so I could pickup this file 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 17, 2021 at 9:33 pm

#3897744
Reply To: ALTER VIEW permissions

If this is to be done on a Prod box, I wouldn't. If this is to be done on a Dev box, my question would be, why don't they already...
--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 17, 2021 at 9:18 pm

#3897739
Reply To: Pivot table syntax (?) issue

If you're using PIVOT, you should have posted the code anyway... there is a method that usually better than PIVOT.
--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 17, 2021 at 9:10 pm

#3897737

Viewing 15 posts - 5,086 through 5,100 (of 59,072 total)