Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 59,099 total)

Reply To: Are the posted questions getting worse?

Jo Pattyn wrote:
Grmbl, the /quiet installationswitch workaround for installing Access Ace drivers 32 and 64-bit side-by-side seems to have stopped working.
That's not the intent of the "quiet" switch. The intent is...
--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, 2023 at 4:00 pm

#4279940
Reply To: Multicolumn indexes and fragmentation

ScottPletcher wrote:
Also, for child tables in particular, the typical usage would be a seek and then a scan of contiguous rows. In those situations, any significant logical fragmentation COULD cause...
--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, 2023 at 3:53 pm

#4279939
Reply To: Multicolumn indexes and fragmentation

ScottPletcher wrote:
Jeff Moden wrote:
With the exception of random but evenly distributed indexes, I wouldn't use logical fragmentation to determine if an index needs to be rebuilt. In the case mentioned,...
--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, 2023 at 3:34 pm

#4279937
Reply To: Trying to understand lock escalation behavior

I believe you'll find the following article quite interesting. To summarize, Paul White proves that the 5000 row thing is a bit of a myth that, according to him, no...
--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, 2023 at 3:27 pm

#4279928
Reply To: High CPU & blocking

Ah... almost forgot about another scenario that I ran into. Are the connections to the server setup to explicitly turn off/disable M.A.R.S. It they're not, they need to be. 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)

September 5, 2023 at 3:11 pm

#4279925
Reply To: High CPU & blocking

ramana3327 wrote:
Thank you.
Not after the Index maintenance job. I check the queries that are consuming for years. They are not new o nes. I tried updating the stats & cleared...
--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, 2023 at 2:58 pm

#4279921
Reply To: Multicolumn indexes and fragmentation

Logical fragmentation is seriously overrated as a concern. As Grant said, unless you can seriously prove that it's causing an issue, don't worry about it. I'm working on some articles...
--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, 2023 at 2:49 pm

#4279920
Reply To: Labor Day 2023

And don't forget the veterans that missed so many holidays nor the folks that are on active duty.
--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 4, 2023 at 3:46 am

#4278949
Reply To: The Isolation Level Across Databases

And, if the update is rolled back instead of being committed because the error was realized, then the second query has just returned incorrect information. 😛
--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 4, 2023 at 3:43 am

#4278948
Reply To: Optimized Plan Forcing with Query Store in SQL Server 2022

My problem with Query Store and some of the people that use it is that, quite frequently, many of the plans (there's just 2 or there's more) are terrible. 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)

September 4, 2023 at 3:35 am

#4278946
Reply To: Concatenate two field into one

Show me where in Table "A" that you have the value "DEF0002".
I think your example data for Table "A" is incorrect.
--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 1, 2023 at 11:41 pm

#4277863
Reply To: Are the posted questions getting worse?

WayneS wrote:
Brandie Tarvin wrote:
There's a push to use NOLOCK on everything unless the users absolutely cannot deal with dirty reads because "it improves performance." ACK!
Sounds like it's time 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 1, 2023 at 11:05 pm

#4277843
Reply To: Are the posted questions getting worse?

WayneS wrote:
Michael L John wrote:
jonathan.crawford wrote:
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
That would make a very viral video!!!!!!!!!
I know it's been...
--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 1, 2023 at 11:01 pm

#4277841
Reply To: SQL2022 UPDATED FROM SQL2014 - PARALLELISM ISSUES

autoexcrement wrote:
Off-topic, but awesome to SEE Jeff Moden after all these years! The YT vid was a bit over my head but still fascinating.
I've PM'd you to ask a favor,...
--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 31, 2023 at 9:56 pm

#4277187
Reply To: DBCC Timewarp

Phil Parkin wrote:
Jeff Moden wrote:
Shift all parameters 1.5 bytes to the left and start the run. In 30ms, stop the run and then restart it. Note that you have to do...
--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 31, 2023 at 8:46 pm

#4277169

Viewing 15 posts - 1,201 through 1,215 (of 59,099 total)