Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 59,098 total)

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
Reply To: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

So... here we are near the end of the year 2021. SQL Server 2022 has just been announced, miracles of both hardware and software have and continue to occur, MS...
--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 4:49 pm

#3952736
Reply To: COHESITY for Backup/Restore?

Brian-444611 wrote:
Grant Fritchey wrote:
Jeff Moden wrote:
Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove...
--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 11, 2021 at 3:33 am

#3951467
Reply To: Bulk Insert - Only Half the Records

It would also be helpful if you posted the CREATE TABLE statements for the two target tables and attach a text file with the first 10 or so rows from...
--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 11, 2021 at 3:05 am

#3951284
Reply To: Bulk Insert - Only Half the Records

On of the things that's bugging me about this is that you say that the first import is going to a single column table yet you have a field terminator...
--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 11, 2021 at 3:04 am

#3951017

Viewing 15 posts - 4,351 through 4,365 (of 59,098 total)