Jeff Moden

Forum Replies Created

Viewing 15 posts - 421 through 435 (of 59,069 total)

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
Reply To: How to calculate potential IO benefits of changes
Jez-448386 wrote:
This is the query with the plan (names have been changed):
```
DECLARE @DateColumn  DATE = '2024-07-01';

DELETE s 
FROM [Schema].TableName s 
INNER JOIN #WorkingTable q
ON q.Column1 =...
```
--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:04 am

#4448228
Reply To: Index Update Reports - Scans/Seeks

This won't tell you if a table is "empty" or not but it will tell you if it has been used by users since the last restart or not. 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)

August 19, 2024 at 4:31 am

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

Please post the Actual Execution plan for the DELETE of just ONE row. Attach the ACTUAL execution plan so we can take a look at it. A graphic of the...
--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 19, 2024 at 3:06 am

#4447120
Reply To: 64KB and 32KB cluster size for log drives and tempdb
Before you mess with those things...
... try setting the following...
1. Make sure Compressed backups are enabled (UNLESS your database is encrypted https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-compression-sql-server ).
2. Set the "buffercount" to 17 as a...
--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 17, 2024 at 4:35 am

#4446705
Reply To: Why am I getting a "Incorrect syntax near '@tblName' error message?

Also, put the variable name in a QUOTENAME() function... just to be safe two ways.
--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 17, 2024 at 4:28 am

#4446704
Reply To: How to improve index rebuild for very large table.

@JasonO
Lordy. My apologies. I just noticed that the table you posted has no Clustered Index.
I have to assume that you're not rebuilding the HEAP with Ola's Code, correct?
Also, you said...
--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 14, 2024 at 4:03 pm

#4444934
Reply To: Query timeout question

Older but definitive article...
https://www.sommarskog.se/query-plan-mysteries.html

--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 12, 2024 at 7:39 pm

#4444277

Viewing 15 posts - 421 through 435 (of 59,069 total)