Jeff Moden

Forum Replies Created

Viewing 15 posts - 451 through 465 (of 59,101 total)

Reply To: Daily maintenance plan causing performance problems

Vernon Jimmerson-306463 wrote:
I thought this must be from years ago but only a few months. Maybe just the reply. I've had the same discussions, or more like yelling matches with DBA...
--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)

September 11, 2024 at 3:20 am

#4456324
Reply To: simple linked server plumbing

You can create a 2 part synonym with the same table name as before that points to the linked server using 4 part naming. Zero code changes will be required.
However,...
--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)

September 10, 2024 at 7:51 pm

#4456257
Reply To: I don't want to be a PITA here...but

Steve Jones - SSC Editor wrote:
My complaints are not being acted on, but I'll pass this post along
Wow. I have to ask... what makes you think our complaints would be acted upon if...
--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)

September 5, 2024 at 12:30 pm

#4454317
Reply To: I don't want to be a PITA here...but

Steve Jones - SSC Editor wrote:
Thanks, I'll push this a bit and see if someone can track down this error. I'm guessing this is some sort of file error, but would be good 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)

September 5, 2024 at 12:26 pm

#4454313
Reply To: Text column is taking More time while Querying, Need to Replace DATALENGTH

Duplicate post removed.
--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)

August 29, 2024 at 5:33 pm

#4451387
Reply To: Text column is taking More time while Querying, Need to Replace DATALENGTH

Mr. Brian Gale wrote:
yeah, that's what I'd expect... why'd you use the grater than operator on a string?
Because I told him to. 😉 It works just fine on MAX datatypes. It doesn't...
--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)

August 29, 2024 at 5:23 pm

#4451382
Reply To: Text column is taking More time while Querying, Need to Replace DATALENGTH

ralahari wrote:
Msg 402, Level 16, State 1, Line 11 The data types text and varchar are incompatible in the greater than operator.
I am getting above error when i am trying...
--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)

August 29, 2024 at 5:22 pm

#4451381
Reply To: Text column is taking More time while Querying, Need to Replace DATALENGTH

Duplicate post removed.
--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)

August 29, 2024 at 4:56 pm

#4451364
Reply To: Text column is taking More time while Querying, Need to Replace DATALENGTH

ralahari wrote:
select * from dbo.resolutions r where R.documentid = 828222222 and DATALENGTH(r.resolution_text) > 0
resolution_text Text column is taking More time while Querying,
Need to Replace DATALENGTH, when i replace datalength condition
as ...
--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)

August 29, 2024 at 4:56 pm

#4451363
Reply To: Less Junior Staff

acfieldsend wrote:
Surely if there are fewer junior developers because most of the junior work is being done by AI, there will also be fewer juniors available to become experienced developers....
--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)

August 26, 2024 at 9:07 pm

#4450307
Reply To: Big Northwind with AI

Jonathan AC Roberts wrote:
What is the correct answer?
If you tell me I'll see if I can drag it out of one of the AI sites with an improved prompt.
I'd like to hold...
--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)

August 26, 2024 at 8:16 pm

#4450297
Reply To: Big Northwind with AI

To date, I'm the least impressed with BING AutoPilot and Claude 3.5 Sonnet. I'm especially disappointed in Claude 3.5 Sonnet because it doesn't seem to provide references like the others...
--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)

August 26, 2024 at 6:49 pm

#4450269
Reply To: How to calculate potential IO benefits of changes

Jez-448386 wrote:
posting the query plan as a zip.
Also: https://www.brentozar.com/pastetheplan/?id=r12r1TEo0
Neither of those are an "Actual" execution plan. They're both "Estimated". While that's close, it misses certain nuances. It does appear...
--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)

August 25, 2024 at 1:43 pm

#4449902
Reply To: How to calculate potential IO benefits of changes

frederico_fonseca wrote:
I know you are after how to estimate X - that is not really a good way to go as there are way to many unknowns, and without looking...
--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)

August 22, 2024 at 1:26 pm

#4448361
Reply To: SQL Server 2022 Memory Consumption

I have nothing good to say about SQL Server 2022. Any benefits have been outweighed by things like you describe and some seriously slow running code. MS broke things starting...
--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)

August 22, 2024 at 8:47 am

#4448249

Viewing 15 posts - 451 through 465 (of 59,101 total)