Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 59,063 total)

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
Reply To: To partition or not to partition

Heh... apparently the OP has left the building!
--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 18, 2023 at 6:34 pm

#4310621
Reply To: tempdb sizing

Thumbs up to the previous 2 replies. The code is in serious need of some real help and the Developers need to be taught how to write good code. I'm...
--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 18, 2023 at 6:26 pm

#4310591
Reply To: To partition or not to partition

@ericwenger1,
Any chance of you posting the CREATE TABLE statement along with the indexes and constraints? We might be able to make some additional suggestions, once we see it.
--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 15, 2023 at 9:38 pm

#4308662
Reply To: Backup to SQL Server NULL device

I realize that this is a wicked old post but thought I'd add why I use a backup to NUL.
I do it for testing code demonstrations, especially demonstrations concerning "Minimal...
--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 15, 2023 at 6:43 pm

#4308612
Reply To: Count only unique dates from a subquery

JeremyU wrote:
Hello,
I have a question.
Me too. Where's the "Readily Consumable" test data and the desired results that match the test data?
With that being said, be advised... You've been asked 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)

October 14, 2023 at 6:07 pm

#4308123
Reply To: Is it always better to redo a database, when upgrading an application?

Rod at work wrote:
I might do that. I confess I've reached a point where I've learned not to ask. Asking tends never to get an answer, only stares. So, learn helplessness.
Still, I'd...
--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 14, 2023 at 6:17 am

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

robh0502 wrote:
hi,
Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why this happens.
I've got a table field with datatype varchar(10). If a value greater...
--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 14, 2023 at 6:09 am

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

robh0502 wrote:
hi,
Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why this happens.
I've got a table field with datatype varchar(10). If a value greater...
--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 14, 2023 at 6:06 am

#4307857
Reply To: Alerts to my SQL Server

Better yet, click on the following MS Documentation about alerts and teach yourself something new. It'll look better on your resume, as well.
https://learn.microsoft.com/en-us/sql/ssms/agent/alerts
--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 14, 2023 at 3:58 am

#4307795

Viewing 15 posts - 1,006 through 1,020 (of 59,063 total)