Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,816 through 7,830 (of 59,098 total)

Reply To: Surrender, Just a Little

I agree... I hate the "blame game". That's why I get pissed off when people, who frequently don't know much about databases, blame the DBA for being a supposed bottle-neck...
--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)

February 3, 2020 at 2:59 pm

#3722620
Reply To: Surrender, Just a Little

I absolutely agree that cooperation leads to learning. That's why I sit with the Developers and have a symbiosis with them. Cooperation does not mean letting bad stuff happen 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)

February 3, 2020 at 2:00 pm

#3722597
Reply To: Recruitment question

My favorite IT related job posting of all time was also the shortest, most honest, and most accurate one I've ever seen...
HELP WANTED
"Basically, we want someone that can look at...
--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)

February 2, 2020 at 8:37 pm

#3722430
Reply To: Surrender, Just a Little

GeorgeCopeland wrote:
Grant Fritchey wrote:
When the business overrides you, there really isn't much you can do. Education is key. However, I'm still very much on the side of being part of the...
--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)

February 1, 2020 at 3:16 am

#3722196
Reply To: Surrender, Just a Little

oogibah wrote:
GeorgeCopeland wrote:
Maybe you are right but I think there is also a cultural issue. A good default pose for a developer might be as a collaborator who wants data to...
--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)

January 31, 2020 at 10:57 pm

#3722178
Reply To: Scientific number in varchar column

Phil Parkin wrote:
MVDBA (Mike Vessey) wrote:
sigh... my heart dies a little bit when we ignore the option of getting a provider of data to make it useable , I know they are often...
--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)

January 31, 2020 at 3:39 pm

#3722059
Reply To: Scientific number in varchar column

GrassHopper wrote:
Jeff, that would be the best case scenario, but we get many clients that give to us as is and don't want to do more. It is in excel...
--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)

January 31, 2020 at 3:36 pm

#3722057
Reply To: Parallel Load thousands csv Files

Thanks, Nicole. I'm sorry I missed this yesterday and today. I'm prepping for an SQL|Saturday that I'm driving to tomorrow and won't be back until Sunday. I'll give it 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)

January 31, 2020 at 4:07 am

#3721874
Reply To: Slow running "ranking" problem

jcelko212 32090 wrote:
To add to what Jeff said, it's really not that hard to write a bunch of stored procedures for the nested set model. I published a few of these...
--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)

January 31, 2020 at 4:00 am

#3721871
Reply To: Scientific number in varchar column

What you really need to do is get with the people that are providing the data and have them give it to you correctly. Having some number like 9.38357E+27 isn't...
--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)

January 31, 2020 at 3:38 am

#3721869
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
jonathan.crawford wrote:
But have either of you ever been to Belgium?
Let's just say, mussels, mayo on fries and a tripel is one of my favorite meals on the planet.
Mayo on...
--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)

January 31, 2020 at 2:59 am

#3721852
Reply To: Are the posted questions getting worse?

Phil Parkin wrote:
Following on with the food and music theme. To be sung to the tune of Queen's Bohemian Rhapsody ... it's the Indian version. (Not my work.)
That's hil-air-e-ass!!!
--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)

January 31, 2020 at 2:03 am

#3721851
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
Ed Wagner wrote:
One day, we'll have to have a meeting of that Anti-RBAR Confederation you spoke about. We'll schedule time to talk about food. 🙂
We shouldn't schedule time to talk...
--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)

January 31, 2020 at 1:58 am

#3721846
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
without gail, steve and joe celko busting my chops then i'm left with jeff….. not fair.
Heh... it's what brothers 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)

January 31, 2020 at 1:56 am

#3721845
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
Let's just say, mussels, mayo on fries and a tripel is one of my favorite meals on the planet.
MVDBA (Mike Vessey) wrote:
Grant Fritchey wrote:
MVDBA (Mike Vessey) wrote:
(and PS Grant, you are our long lost...
--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)

January 31, 2020 at 1:12 am

#3721841

Viewing 15 posts - 7,816 through 7,830 (of 59,098 total)