Jeff Moden

Forum Replies Created

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

RE: Help with SQL algorithm to process transactions

Carl, see attached. Didn't change your logic of how to create the FIFO, just the logic of doing the running totals. Basically, it cuts the time in half...
--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 23, 2009 at 3:28 am

#1013805
RE: A great site like this - but for ORACLE.

Lynn Pettis (6/4/2009)
You could also give sswug.org a try, if you want to pay for membership. They seem to try and cover everything, not just MS SQL Server. ...
--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:31 pm

#1013701
RE: A great site like this - but for ORACLE.

dmbaker (6/10/2009)
You forgot:
5) Access to the site will require a custom-built browser that is arcane, follows no known standards, and is difficult to install, requiring tweaking of hidden system files...
--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:25 pm

#1013698
RE: need help transforming a table's column to rows

WayneS (6/22/2009)
Jeff Moden (6/20/2009)
Heh... they kind of did :hehe: ... take a look at the NUMBER column of Master.dbo.spt_Values where the TYPE = 'P'. I don't believe they ever...
--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:21 pm

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

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