Jeff Moden

Forum Replies Created

Viewing 15 posts - 721 through 735 (of 59,101 total)

Reply To: Growing Skills at Work

@ Steve and @ Jonathan,
There is no question at all in my mind that the smart company will invest in it's employees. That's not the issue I'm speaking of.
My bitching...
--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)

March 16, 2024 at 12:39 am

#4396263
Reply To: Growing Skills at Work

I see many people that site things like a lack of training at work, etc, etc.
Tell me... if you have a degree, who paid for it? How did you get...
--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)

March 15, 2024 at 10:31 pm

#4396207
Reply To: Grouping Count

Phil Parkin wrote:
I'm actually not too concerned about opening xlsx files, as they can't contain executable code (as far as I know). I downloaded and virus-scanned this one before I opened...
--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)

March 15, 2024 at 12:32 pm

#4395912
Reply To: SQL Server 2024 or 2025?
Just to emphasize what Jeffrey Williams is talking about...
```
    SET LANGUAGE ENGLISH;
 SELECT English = CAST('2025-09-06' AS DATETIME);

    SET LANGUAGE FRENCH;
...
```
--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)
March 14, 2024 at 5:54 pm

#4395415
Reply To: temp table level of precision

water490 wrote:
thank you everyone!
I used the script that Jonathan provided. It turns out that temp was using float when I used numeric. Once I made this change the numbers match.
I...
--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)

March 14, 2024 at 5:45 pm

#4395413
Reply To: If anyone used tools like Gee-Pee-Tee for writing T-SQL (MS SQL server)?

Grant Fritchey wrote:
VAI wrote:
Sounds really good! I have never used SQL Prompt for this purpose but used it for other, mostly code formatting and best practices suggestions purposes.
QUESTION: is SQL PROMPT...
--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)

March 14, 2024 at 5:43 pm

#4395412
Reply To: SQL server disk block size formatted as 4KB runs slow

ratbak wrote:
The closest I could find are this article from 2009 and this article from 2009
I'm still waiting for Scott to backup his claim with a link.
--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)

March 13, 2024 at 4:17 pm

#4394688
Reply To: has inline function got any catch?
rajemessage 14195 wrote:
do u want to say that we should not use begin end in inlined scalar functions?
No.
1. What I said was that Scalar and mTVF functions both use BEGIN/END in...
--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)
March 13, 2024 at 1:38 pm

#4394617
Reply To: join

mtz676 wrote:
I have 1 record(1row*2columns) from 1 select
and
a different select which can result in multiple rows but will always have 3 columns.
How can I repeat the 1 row next 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)

March 12, 2024 at 4:21 pm

#4394088
Reply To: Oops! Apologies

Grant Fritchey wrote:
Great points. I wasn't even thinking about that at all. Happily, I haven't received so much as a finger wag for dropping the ball. I mean, Steve is going...
--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)

March 11, 2024 at 6:46 pm

#4393541
Reply To: SSIS error

Does you code actually look like what you posted? I ask because there is no space between the terms "SET" and "Processed_Flag" and there needs to be.
--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)

March 11, 2024 at 7:10 am

#4393178
Reply To: Table partitioning questions

sqlguy80 wrote:
I was asked to implement partitioning to improve performance and management.
We need to really emphasize what RatBak posted (re-quoted below)...
ratbak wrote:
Do not expect performance improvements for queries, inserts,...
--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)

March 11, 2024 at 6:41 am

#4393176
Reply To: has inline function got any catch?

rajemessage 14195 wrote:
hi,
I heard many people saying "functions are denounced in tsql" is there any catch?
q1) need to know what are the cases where we should not use?
q2) should we avoid...
--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)

March 11, 2024 at 6:28 am

#4393172
Reply To: find the number of values less than the current row

Interesting solutions, so far. Let's try one more...
First, let's simplify the code to make the readily consumable data. This is the best one of the better ways to post such...
--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)

March 11, 2024 at 3:54 am

#4393111
Reply To: query run time changes alot...why?
I'm thinking that the answer is somewhere in the Actual Execution Plans.
p.s. That's a major hint for what you might want to provide.
- This reply was modified 2 years, 8 months ago by Jeff Moden. Reason: Add p.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)
March 11, 2024 at 1:44 am

#4393073

Viewing 15 posts - 721 through 735 (of 59,101 total)