Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 59,099 total)

Reply To: Has SQL Server Performance Improved?

Ok... I just did some extensive testing using Brent's code both as is and with some mods to give the test table a bit more bulk.
Using a MAXDOP of 1,...
--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)

April 1, 2023 at 4:51 pm

#4167984
Reply To: Has SQL Server Performance Improved?

It's been my expectation that SQL Server will run slower because of all the stuff they're doing to figure out if a plan should be reverted and a bunch of...
--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)

April 1, 2023 at 4:46 am

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

Dennis Jensen wrote:
My first motto is (and all my students know it) that the only stupid/dumb/bad question for someone seeking knowledge is the question they chose not to ask.
My motto 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)

April 1, 2023 at 4:38 am

#4167833
Reply To: Usage of #TempTables and an Index in Stored Procedure

Jonathan AC Roberts wrote:
I know you get some reduced performance from running on a virtual machine by I thought this would be maybe 20% slower, the creation of the clustered index...
--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)

April 1, 2023 at 4:25 am

#4167830
Reply To: Usage of #TempTables and an Index in Stored Procedure

Dennis Jensen wrote:
Okay to comment on the (A) CREATE TABLE with INDEX then INSERT INTO versus the (B) SELECT INTO then create INDEX there is no set solution for which 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)

April 1, 2023 at 4:16 am

#4167828
Reply To: dynamic update to SP

ScottPletcher wrote:
You don't really need to partition the table if you (1) cluster the table by date first and (2) the lookup queries specify a WHERE clause on a date...
--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)

April 1, 2023 at 3:58 am

#4167824
Reply To: slow processing

@bob-2... you made the comment in your first posts of...
bobrooney.81 wrote:
What should be checked apart from blocking?
Did you check for blocking? If so, is there blocking associated with this issue?
--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)

April 1, 2023 at 3:50 am

#4167823
Reply To: slow processing

Dennis Jensen wrote:
Also another means of getting around all those WITH (NOLOCKS) is to set at the top of the stored procedure either:
SET TRANSACTION ISOLATION LEVEL SNAPSHOT
-- OR --
SET TRANSACTION ISOLATION...
--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)

April 1, 2023 at 3:49 am

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

Dennis Jensen wrote:
Note I teach/tutor for free and have an online Discord server with 80 plus students at verying levels of expertise. My first motto is (and all my students know...
--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)

April 1, 2023 at 2:59 am

#4167816
Reply To: Usage of #TempTables and an Index in Stored Procedure

Jonathan AC Roberts wrote:
Indexes are needed as the temp tables are joined to other tables, without indexes the queries would take a lot longer.
You and I have know each other for 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)

March 31, 2023 at 8:14 pm

#4167732
Reply To: dynamic update to SP
Perhaps a better thing to do is to partition the table?
- This reply was modified 3 years, 6 months ago by Jeff Moden.
--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)
March 31, 2023 at 7:53 pm

#4167716
Reply To: dynamic update to SP
Post deleted... I misread what was being done.
- This reply was modified 3 years, 6 months ago by Jeff Moden. Reason: Post deleted... I misread what was being done
--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)
March 31, 2023 at 7:51 pm

#4167715
Reply To: dynamic update to SP

Phil Parkin wrote:
Scott's synonym suggestion sounds like your best bet to me.
Strong second here on Scott's synonym suggestion.
--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)

March 31, 2023 at 7:47 pm

#4167713
Reply To: Expert Performance Indexing in Azure SQL and SQL Server 2022

Thanks, Steve.

--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)

March 31, 2023 at 7:44 pm

#4167712
Reply To: Is TemporalTable SysStartTime available before performing an insert/Update?

Just to ask the question, have you checked the datatype for those columns in the base table?
--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)

March 31, 2023 at 7:42 pm

#4167711

Viewing 15 posts - 1,666 through 1,680 (of 59,099 total)