Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 59,101 total)

Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
Hey Jeff,
I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should I use?
Yes. ...
--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)

September 15, 2023 at 8:57 pm

#4287367
Reply To: Converting file name MMDDYYYY.txt to a Date Field

ScottPletcher wrote:
The only difference I see between that code and mine is CONVERT rather than CAST ... I didn't realize CAST had that "big overhead". (Presumably using LEFT rather than...
--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)

September 15, 2023 at 4:38 pm

#4287247
Reply To: Converting file name MMDDYYYY.txt to a Date Field
IF the MMDDYYYY formatted string date is guaranteed to always be 8 characters, the following works (most of the posted code doesn't consider the inclusion of the ".txt") according to...
- This reply was modified 3 years, 1 months ago by Jeff Moden. Reason: Missed Scott Pletcher's code and added credit to him there
--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)
September 15, 2023 at 4:38 am

#4286861
Reply To: Converting file name MMDDYYYY.txt to a Date Field

Deleted. Made a mistake and didn't check before I posted. 🙁
--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)

September 15, 2023 at 2:03 am

#4286806
Reply To: Converting file name MMDDYYYY.txt to a Date Field

Here's a quick question for you because we have to enforce such things where I work... do you want the conversion to fail if the date contains less than 8...
--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)

September 15, 2023 at 1:59 am

#4286767
Reply To: Advice To Be a Better Person

From the article:
A few of them are in this post, though he's written a book with 450 pieces of advice.
My first thought when I read that was when they replaced...
--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)

September 15, 2023 at 1:24 am

#4286766
Reply To: Rename-Item

Michael L John wrote:
as_1234 wrote:
All,
I'm new to Powershell so this could be a simple error.
I'm using a SQL agent job to backup a database to a UNC path and then rename it.
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)

September 15, 2023 at 1:13 am

#4286765
Reply To: index fragmentation basics

Jeffrey Williams wrote:
I see a lot of focus here on not reindexing at all - mostly because no one can prove that reindexing improves performance. I am not sure how that...
--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)

September 15, 2023 at 1:05 am

#4286761
Reply To: index fragmentation basics

I have to second Michael's recommendation yet again. Stop doing index maintenance on your RowStore indexes until you can prove some significant performance benefit. Use the time to do Statistics...
--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)

September 13, 2023 at 11:13 pm

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

Eirikur Eiriksson wrote:
Jeff Moden wrote:
Good Lord! I've got more testing to do but I ran a simple "Tally CTE Function" test in 2017 and 2022 on my laptop. The results are REALLY...
--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)

September 13, 2023 at 5:46 pm

#4285825
Reply To: Creating a subquery which conflicts with the where clause...

Ed B wrote:
Jeff Moden wrote:
Since you're not using SQL Server (based on the INT4 datatypes you used), it may be that the RDBMS you're using doesn't allow CTEs (Common Table Expressions),...
--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)

September 13, 2023 at 2:00 pm

#4285698
Reply To: index fragmentation basics

vsamantha35 wrote:
Michael L John wrote:
vsamantha35 wrote:
The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team...
--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)

September 12, 2023 at 8:18 pm

#4285196
Reply To: Creating a subquery which conflicts with the where clause...

krishnamurali2489 wrote:
Jeff Moden wrote:
I agree with Phil. Posting inserts to populate the test table with data will help a whole lot.
Also, the code you posted isn't from SQL Server but, since...
--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)

September 12, 2023 at 7:51 pm

#4285188
Reply To: Issue importing data to SQL table

And, sorry... I was reading and answering from top down. You and the OP got all this together.
--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)

September 12, 2023 at 3:12 pm

#4285056
Reply To: Issue importing data to SQL table

Jonathan AC Roberts wrote:
If you just want an id you can just add ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) id, as a column to the query to get a sequential id column....
--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)

September 12, 2023 at 3:10 pm

#4285055

Viewing 15 posts - 1,156 through 1,170 (of 59,101 total)