Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,306 through 43,320 (of 59,102 total)

RE: Help with SQL algorithm to process transactions

lmu92 (6/20/2009)
The problem itself looks like a job for RunningTotals...
I agree... but, I'm gonna sit back and watch someone else do this one.
Edit: "SQL master" disclosure added 😀
Heh... you may...
--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 1:17 pm

#1013067
RE: Help with SQL algorithm to process transactions

Carl Federl (6/21/2009)
Joe Celko has written 2 article on implementing FIFO and LIFO with SQL.
http://www.dbazine.com/ofinterest/oi-articles/celko32
http://www.dbazine.com/ofinterest/oi-articles/celko33
Ack! Before you go using any of those methods, please read about the horrible effect...
--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 1:11 pm

#1013065
RE: Are the posted questions getting worse?

Florian Reischl (6/21/2009)
I'm with you, there are also some real security issues with HTML like this:
Heh... ok... that might be useful for some of the things I'd like to do......
--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 1:03 pm

#1013063
RE: Maintance plan Order

GilaMonster (6/21/2009)
Jeff Moden (6/21/2009)
Just to be clear on another point... it's not the shrinking of a database that causes fragmentation and performance problems. It's the regrowth that causes all...
--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 12:58 pm

#1013061
RE: Grouping problem

WayneS (6/20/2009)
You used: ROW_NUMBER() OVER(ORDER BY Seq)It is producing the same thing as the Seq column by itself. Is there a reason why you went through the trouble to use...
--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 12:42 pm

#1013060
RE: Grouping problem

WayneS (6/20/2009)
Jeff Moden (6/20/2009)
BWAA-HAAA!!!! I felt exactly the same way waiting for the folks at work to do an upgrade (they're still not there). I finally broke down in...
--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 12:41 pm

#1013059
RE: search table design

I'm not so sure that you need a separate server for this. A separate database may be well enough. It's similar to having a regular database 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 12:39 pm

#1013058
RE: Scalar UDF Performance Issue

tfifield (6/21/2009)
Jeff,
Thanks for your time and full test. You do a fine job of myth busting. I've used your reference on SELECT INTO #Temp not actually locking sysobjects...
--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 12:15 pm

#1013056
RE: Scalar UDF Performance Issue

Paul White (6/21/2009)
Jeff Moden (6/21/2009)
Heh... well done, Paul. You should have written the article. Thanks for taking the time.
Wow- coming from you that's awesome!
And you're welcome, of...
--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 12:00 pm

#1013055
RE: Maintance plan Order

Jeff Moden (6/21/2009)
Just to be clear on another point... it's not the shrinking of a database that causes fragmentation and performance problems. It's the regrowth that causes all of...
--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 11:20 am

#1013052
RE: Maintance plan Order

Just to be clear on another point... it's not the shrinking of a database that causes fragmentation and performance problems. It's the regrowth that causes all of 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)

June 21, 2009 at 11:16 am

#1013051
RE: Are the posted questions getting worse?

Jeez... here's something I absolutely hate to see...
http://www.sqlservercentral.com/Forums/Topic738870-361-1.aspx
I suppose it's because people just don't know enough about databases to know better than to think they can just jump in and...
--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 10:50 am

#1013049
RE: Are the posted questions getting worse?

Paul White (6/21/2009)
Jeff Moden (6/20/2009)
Oh yeah... now I remember. One column needed to be split (a portion isolated, really) from the middle.
Fascinating thread. I just spent the 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)

June 21, 2009 at 10:42 am

#1013047
RE: Are the posted questions getting worse?

Florian Reischl (6/21/2009)
Do you use any clipboard manager tool?
No and that's a major part of my point... if you copy and paste into SSMS from the good code example 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 10:32 am

#1013045
RE: Multi Company DataBase

Gosh... there's just no way to say this without ticking someone off. My apologies in advance....
This doesn't sound like a trivial undertaking. It sounds like this database 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 21, 2009 at 10:20 am

#1013043

Viewing 15 posts - 43,306 through 43,320 (of 59,102 total)