Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,006 through 7,020 (of 59,072 total)

Reply To: I need to delete a duplicate line

pietlinden wrote:
I need to delete the rows where status = 1
DELETE
FROM TestPO
WHERE Status=1;
?
From your description, it's not at all clear what records you really want deleted. Which record(s) are duplicates?...
--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)

May 27, 2020 at 2:12 am

#3757596
Reply To: Index Maintenance

Lowell wrote:
well i remember a time where we used to provide scripts, and then an explanation of what not to do....
Ah, lordy... be careful, Lowell...
It's not that I don't want...
--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)

May 26, 2020 at 11:44 pm

#3757570
Reply To: Index Maintenance

Sorry, Brian... I don't know if that came out the wrong way but, to be sure, I didn't mean to make it sound like I was talking about you specifically. ...
--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)

May 26, 2020 at 8:01 pm

#3757526
Reply To: Index Maintenance

My take on this is that if you have to ask for scripts to do this, you're probably not qualified to use the scripts. I don't mean that as 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)

May 26, 2020 at 6:23 pm

#3757507
Reply To: EF Code-First

You should write an article on it and submit it.

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

May 26, 2020 at 4:39 pm

#3757487
Reply To: sys.dm_db_file_space_usage

DBAless wrote:
Yes, that's what I've seen on the internet. But I don't believe I have that much space in reality. To convert to GB you would divide by 256, right?
No. ...
--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)

May 26, 2020 at 4:35 pm

#3757486
Reply To: Index Maintenance

Please give Yabingooducklehoo a shot. 😉

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

May 26, 2020 at 4:28 pm

#3757482
Reply To: Bulk Insert & link relationship between inserted row

I know this post is a bit old but...
There's nothing in Table A to absolutely guarantee the correct order of data... that also means there's not going to be anything...
--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)

May 26, 2020 at 2:36 pm

#3757445
Reply To: High sensitivity of SQL server 2016 to statistics ?

Grant Fritchey wrote:
Sometimes the ultimate fix is a rewrite of the queries to a more optimal pattern.
Totally agreed... sometimes, it's the only fix.
--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)

May 26, 2020 at 1:53 pm

#3757422
Reply To: Building Better Software for Everyone

Doctor Who 2 wrote:
The last 5 or so years I've become very interested in UI/UX. In fact I subscribe to at least two newsletters about it. What's surprised me, a great deal,...
--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)

May 26, 2020 at 1:18 am

#3757306
Reply To: Building Better Software for Everyone

Heh... you spelled it incorrectly, David... it's not "shiny". Replace the "n" to get the true meaning. 😀
--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)

May 25, 2020 at 10:04 pm

#3757293
Reply To: SSIS Export Flat File as Fixed Width

Might have even been a "Line#" column so you could verify that no lines were lost during transmission and to also guarantee a sort order if that was important 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)

May 25, 2020 at 6:06 pm

#3757276
Reply To: SSIS Export Flat File as Fixed Width

Just as a side bar, I generally don't mix meta data (headers/footers/line counts, whatever) in fixed field format files simply because most people on the receiving end have problems dealing...
--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)

May 25, 2020 at 4:25 pm

#3757259
Reply To: SSIS Export Flat File as Fixed Width

I agree with Phil. Headings longer than the column width of a fixed field format file just aren't going to work. For such files, folks usually don't include a header...
--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)

May 25, 2020 at 3:46 pm

#3757248
Reply To: Building Better Software for Everyone

While I agree that "Perfection can be the worst enemy of good", I've found that "Change is the worst enemy yet". I have found that way too many people change...
--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)

May 25, 2020 at 3:09 pm

#3757237

Viewing 15 posts - 7,006 through 7,020 (of 59,072 total)