Jeff Moden

Forum Replies Created

Viewing 15 posts - 676 through 690 (of 59,063 total)

Reply To: Rebuilding/Reorganizing in a very transactional table

I rebuild stats once per week. Because most of the clustered indexes are "ever increasing" in nature, I use the "if it moved, shoot it" approach. I also use full...
--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 17, 2024 at 4:45 am

#4396804
Reply To: Rebuilding/Reorganizing in a very transactional table

Alejandro Santana wrote:
The server has 150GB of RAM And 48 processors, its 2019 Enterprise.
First, that's an insanely expensive server and you good folks have crippled it with 150GB of RAM. You...
--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 17, 2024 at 2:19 am

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

Viewing 15 posts - 676 through 690 (of 59,063 total)