Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 59,099 total)

Reply To: Indexing Tables

water490 wrote:
I have a script that was running fine but today it is taking way too long. I looked at the script and I see these errors:
"cannot specify included columns...
--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:42 pm

#4163342
Reply To: Data Problem
ratbak wrote:
```
where Date From >=  '2020-04-01'  and  Date To <= '2020-04-28'
```
There is no data in your sample that meets that requirement.
In
```
2  ----- 2020-04-01 -----...
```
--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:29 pm

#4163336
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

Viewing 15 posts - 1,711 through 1,725 (of 59,099 total)