Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,291 through 43,305 (of 59,098 total)

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
RE: Any Utility available to convert Sql Server Stored Procedures into user defined functions

The only suggestion I have isn't the one they want to hear. Don't do the conversions.
--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:15 pm

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

:blush::-)
--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 2:44 pm

#1013080
RE: Are the posted questions getting worse?

lmu92 (6/21/2009)
"BBO-Quatsch"
BWAA-HAAA-HAAA!!!! When I first saw that, I thought, "BBQ Sasquatch - the ultimate pork chop!"
--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 2:36 pm

#1013079
RE: Are the posted questions getting worse?

I absolutely have to laugh everytime I see something like the following:
http://www.sqlservercentral.com/Forums/Topic735302-147-1.aspx
What's up with that? I thought all this GUI garbage was supposed to make life easier for people...
--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:39 pm

#1013071
RE: Are the posted questions getting worse?

Florian Reischl (6/21/2009)
You can quote my post to see the magic,...
Heh... of course! More coffee please! 😛 Thanks Flo.
--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:35 pm

#1013070
RE: Normalizing and loading data from csv data file

Does it HAVE to be done in SSIS?
--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:29 pm

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

Viewing 15 posts - 43,291 through 43,305 (of 59,098 total)