Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 59,067 total)

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, 2 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, 2 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
Reply To: Shrink Database Log Files One by One

Manie Verster wrote:
Thank you all for the comments. I know my code still needs some tweaking. This was a learning process for me. I have in the meantime tried to get...
--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:37 pm

#4167710
Reply To: Shrink Database Log Files One by One

Manie Verster wrote:
@jeff Moden, I thank you from my heart for your comment. I greatly respect you and have certainly learned a lot from you. There are no backups because these...
--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:28 pm

#4167709
Reply To: T-SQL Recursive CTE not completing at last record
I'm curious... why do you think you need any form of looping for this?
```
SELECT CONCAT('MERGE ',ChannelReadingTableName,' USING ',MainLevelDataTableName)
  FROM #DeviceChannel
```
And, be aware... I used the 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 4:26 pm

#4167652
Reply To: slow processing

If you look at the number of reads, there's over 7 billion logical reads. That's more than 56 TERAbytes of I/O.
My first suggestion is to stop the query because it's...
--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 4:03 pm

#4167648
Reply To: How do you Sprint?

below86 wrote:
For example, an SSRS reports reads from a table the isn't one of the 'core' tables. So I have to research where it is created, find it is created...
--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 3:47 pm

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

CozzaroNero wrote:
When it’s written “free ebook to download”, I’m expecting to be free of cost not freely able to download and pay for a ebook…
I was just going to write...
--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 3:37 pm

#4167620
Reply To: Shrink Database Log Files One by One

Johan Bijnens wrote:
Keep in mind, your LOG file(s) may not shrink at first attempt !!!
ref Shrink a log file
Even there, they don't mention that you should do a CHECKPOINT first...
--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 6:18 am

#4167372

Viewing 15 posts - 1,636 through 1,650 (of 59,067 total)