Jeff Moden

Forum Replies Created

Viewing 15 posts - 706 through 720 (of 59,091 total)

Reply To: Give It Away

Ok... on that note... it's a bit ironic having a RedGate employee talk to us about "Giving it away" when the very forum such an article is on has seriously...
--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 3:09 pm

#4396978
Reply To: Database Ownership - Does it Matter ?

Johan Bijnens wrote:
We create a sqluser "NonSA" to serve as dbowner for all user databases (unless other is actually needed - eg during install/upgrade of some software)
Thumbs up on that. 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)

March 17, 2024 at 2:16 pm

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

Alejandro Santana wrote:
Thanks for the quick reply Jeff!
Do you use Auto update stats? And for critical tables full scan with norecompute? And update these weekly? Or just full scan all stats...
--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:14 pm

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

Viewing 15 posts - 706 through 720 (of 59,091 total)