Jeff Moden

Forum Replies Created

Viewing 15 posts - 211 through 225 (of 59,069 total)

Reply To: why no suggested indexes in estimated exec plan?

stan wrote:
thx jeff. eventually i did do the divide and conquer thing. it took the query down from 6 minutes to 19 seconds. i turned it over in that state...
--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 9, 2025 at 1:12 am

#4512331
Reply To: why no suggested indexes in estimated exec plan?

Shifting gears to the dark side, it may be that the query was written in such a fashion that the optimizer just can't figure out if an index would 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 8, 2025 at 4:17 pm

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

Ok... so you don't need the xp_CmdShell example 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 6, 2025 at 4:06 pm

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

Viewing 15 posts - 211 through 225 (of 59,069 total)