Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,961 through 21,975 (of 59,072 total)

RE: How to buffer more data for longer time

Bill Talada (1/8/2015)
I have a customer with awful disk throughput but lots of memory on the host. I understand data pages are aged out of cache after five minutes....
--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 10, 2015 at 6:52 am

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

Grant Fritchey (1/9/2015)
Jeff Moden (1/9/2015)
Brandie Tarvin (1/9/2015)
I've been through 5 managers...
BWAAAA-HAAAAA-HAAAA!!!! You must be tough on managers! :-D:-P
I'm finishing up my fourth year at Redgate and I'm on my...
--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 10, 2015 at 6:20 am

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

Have you seen Dwain C's article on the generation of random sets?
--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:51 pm

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

Brandie Tarvin (1/9/2015)
I've been through 5 managers...
BWAAAA-HAAAAA-HAAAA!!!! You must be tough on managers! :-D:-P
--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:45 pm

#1769178
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

Viewing 15 posts - 21,961 through 21,975 (of 59,072 total)