Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,056 through 5,070 (of 59,072 total)

Reply To: Lots of Data and AI Helping Firefighters

Using drones in conjunction with satellites would also be a great way to check for the undergrowth problem, as well.

--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 22, 2021 at 2:26 pm

#3899334
Reply To: Microsoft.ACE.OLEDB.16.0 Provider Is Not Registered

AMCity wrote:
Phil:
The issue is that when I try to import *.xlsx files using either SSIS / SSMS (Import Data option), I get the error "Microsoft.ACE.OLEDB.12.0 Provider Is Not Registered" /...
--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 22, 2021 at 1:17 pm

#3899316
Reply To: how to get GPNSignature that first part on it start by portion key ?

ahmed_elbarbary.2010 wrote:
thank you for support
according post on multi forum
it will not repeated
sorry
To be honest, I don't really have a problem with people posting the same problem on multiple forums. After...
--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 10:40 pm

#3899032
Reply To: how to get GPNSignature that first part on it start by portion key ?

To be honest, I had come to the same conclusion and wanted to see what the reaction would be with a mostly code only response rather than the uncoded suggestion...
--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 9:00 pm

#3899004
Reply To: how to get GPNSignature that first part on it start by portion key ?
Jeff Moden wrote:
Do you understand how the following works?
SELECT *
FROM [dbo].[checkportions]
WHERE GPNSignature LIKE PortionKey+'[^0-9]%'
;
Well do ya? Enquiring minds want to know! 😀
--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 6:40 pm

#3898956
Reply To: SQL Servers query time differences

mtz676 wrote:
I have saved the execution plans from enterprise and standard edition.
I've probably missed them. Which post did you attach them 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)

June 21, 2021 at 6:37 pm

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

Sure. Get rid of the UNION ALL and change the second part of that to an INSERT/SELECT.
--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:31 pm

#3898843
Reply To: Deceptive Visualizations

DickBaker wrote:
Jeff, Hi
try this instead
https://www.telegraph.co.uk/news/2021/06/15/fear-freedom-doom-laded-government-graphs-dont-show-us/?fbclid=IwAR30zEscQDhPlr1KR0JWI5nFBz3un5_JLBoC4ZMPAdLVm74aoSLwCgk8k84
but in case you don't read newspapers either (too much bad news) the article was entitled
"Fear over freedom: Here's what the doom-laden government graphs didn'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)

June 21, 2021 at 2:27 pm

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

Viewing 15 posts - 5,056 through 5,070 (of 59,072 total)