Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 59,082 total)

Reply To: Regarding update stats

ScottPletcher wrote:
Compress the data. Look at both page compression and COMPRESS/DECOMPRESS for large char columns.
As a bit of a sidebar, be aware that Page Compression causes index rebuilds to take...
--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)

October 23, 2023 at 1:40 pm

#4313393
Reply To: Celebrate THEIR Accomplishments

Grant Fritchey wrote:
I sure don't mean for it to be false praise, or even praise for nothing. I've just seen a few people get... for want of a term, upset when...
--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)

October 23, 2023 at 4:28 am

#4313136
Reply To: inserting into varchar field doesn't error when > 8000 bytes

Steve Jones - SSC Editor wrote:
replicate returns 8k
https://learn.microsoft.com/en-us/sql/t-sql/functions/replicate-transact-sql?view=sql-server-ver16
Lordy... I've been bitten by that before. In this case, it returns 8K because it wasn't predefined as a MAX datatype.
Let run the test a bit...
--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)

October 23, 2023 at 4:18 am

#4313135
Reply To: Confidence

David.Poole wrote:
I feel that your most needed confidence is that needed for you to ask questions when you are not sure about something.
One of my biggest regrets is in not...
--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)

October 23, 2023 at 3:44 am

#4313109
Reply To: TRUNCATE an FK

Just to be absolutely correct, you might want to add a PK on EmpID in the Employee table. 😀
Otherwise, awesome question!
--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)

October 20, 2023 at 7:16 pm

#4312010
Reply To: Ola IndexOptimize - USER_DATABASES failed

Actually, REORGANIZE does a whole lot...
It causes log file explosions.
It perpetuates fragmentation because it doesn't clear the pages above the Fill FACTOR.
It combines pages at the worst time possible, which...
--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)

October 20, 2023 at 7:01 pm

#4312005
Reply To: What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

I'm still waiting on the OP for the DDL and Data sources for the example table.
As a bit of a sidebar, I've not yet done a deep dive on this...
--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)

October 20, 2023 at 6:34 pm

#4311975
Reply To: What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

There's really no difference between CTEs and Views. The exception to that rule is that if you can force a "Blocking Operator" in the CTE, it can act more like...
--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)

October 20, 2023 at 6:22 pm

#4311970
Reply To: What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

This is nice but I agree with Mike01. Where do we get a copy of the DDL for the table AND the data? People can learn much more by actually...
--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)

October 20, 2023 at 1:37 pm

#4311838
Reply To: Has SQL Server Performance Improved?

Just so people know, we have a "Morning Jobs Report" that we have extensive history from. It includes the start DATETIME for each job and the duration. It runs religiously...
--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)

October 20, 2023 at 4:07 am

#4311527
Reply To: Has SQL Server Performance Improved?

Glenn Berry wrote:
I would say that it would be more useful (for Microsoft and the overall community) to provide some more specific detail about what sort of code or query patterns...
--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)

October 19, 2023 at 11:57 pm

#4311429
Reply To: Has SQL Server Performance Improved?

Glenn Berry wrote:
I don't know that Bob Ward is the best person to ping about this. Conor or Derek Wilson might be better resources.
I got similar results for the little loop...
--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)

October 19, 2023 at 7:47 pm

#4311330
Reply To: Has SQL Server Performance Improved?

Glenn Berry wrote:
I don't know that Bob Ward is the best person to ping about this. Conor or Derek Wilson might be better resources.
Agreed but Bob Ward was they one 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)

October 19, 2023 at 7:31 pm

#4311326
Reply To: Has SQL Server Performance Improved?

We did no index rebuilds were. The conditions travel with the restores. The same holds true with statistics. We do, however, rebuild stats once each week. It has not made...
--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)

October 19, 2023 at 5:47 pm

#4311255
Reply To: Has SQL Server Performance Improved?

My worst nightmare has come true. We upgraded to 2022 and stuff is crawling now. We turned off Query Store and went back to the old cardinality estimator and 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)

October 19, 2023 at 3:02 am

#4310821

Viewing 15 posts - 1,021 through 1,035 (of 59,082 total)