Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,276 through 43,290 (of 59,098 total)

RE: Common questions asked in SQL Server DBA Interview

Brandie Tarvin (6/22/2009)
Jeff Moden (6/22/2009)
Heh... "Log shipping" = "hauling lumber" 😛
Oh, the agony! Oh, the pain!
Oh, I wonder how many more of these we can come up with... We 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)

June 22, 2009 at 10:56 am

#1013460
RE: Which is better

Lynn Pettis (6/22/2009)
Eswin (6/18/2009)
Hi Expertz
Performance wise Which is better
...
And please provide me a good cursor example (ie optimized cursor eexample).
Isn't this, optimized cursor an oxymoron?? 😉
Heh... more like 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 22, 2009 at 10:15 am

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

Heh... "Log shipping" = "hauling lumber" 😛
--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 10:11 am

#1013424
RE: Multi Company DataBase

nalmir.hugo (6/22/2009)
First of all, thanks for Lynn Pettis,Jeff Moden,PaulB,ps,WayneS for your comments. All the points stressed out here are very important. As Jeff said, this is not a simple question...
--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:16 am

#1013379
RE: Help with SQL algorithm to process transactions

Carl Federl (6/22/2009)
Do you know of any side-effect of creating tally in master ?
Yep... other people see it and think it's ok. Sometimes, ya just gotta set the example.
--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:11 am

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

Viewing 15 posts - 43,276 through 43,290 (of 59,098 total)