Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,246 through 43,260 (of 59,063 total)

RE: Common questions asked in SQL Server DBA Interview

Brandie Tarvin (6/22/2009)
"Why, no, Sir. We don't be needin' no real-ational database type tool. Just gimmie Lotus 1-2-3 or that thar x-el spreadsheet and I kin give you the best...
--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 22, 2009 at 9:04 am

#1013366
RE: Common questions asked in SQL Server DBA Interview

Michael Valentine Jones (6/22/2009)
Sorry if my irony wasn't thick enough to detect, but just for the record I do think databases should be normalized. :blush:
Heh... I know 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)

June 22, 2009 at 8:56 am

#1013357
RE: Common questions asked in SQL Server DBA Interview

jeffrey yao (6/20/2009)
Michael Valentine Jones (6/18/2009)
Matt Miller (6/18/2009)
..."What is normalization and why is it important?"...
Just say that “normalization” is theoretical nonsense that so-called gurus like Date and Celko throw around...
--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 22, 2009 at 5:52 am

#1013236
RE: Are the posted questions getting worse?

Surprisingly enough, a Cursor would probably be faster than the Triangular Join method of doing the running totals that Carl currently has deployed. Right now, the running total calc...
--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 22, 2009 at 5:26 am

#1013225
RE: Are the posted questions getting worse?

Paul White (6/22/2009)
Did anyone feel the disturbance in the Force when the name Celko was invoked earlier?
Apparently triangular joins are fantastic for running-total or allocation problems!
/sarcasm
Thread Link
There's going...
--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 22, 2009 at 4:03 am

#1013186
RE: Help with SQL algorithm to process transactions

Carl Federl (6/21/2009)
I have some SQL similar to what you are trying to perform for Last In First Out inventory allocation, that may get you started.
The data has four Wharehouse...
--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 22, 2009 at 3:56 am

#1013184
RE: Are the posted questions getting worse?

Paul White (6/21/2009)
** Actually I'm not so sure that this is helpful. All operations are ultimately per-row, but I can sort of see how someone might see a loop...
--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 22, 2009 at 3:32 am

#1013173
RE: Are the posted questions getting worse?

Jeff Moden (6/21/2009)
Paul White (6/21/2009)
Jeff Moden (6/21/2009)
Do you have a link to the post for the "holding variable"? I want to see what you're talking about before I respond...
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 21, 2009 at 8:08 pm

#1013115
RE: Are the posted questions getting worse?

Paul White (6/21/2009)
Jeff Moden (6/21/2009)
Do you have a link to the post for the "holding variable"? I want to see what you're talking about before I respond...
I was 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 21, 2009 at 8:03 pm

#1013114
RE: Multi Company DataBase

Lynn Pettis (6/21/2009)
If not being able to do it causes them financial problems, you (meaning your company) could be involved in litigation.
... not to mention a road trip and 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 21, 2009 at 7:58 pm

#1013113
RE: Going Native

1. At the top of this page, you'll find the words "Control Panel"... click there and it will bring up your profile.
2. Scroll down the almost left 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)

June 21, 2009 at 7:53 pm

#1013112
RE: Multi Company DataBase

PaulB (6/21/2009)
:blink: Let me ask just one question... how are you planing to proceed when one of the customers ask you to restore the database lets say... as it was...
--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 21, 2009 at 4:32 pm

#1013100
RE: Are the posted questions getting worse?

Paul White (6/21/2009)
Set-based loop if better (to my mind) but I guess I still have trouble with having to make a distinction. It's not really any less of 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 21, 2009 at 4:24 pm

#1013096
RE: How do I frame this query

cmrhema (6/21/2009)
Ok I am providing you with sample data
The reason folks as for sample data and direct you to the link that Lutz did is because they like to test...
--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 21, 2009 at 4:11 pm

#1013093
RE: Going Native

Ralf Dietrich (6/21/2009)
Yes I'm completely unhappy with the MPW from a consultant perspective who has to fix countless MPW implementations
Heh... as a consultant, I'd think you'd be happy 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)

June 21, 2009 at 3:40 pm

#1013091

Viewing 15 posts - 43,246 through 43,260 (of 59,063 total)