Jeff Moden

Forum Replies Created

Viewing 15 posts - 226 through 240 (of 59,076 total)

Reply To: create multiple output files based on query

Bruin wrote:
Thanks for response, would you be able to mock up an example of how that can be achieve? I just need an easy way to crank out files based...
--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)

January 5, 2025 at 5:49 pm

#4510447
Reply To: Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing

cyrusbaratt wrote:
Good work Jeff.
Not so good... I somehow missed what the OP had in the first post, which is...
Dell PE T430
2 - Xeon E5-2630 2.4GHz
64GB RAM
PERC H730 Controller 1GB cache
2...
--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)

January 3, 2025 at 4:53 am

#4509265
Reply To: printing complete path

mtz676 wrote:
Thank you Jeff. Looks like my google search was not good enough. Thanks again.That helped.

Heh... I just get lucky that wway.
--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)

January 3, 2025 at 4:49 am

#4509264
Reply To: Happy New Year 2025

skeleton567 wrote:
Yes, Jeff, those were the days of news instead of propaganda. Thanks for the memories.
There were some fond memories made back then.
--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)

January 3, 2025 at 4:38 am

#4509262
Reply To: Big Data or Small Data

"Bumping" my latest reply because of the forum's "Page 2" problem.
--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)

January 3, 2025 at 4:31 am

#4509253
Reply To: Big Data or Small Data

Alex Stuart wrote:
Jeff Moden wrote:
And, yeah... that was one of the times where they said "It didn't run" when they tested it because it ran so comparatively fast.
Hah - I've had...
--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)

January 3, 2025 at 4:30 am

#4509250
Reply To: create multiple output files based on query

Bruin wrote:
Was there an issue with creating solution locally before deploy?
No... it's what happens when you deploy. The C: drive on the server should be avoided for this type of...
--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)

January 3, 2025 at 4:22 am

#4509247
Reply To: The Oldest Article

Thank you for the update, Steve. If they need someone to test, I can help.

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

January 3, 2025 at 4:07 am

#4509246
Reply To: The Oldest Article

Too funny. A SPAM post was removed but the "Discussion" section still has the title with the SPAM info from the title still intact. That's another item they'll need 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)

January 2, 2025 at 12:43 am

#4508603
Reply To: create multiple output files based on query

Bruin wrote:
On my physical laptop ... just testing the process before using Network share.
Is the "SQL Server" you're testing on also on your laptop?
--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)

January 2, 2025 at 12:35 am

#4508602
Reply To: create multiple output files based on query

I can't help because I don't use PowerShell for much but I am curious. The output file in your original post is "c:\fileloading\rmcstdetails.csv". Where is the "c:\" drive physically located? ...
--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)

January 2, 2025 at 12:28 am

#4508591
Reply To: Happy New Year 2025

I remember when I was a young kid and listened to Walter Cronkite talk about the year 2000, which was decades away at the time. Once again, it's decades away...
--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)

January 1, 2025 at 2:55 am

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

Since MS messed up with performance starting in 2019 and hasn't made it any better in 2022, I sadly pronounce that I Don't Believe Anymore but I keep Doing 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)

January 1, 2025 at 2:24 am

#4508192
Reply To: need community help on 1 final cdata odbc driver product eval question

I'm confused. You're talking about Oracle but you're posting in an SQL Server 2019 forum.
Since I'm not privy to your previous attempts and have never used "CDATA", what is 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)

December 30, 2024 at 10:18 pm

#4507670
Reply To: How to Attach and Detach Databases in SQL Server

Michael L John wrote:
I would recommend updating statistics after you re-attach the database.
I've seen several people say that. I have to ask "Why"? The statistics are stored in the database just like...
--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)

December 30, 2024 at 10:00 pm

#4507667

Viewing 15 posts - 226 through 240 (of 59,076 total)