Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 59,082 total)

Reply To: Data Problem

Ok... first off, your column naming structure flat out isn't going to work. It's a worst practice to include spaces in any object names including column names.
Second, if you 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)

March 21, 2023 at 3:28 pm

#4163335
Reply To: Decoding Set Options

Heh... I'm thinking about Left_Shift() and Right_Shift() (I always knew them as Shift-Left and Shift_right in the old days). I can see that giving new meaning to the term RBAR. ...
--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)

March 21, 2023 at 1:45 pm

#4163306
Reply To: Performance comparision

In most cases (there are exceptions to everything) the following settings absolutely suck on any server...
cost threshold for parallelism 5 -- General advice here is to start at 50 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)

March 20, 2023 at 4:56 pm

#4162947
Reply To: Decoding Set Options

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

March 20, 2023 at 4:45 pm

#4162938
Reply To: Performance issues after migration

Start with the "Key Configuration Options" in the following article. Every single thing there can make a pretty good difference.
https://glennsqlperformance.com/2020/08/20/preventing-sql-server-upgrade-performance-issues/

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

March 19, 2023 at 9:29 pm

#4162572
Reply To: AFTER TRIGGER QUESTION - How To filter Non Real Updates

YSLGuru wrote:
Jeff - The trigger did capture the change of a non-null value to null when I removed the date form an item and dtInactive was set to NULL.
Sorry. I...
--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)

March 17, 2023 at 7:11 pm

#4162046
Reply To: Why do cloud companies (in particular) have massive SKOs every year?

That's a great answer, Gulshan.
--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)

March 17, 2023 at 5:53 pm

#4162030
Reply To: Master Data - Hierarchies Creation, Change and Maintenance

Wow. Thanks Jason. I seriously had no clue. Like I said, my aim is to help, not collect accolades for a resume but that comment just made the last 20...
--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)

March 17, 2023 at 5:50 pm

#4162029
Reply To: AFTER TRIGGER QUESTION - How To filter Non Real Updates

Be careful, now... sometimes the change is from a value to a NULL.
--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)

March 17, 2023 at 5:46 pm

#4162028
Reply To: How Normal Is Your World?

A different type of "pandemic" was recently launched. The world will not be "normal" any more... they've recently launched "CoPilot" for O365.
--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)

March 17, 2023 at 2:54 pm

#4161983
Reply To: AFTER TRIGGER QUESTION - How To filter Non Real Updates

YSLGuru wrote:
Dumb Dumb me was looking at it in the opposite direction. Its 1AM and because the work computer is in the hallway next to my kids bedrooms I can'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)

March 17, 2023 at 2:47 pm

#4161980
Reply To: AFTER TRIGGER QUESTION - How To filter Non Real Updates

Cool! What's the answer?
--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)

March 17, 2023 at 6:02 am

#4161768
Reply To: SQL Server 2022 Restore and DBCompat

Crud... I knew the answer but clicked on the wrong bloody button. 🙁
--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)

March 17, 2023 at 5:59 am

#4161762
Reply To: Master Data - Hierarchies Creation, Change and Maintenance

Thanks, Jason. I have to tell you, you've made my month. I had no idea about that and I sometimes wonder to myself whether or not I accomplished my goal...
--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)

March 16, 2023 at 10:17 pm

#4161679
Reply To: Index rebuild / stats update taking lot of disk space.

Here's the "formula" I've been using in production
FF
100 - Static or usually static.
99 - Usually, some form of ever-increasing keyed index that suffers no fragmentation, which also means no "ExpAnsive"...
--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)

March 16, 2023 at 9:39 pm

#4161677

Viewing 15 posts - 1,696 through 1,710 (of 59,082 total)