Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 59,072 total)

Reply To: The Choice of SQL Server Version

One of the things that people seem to forget it that it was almost 2023 by the time 2022 came out. It may have gone past the "plan the funding...
--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)

July 22, 2023 at 11:06 pm

#4242033
Reply To: How to import csv file into a sql table and include filename

shogunSQL wrote:
Thank you so much, Jeff! I was looking for something like xp_DirTree. Will try it out. Thanks.
Although it's more than a decade old, good things don't need to change...
--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)

July 22, 2023 at 10:48 pm

#4242010
Reply To: How to import csv file into a sql table and include filename

shogunSQL wrote:
Hi everyone,
I have a directory of many csv files such as
C:\Temp\NP-001.csv
C:\Temp\NP-002.csv
C:\Temp\NP-003.csv
In each csv file, there are 5 columns: Name, DOB, MemberID, Address, Email
We need to somehow loop through each...
--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)

July 21, 2023 at 7:24 pm

#4241233
Reply To: Select from view on FileTable throws error
pdanes wrote:
But it blows up when I try:
Select * From Query1 Where tmpResult1 = 'D'
That, good Sir, is what I'm talking about being the problem. That 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)
July 21, 2023 at 7:13 pm

#4241232
Reply To: Select from view on FileTable throws error

pdanes wrote:
I still think it's screwy that SQL Server made a query plan that does column computations BEFORE removing rows according to conditions in the Where clause.
In calculated 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)

July 21, 2023 at 2:40 pm

#4241094
Reply To: Invoke-DbaQuery in Powershell 7.2 not working

I think you may have correctly identified the problem... Someone who is more knowledgeable about PoSh than I may have a bit of magic that I don't know about but...
--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)

July 21, 2023 at 12:36 am

#4240585
Reply To: Select from view on FileTable throws error

If I'm reading all of this correctly, another issue with filtering the calculated columns of a view is that all of the rows must first be materialized and then the...
--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)

July 21, 2023 at 12:27 am

#4240560
Reply To: Using a comma seperated list in a where clause

Weegee71 wrote:
Jeff Moden wrote:
Here's the updated post that actually takes advantage of JSON. No need for TRIM() or STRING_SPLIT() functions because the source is in a proper JSON ARRAY format. Again,...
--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)

July 20, 2023 at 10:22 pm

#4240442
Reply To: Using a comma seperated list in a where clause

All good reasons for why I have a serious dislike for XML, JSON, and a couple of other things when it comers to SQL.
Thanks for the info, Jeffrey. And, I'm...
--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)

July 19, 2023 at 9:19 pm

#4239505
Reply To: Using a comma seperated list in a where clause

Jeffrey Williams wrote:
You may want to validate the return value from OPENJSON - I believe it returns an NVARCHAR and that could have a significant impact on performance.
Damn! Awesome catch, Jeffrey! ...
--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)

July 19, 2023 at 8:07 pm

#4239476
Reply To: A Function to Split JSON Data

@Ric,
Ok... so I'm only 14 years late in seeing this the first time. 😀
I've not needed to work with JSON up until now. It's gotten out of hand in our...
--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)

July 19, 2023 at 7:12 pm

#4239415
Reply To: Using a comma seperated list in a where clause

Jonathan AC Roberts wrote:
posted code
Heh... you posted while I was writing the code. Thanks, Jonathan.
--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)

July 19, 2023 at 5:58 pm

#4239359
Reply To: Using a comma seperated list in a where clause
Here's the updated post that actually takes advantage of JSON. No need for TRIM() or STRING_SPLIT() functions because the source is in a proper JSON ARRAY format. Again, this eliminates...
- This reply was modified 2 years, 11 months ago by Jeff Moden. Reason: Add the conversion to INT per Jeffrey Williams excellent tip below
--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)
July 19, 2023 at 5:55 pm

#4239358
Reply To: Using a comma seperated list in a where clause

p.s. I seem to remember a way to do this directly with JSON and not have to do the STRING_SPLIT() and TRIM() things. I'm looking for 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)

July 19, 2023 at 5:38 pm

#4239355
Reply To: Using a comma seperated list in a where clause

[EDIT]: DON'T USE THIS METHOD. I left the post here to show you that I'm actually quite the rookie at JSON. There's no need for the complexity of the...
--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)

July 19, 2023 at 5:03 pm

#4239335

Viewing 15 posts - 1,276 through 1,290 (of 59,072 total)