Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,681 through 1,695 (of 59,067 total)

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
Reply To: Index rebuild / stats update taking lot of disk space.

Ya gotta be careful, though. If you do the index maintenance incorrectly, you could be setting up the index to do massive page splits which will cost you dearly in...
--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 8:31 pm

#4161638
Reply To: Partial Matching the Columns

If you want really good help, then see the article at the first link in my signature line below for one of many ways to provide example data in 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)

March 16, 2023 at 4:15 pm

#4161541
Reply To: Is it possible to SUM on two different ranges in one SELECT query?

Then pray that your data has no times in it because of the use of BETWEEN. 😉
--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 4:13 pm

#4161540
Reply To: Database Design workaround with Views or Synonyms

The biggest downside would be that your "temporary solution" will become permanent. You may also be in serious violation of the 3rd party license agreement if you take this kind...
--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 4:12 pm

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

Arsh wrote:
Dear Friends,
Please advise why the Index rebuild and Update stats jobs on one server consume lots of disk space after they run..I have to manually shrink the data 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)

March 16, 2023 at 2:24 pm

#4161506

Viewing 15 posts - 1,681 through 1,695 (of 59,067 total)