Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,086 through 5,100 (of 59,089 total)

Reply To: Conversion failed when converting the varchar value ‘Active’ to data type int

The PIVOT in the second part of your dynamic query creates integers for the count and that is what is being evaluated first in the creation of the table by...
--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)

June 21, 2021 at 2:20 pm

#3898836
Reply To: Multiple .ndf file in single disk

I'm going to suggest that before you do anything else that you upgrade your new 2017 (RTM) server to the latest CU. There were quite a few nasty little performance...
--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)

June 21, 2021 at 1:53 pm

#3898832
Reply To: how to get GPNSignature that first part on it start by portion key ?
Do you understand how the following works?
```
 SELECT *
   FROM [dbo].[checkportions]
  WHERE GPNSignature LIKE PortionKey+'[^0-9]%'
;
```
I'll also state that if this type of thing has...
--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)
June 21, 2021 at 1:47 pm

#3898831
Reply To: RESOLVED | With a QUERY | CTE or a Sub-Query for Cross-tab Concatenate

sqlguru1day wrote:
Thanks - that's perfect!
The reason I made the suggestion above is because the code that you think is perfect is doing 10 table scans on your test data. Your...
--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)

June 21, 2021 at 1:34 pm

#3898830
Reply To: Lots of Data and AI Helping Firefighters

I would actually be seriously concerned about this. There are a whole lot of things not being considered and I'm thinking it'll be pretty easy, because of missing data, for...
--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)

June 21, 2021 at 4:40 am

#3898682
Reply To: RESOLVED | With a QUERY | CTE or a Sub-Query for Cross-tab Concatenate

sqlguru1day wrote:
Thanks - that's perfect!
I don't have the time to try it out tonight even with the great test data posted but look at the STRING_AGG function again. It does...
--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)

June 21, 2021 at 4:28 am

#3898680
Reply To: Extensive blocking from implicit transactions

As you point out, implicit conversions on table columns (example, table column is VARCHAR(), lookup or join value is NVARCHAR()) is really bad especially for blocking. That, of course, is...
--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)

June 21, 2021 at 4:10 am

#3898678
Reply To: Deceptive Visualizations

Heh... it's also how people interpret things. Remember the old joke about bananas?
After a 2 year study, it's been found that people eat more bananas than monkeys.
It must...
--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)

June 20, 2021 at 7:43 pm

#3898609
Reply To: Reading multiple audit files

K. Thanks.
--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)

June 20, 2021 at 7:27 pm

#3898606
Reply To: Are the posted questions getting worse?

Ok, Eirikur... I'm not familar with the limerick you posted a part of and so I went looking. I didn't find it but I did find a mountain of different...
--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)

June 20, 2021 at 2:52 am

#3898477
Reply To: Are the posted questions getting worse?

WayneS wrote:
Steve Jones - SSC Editor wrote:
FWIW, the 8KB schedule is online: https://eightkb.online/
Mr. Moden presenting, if you can make it, at Level 8192. Well above the 400-500 level of other sessions.
So, Jeff is...
--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)

June 20, 2021 at 2:16 am

#3898469
Reply To: Are the posted questions getting worse?

WayneS wrote:
Steve Jones - SSC Editor wrote:
FWIW, the 8KB schedule is online: https://eightkb.online/
Mr. Moden presenting, if you can make it, at Level 8192. Well above the 400-500 level of other sessions.
So, Jeff is...
--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)

June 20, 2021 at 2:08 am

#3898468
Reply To: Deceptive Visualizations

DickBaker wrote:
here is another prime example of selective filtering
https://www.facebook.com/ed.green.127/posts/4241448059299955?notif_id=1623782606067696&notif_t=nf_share_story&ref=notif
read the post before MSM / woke brigade / censor take it down !
I never bought into FaceBook or Twitter... what...
--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)

June 20, 2021 at 12:11 am

#3898458
Reply To: Deceptive Visualizations

This "little" trick-of-the-trade is usually pretty obvious to folks that work with and have to analyze data a lot but it really is deceptive to the general public whether 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)

June 19, 2021 at 3:09 pm

#3898401
Reply To: Seeking input on Best Method to Join on First or Last Row in a 1:M Join
Just thinking out of a different box here...
Questions:
1. Are you always going to lookup all rows in the PERSON table every time?
2. Is it correct or not that every person...
--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)
June 19, 2021 at 5:44 am

#3898268

Viewing 15 posts - 5,086 through 5,100 (of 59,089 total)