Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,216 through 7,230 (of 59,102 total)

Reply To: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

Ah... so you meant a REFERENCES clause in a bit of DRI. Understood. I wasn't getting that from your post.
As attractive to some as it is, I'm not likely 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)

April 29, 2020 at 7:26 pm

#3747444
Reply To: Have txt/csv files, but header need to find from which row it will start

You've provided one example file. Could you provide a couple more that represent some of the other files that have different delimiters, etc?
Also, how many "columns" do these files generally...
--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)

April 29, 2020 at 2:47 pm

#3747327
Reply To: Keeping Unique Aliases

David.Poole wrote:
Let's face it standards articles and forums are coke and mentoes
Heh... you said a mouthful. 😀

--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)

April 28, 2020 at 11:59 pm

#3747170
Reply To: How to skip duplicate record and keep on running until the end?

adonetok wrote:
I tried Phil Parkin's way, it is working now.
Thank all of you.
Cool. Thanks for the feedback. To be sure, though, do you understand how and why Phil's good code...
--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)

April 28, 2020 at 2:46 pm

#3747016
Reply To: Keeping Unique Aliases

Tom_Hogan wrote:
Jeff Moden wrote:
Totally agreed about the usefulness of standards but I have to say that bad standards are as bad and sometimes worsen than no standards.
Not to detail the thread,...
--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)

April 28, 2020 at 2:40 pm

#3747015
Reply To: Keeping Unique Aliases

Totally agreed about the usefulness of standards but I have to say that bad standards are as bad and sometimes worsen than no standards.
--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)

April 28, 2020 at 4:33 am

#3746880
Reply To: How to skip duplicate record and keep on running until the end?

adonetok wrote:
I set up primary key on email column.
I want to void inserting any duplicate record in email column.
That creates an index. If you modify that index to include 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)

April 28, 2020 at 4:19 am

#3746871
Reply To: Cannot extract Filename from Filepath using GetFileName in C#

Cool. Thanks for the info, Jeffrey. You should write an article on this stuff. I think it would be a big help to folks that use SSIS, especially people 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)

April 27, 2020 at 10:48 pm

#3746838
Reply To: Slow Trigger performance when big batches

Getting back to your original problem... I think that a large part of the pain you're going through is that the inclusion of which "fields" changed in the VARCHAR(MAX) constitutes...
--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)

April 27, 2020 at 9:11 pm

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

Heh... let the silliness continue. I just got an email saying...
KILL 99.9% OF BACTERIA & HARMFUL MICROBES
FORMS A PROTECTIVE SHIELD THAT DELAYS GROWTH OF HARMFUL MICROBES ON INTERIOR SURFACES
Reg $129.95
2...
--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)

April 27, 2020 at 8:55 pm

#3746800
Reply To: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

There is no hierarchical REFERENCES clause in SQL Server. If that's not what you meant, the only other thing that I can think of is some form of DRI 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)

April 27, 2020 at 8:47 pm

#3746798
Reply To: Slow Trigger performance when big batches

jcelko212 32090 wrote:
I've always felt that it was worth it to pay for a second audit tool that is external to the database. Auditing in the same database mixes both data...
--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)

April 27, 2020 at 8:44 pm

#3746797
Reply To: Cannot extract Filename from Filepath using GetFileName in C#

If you go back and read it, I wasn't suggesting going to SQL Server to do it. I said that there has to be a way in the language 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)

April 27, 2020 at 8:32 pm

#3746795
Reply To: EF Code-First

Steve Collins wrote:
Jeff Moden wrote:
I'm talking about people using the front end designers to create tables. Some people do it right but, for the most part, it's done by people that have...
--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)

April 27, 2020 at 8:24 pm

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

jasona.work wrote:
(Gets ready for Jeff to begin his comments about the "cloud")
There is no umbrella big enough or strong enough to protect anyone from such a s**t storm as 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)

April 27, 2020 at 8:21 pm

#3746792

Viewing 15 posts - 7,216 through 7,230 (of 59,102 total)