Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,036 through 7,050 (of 59,091 total)

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
Reply To: Subqueries that return one value vs. multiple values

On that note, Paul White wrote some great articles on both. You can find them below...
https://www.sqlservercentral.com/articles/understanding-and-using-apply-part-1
https://www.sqlservercentral.com/articles/understanding-and-using-apply-part-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)

May 25, 2020 at 1:44 am

#3757156
Reply To: TRY_CONVERT( ) returning a NULL vs. returning an error

Good Sir... thank you for taking it the right way. A lot of people would have taken it all offensively. You DO have the right stuff, Michael.

--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 1:27 am

#3757153
Reply To: SQL Server browser service question

I can't speak for what others know of the subject but we always disable the browser service to enhance security.
--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 24, 2020 at 5:09 pm

#3757117
Reply To: The Life List

Heh... not enough coffee... when I first read the title of this article, I thought it said "The Wife List", which is a huge part of "The Life List".
--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 24, 2020 at 2:39 pm

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

Doing things at the database level isn't necessarily doing the same as doing something at the server level. I strongly recommend that you try TF 9481 at the server level...
--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 23, 2020 at 7:13 pm

#3757043
Reply To: Subqueries that return one value vs. multiple values

Again... teaching a man to fish. 😀
If you do a search for "subqueries in sql server" and look for the "Microsoft Docs" (BOL) entry in the returns, you'll end up...
--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 23, 2020 at 6:44 pm

#3757040

Viewing 15 posts - 7,036 through 7,050 (of 59,091 total)