Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,801 through 7,815 (of 59,072 total)

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
Reply To: Surrender, Just a Little

Chris Harshman wrote:
GeorgeCopeland wrote:
...I am convinced that this is a personality type issue. Really good DBAs almost always have this very annoying attitude. Members of the development team--something very different from...
--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 30, 2020 at 5:02 pm

#3721693
Reply To: Surrender, Just a Little

Grant Fritchey wrote:
I would like to defend myself, just a little. I didn't say surrender completely. I said, surrender, just a little. A lot of our peers see our rants 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)

January 30, 2020 at 4:15 pm

#3721677
Reply To: Surrender, Just a Little

I agree, David. In fact, IIRC, I believe it was you I quoted about being an Exceptional DBA. Something like "When it comes to database problems, if you are 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)

January 30, 2020 at 8:22 am

#3721495
Reply To: Surrender, Just a Little

Man! You are so right! This is going to be totally liberating for me!
To commemorate my new found joyous method for doing my job without being a bottleneck, I've...
--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 30, 2020 at 5:19 am

#3721464
Reply To: COHESITY for Backup/Restore?

Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove it's a regular...
--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 30, 2020 at 12:10 am

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

To add to what Grant has stated, I agree that "new" voices are a bonus on any forum but I have seen some "new" people come in with some answers...
--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 29, 2020 at 11:58 pm

#3721417
Reply To: Parallel Load thousands csv Files

info 58414 wrote:
Hi Jeff,
1. How many "records" does each file have. An average will be fine.
=> about 2000 per File
2. You said previously that all of the files are formatted 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)

January 29, 2020 at 4:24 pm

#3721279
Reply To: View runs slower

sathwik.em91 wrote:
Could someone recommend me how to make the query faster?
Yes, but we need more information. Please Read'n'Heed the article at the second link in my signature line below for...
--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 29, 2020 at 4:09 pm

#3721274
Reply To: Parallel Load thousands csv Files

info 58414 wrote:
Hi,
thank you for this Informations!
At night, the flat files from around 500 customers arrive on an FTP - Step by Step. The SSIS job currently starts at 08:00 AM...
--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 28, 2020 at 8:57 pm

#3721011
Reply To: Slow running "ranking" problem

Heh... it's funny. I was going to suggest the same things about the method I use. I maintain the adjacency list (with a detector to prevent loops) and regen 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)

January 28, 2020 at 2:40 pm

#3720929
Reply To: Parallel Load thousands csv Files

I'm one of those folks that Phil is speaking of. He's correct about BCP but BULK INSERT is the fastest and, done correctly, it's nasty fast. A BCP format file...
--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 28, 2020 at 2:24 pm

#3720926

Viewing 15 posts - 7,801 through 7,815 (of 59,072 total)