Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,336 through 4,350 (of 59,087 total)

Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

I saw that and was totally impressed. It only took them 5 years to get a fix out... kind of. As you say, it's only in Azure so far. 😀
Once...
--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)

November 17, 2021 at 6:28 pm

#3954160
Reply To: Automate Import Process

water490 wrote:
Here is the plan:
-log into SFTP server and download files to local directory
-unzip files to specified folder
-import files into SQL Server table (it will always be the same table)
-if...
--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)

November 17, 2021 at 3:07 am

#3953845
Reply To: How to distinguish human principals from all the rest in sys.server_principals ?

Mr. Brian Gale wrote:
type = 'U' means you are grabbing all "user" type of login. To SQL, a "human" and a "non-human" are identical. It is just a login.
How would SQL 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)

November 16, 2021 at 6:33 am

#3953448
Reply To: Automate Import Process

You're posting in an SQL Server 2019 forum. BULK INSERT and BCP have both had "CSV" capabilities since SQL Server 2017. If the files and the tables are consistent, there's...
--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)

November 16, 2021 at 6:29 am

#3953447
Reply To: Show Queries

Grant Fritchey wrote:
Jeff Moden wrote:
water490 wrote:
Thank you everyone. I have been saving the files to a folder. it works for me because I only have a few queries. I am so used...
--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)

November 16, 2021 at 6:17 am

#3953444
Reply To: Summit Reflections

mfagan12 wrote:
I don't feel comfortable flying normally but with Covid--even though I just got my booster and wear a mask everywhere--the thought of being on a crowded plane. ....
--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)

November 15, 2021 at 8:09 pm

#3953305
Reply To: Show Queries

water490 wrote:
Thank you everyone. I have been saving the files to a folder. it works for me because I only have a few queries. I am so used to Access...
--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)

November 15, 2021 at 7:56 pm

#3953300
Reply To: Great Writers Get Hired

Rod at work wrote:
Jeff Moden wrote:
I have to tell you that if you work with the right recruiter, you don't have to worry about AI HR bots, HR people, or whatever. A lot...
--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)

November 15, 2021 at 7:52 pm

#3953298
Reply To: Show Queries

Jeffrey Williams wrote:
If all you want is the ability to lookup and access your queries - then you might consider Azure Data Studio instead of SSMS. That does allow you 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)

November 15, 2021 at 7:41 pm

#3953295
Reply To: SQL Server 2022 and Learning

Heh... I'm sometimes amazed at how people almost feverishly try to learn a whole lot of new stuff when they haven't actually learned to use the old stuff or even...
--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)

November 15, 2021 at 6:49 am

#3953033
Reply To: bring back single line

I avoid the PIVOT operator and instead use the ancient "Black Art" of CROSSTABs because of more flexibility, functionality and performance.
https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-%e2%80%93-converting-rows-to-columns-1
If you want dynamic CROSSTABs, those are pretty easy, as...
--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)

November 15, 2021 at 6:42 am

#3953031
Reply To: Dynamic procedure pivot not accept multi columns SQL server ?

Personally, I avoid the PIVOT operator like the plague. I prefer CROSSTABs for functionality, performance, and more.
https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs

--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)

November 15, 2021 at 6:29 am

#3953029
Reply To: Alter default SQL generated in context menu top 1000

I don't believe so.
--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)

November 15, 2021 at 6:25 am

#3953027
Reply To: Show Queries

No. Not queries in the object explorer. If they're stored procedures, view, or functions, then you'll see them in the object explorer.
Maybe somehow in a "project" but I don't "projects"...
--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)

November 15, 2021 at 6:23 am

#3953026
Reply To: Grouping , time difference in minutes

gjoelson 29755 wrote:
Hi,
I'm trying to query the amount of minutes a column value stays below a threshold and then group it together
Im Selecting records with Values <= 20 and then use...
--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)

November 13, 2021 at 7:27 pm

#3952755

Viewing 15 posts - 4,336 through 4,350 (of 59,087 total)