Jeff Moden

Forum Replies Created

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

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
Reply To: DBCC Timewarp

The Dixie Flatline wrote:
DAMMIT!! I make one, ONE, typo on parameter 137 and suddenly I find myself here in the FUTURE!!
Does anyone still follow this thread, and if so, can you...
--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 30, 2023 at 10:44 pm

#4276219
Reply To: File group size issues

Posting to get Johan's answer to show up. It was the first post on a new page and this forum still has the problem of not showing the first post...
--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 30, 2023 at 2:59 pm

#4275855
Reply To: Rebuild index for system database

The only time you might want to do a rebuild on a system (or any other database) is if you need to recover a lot of disk space. You check...
--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 30, 2023 at 5:23 am

#4275444
Reply To: Non-yielding Scheduler every 30 days

Windows 11 PRO??? You need to have a Windows Server. I'm surprised that your SQL Standard Edition even runs on that desktop edition.
TBH, I'm thinking it might be automatic reboots...
--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, 2023 at 3:26 pm

#4274863
Reply To: shrinking a large data file

vsamantha35 wrote:
Does it make any difference with the on-going open transactions to the database? is it better to do during maintenance windows when there are no incoming connections from 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 28, 2023 at 9:05 pm

#4274059
Reply To: shrinking a large data file

A shrink that large will take a long time, especially if there's a fair bit of LOBs in the data. Worse yet, you won't be able to see any progress...
--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 28, 2023 at 4:08 pm

#4273866
Reply To: SQL2022 UPDATED FROM SQL2014 - PARALLELISM ISSUES
Johan Bijnens wrote:
- Have you rebuild all indexes and statistics after migration/upgrade ?
- Did you compare old vs new SQLplans ?
- How many indexes / indexed views are based on 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 28, 2023 at 2:30 pm

#4273781
Reply To: Determine if value occurred within all shifts

jcelko212 32090 wrote:
I think I'll go to the other extreme. I am waiting for eye surgery right now, so there will be a little delay, but I will develop an article...
--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 28, 2023 at 1:21 am

#4273192

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