Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,991 through 22,005 (of 59,098 total)

RE: how to answer interview question "what is the hardest sproc you have created?"

Stephanie Giovannini (1/9/2015)
Jeff, thank you for the interview lead-in question about the current date--I am totally taking that!
I've been doing phone technical interviews for database developers. My first technical...
--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)

January 9, 2015 at 12:21 pm

#1769172
RE: CHOOSE() a RAND() vowel not working???

I personally don't know of any programming language that actually has a true random number generator function. That's not to say that there isn't one but I don't know...
--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)

January 9, 2015 at 12:14 pm

#1769169
RE: CHOOSE() a RAND() vowel not working???

Eirikur Eiriksson (1/9/2015)
My thought is that some of the random function implementations in SQL Server are more caused by the limitations of this particular function ( RAND() ) rather than...
--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)

January 9, 2015 at 11:36 am

#1769160
RE: Randomize customer names in test db

dmcnair1881 (1/9/2015)
I apologize, but right after I posted for help, I realized how dumb I was being in trying to do everything through the SSIS script components when I could...
--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)

January 9, 2015 at 11:32 am

#1769159
RE: Randomize customer names in test db

dmcnair1881 (1/9/2015)
I am currently trying to use SSIS to create a copy of a production database, rename it, and randomize customer information inside the customer table (first name and last...
--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)

January 9, 2015 at 10:38 am

#1769151
RE: User Group in Windows Level

mohan.bndr (1/9/2015)
I would like to know that What user group(s) can be created in windows level after SQL Server has installed....
Please help me out here.:-)
Thanks in advance.
If you're talking about...
--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)

January 9, 2015 at 8:46 am

#1769117
RE: CHOOSE() a RAND() vowel not working???

That's cool. Thanks, Eirikur. Since I usually don't look at anything but the Compute Scalar for such things, the TOP 1 trick is easier for me simply...
--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)

January 9, 2015 at 8:35 am

#1769111
RE: how to answer interview question "what is the hardest sproc you have created?"

I absolutely agree. A phone interview would be wonderful and every candidate is phone-interviewed first. The problem is that the people doing the phone interviews on our side...
--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)

January 9, 2015 at 8:29 am

#1769109
RE: Deployment Concept

KGJ-Dev (1/9/2015)
Hi Jeff,
thank you so much for your precious time on this post. You two systems we need for this. Does it mean two sql instances and one two application...
--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)

January 9, 2015 at 8:21 am

#1769104
RE: how to answer interview question "what is the hardest sproc you have created?"

Chris Wooding (1/9/2015)
As an antidote to Jeff's quick interview technique; the shortest one I ever had was for a contract position. My backside had barely touched the chair when 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)

January 9, 2015 at 7:34 am

#1769083
RE: CHOOSE() a RAND() vowel not working???

Phil Parkin (1/9/2015)
Thank you Jeff, that is an outstandingly good explanation.
Thanks also for the TOP (n) trick to force the generation of a query plan. I wish I'd known that...
--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)

January 9, 2015 at 7:20 am

#1769073
RE: CHOOSE() a RAND() vowel not working???

Phil Parkin (1/7/2015)
If something is non-deterministic, then it's very possible for the re-evaluations of the object test to miss all of the WHEN's and produce a NULL if there...
--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)

January 8, 2015 at 10:00 pm

#1768957
RE: Deployment Concept

Unless you have two systems where you can turn one off, deploy to it, and then do a switch to deploy to the other system, there's no guarantee that you...
--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)

January 8, 2015 at 7:44 pm

#1768950
RE: how to answer interview question "what is the hardest sproc you have created?"

dwain.c (1/8/2015)
Luis Cazares (1/8/2015)
Maddave (1/8/2015)
Jeff Moden (1/8/2015)
Now, based on what I just said, one of my first questions on an SQL Server technical interview for DBAs and Developers alike is...
--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)

January 8, 2015 at 5:41 pm

#1768935
RE: how to answer interview question "what is the hardest sproc you have created?"

ScottPletcher (1/8/2015)
Jeff Moden (1/8/2015)
Now, based on what I just said, one of my first questions on an SQL Server technical interview for DBAs and Developers alike is "How do you...
--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)

January 8, 2015 at 4:04 pm

#1768924

Viewing 15 posts - 21,991 through 22,005 (of 59,098 total)