Jeff Moden

Forum Replies Created

Viewing 15 posts - 901 through 915 (of 59,063 total)

Reply To: Tempdb: is it being used?

dopydb wrote:
Jeff
look at my reply above , thats a five day window!
the scripts i use for indexing are just the standard ola hallengren scripts
And as i said, normal erp sql...
--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)

November 29, 2023 at 3:45 am

#4336368
Reply To: Best Practice for character replacement within Table.Column

YSLGuru wrote:
Jeff - that's what I am doing now, just using Replace(). I wanted to know if there was a better way to do it and so far it looks...
--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)

November 28, 2023 at 6:25 pm

#4336115
Reply To: Tempdb: is it being used?

You're looking at a 10 minute span of time for TempDB. Was that span of time during your long winded run?
You also say that "i run decent index routines nightly". ...
--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)

November 28, 2023 at 5:20 pm

#4336109
Reply To: SQL runs slow in a union all statement

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Check the 3 underlying views. If they're all pulling from the same tables, it might be worth while to crib some of the code and write a separate...
--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)

November 27, 2023 at 7:01 pm

#4335400
Reply To: Commit transaction inside loops

PHXHoward wrote:
Hello, our users are complaining about blocking during a delete loop so I'm thinking that adding begin tran; and commit tran; inside the loops would allow the other queries...
--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)

November 27, 2023 at 6:55 pm

#4335397
Reply To: SQL runs slow in a union all statement

Check the 3 underlying views. If they're all pulling from the same tables, it might be worth while to crib some of the code and write a separate query, especially...
--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)

November 27, 2023 at 6:13 am

#4334993
Reply To: Sequentially update a column with a decrementing value

leesider wrote:
OK sorry about that (and for the duplicate post)
Heh... I can just imagine what's going through your mind... "But I posted it on the [Working in Oracle] forum".
One 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)

November 25, 2023 at 3:14 am

#4333970
Reply To: SPID 0 is blocking some SPID.

LearningDBA wrote:
This is the 1st time I have seen some sessions blocked by SPID 0. Does anyone know what this zero session is?
Where are you getting this information from???
SPID 0...
--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)

November 24, 2023 at 3:40 pm

#4333741
Reply To: Primary key column question

You could use the table designer in SSMS. It will allow you to "move" it. Be advised that, behind the scenes, it will create a new table, copy the data...
--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)

November 24, 2023 at 4:47 am

#4333419
Reply To: Singular or Plural

Aaron N. Cutshall wrote:
From one perspective, it really doesn't matter which method you choose as long as you're consistent. However, if you choose pluralism, it becomes difficult to maintain consistency.
For example, 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)

November 24, 2023 at 4:43 am

#4333418
Reply To: IMPLICIT TRANSACTIONS

Just to summarize:
https://www.brentozar.com/archive/2018/02/set-implicit_transactions-one-hell-bad-idea/
--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)

November 23, 2023 at 6:02 pm

#4333221
Reply To:

This extremely open ended question seems like a prelude to SPAM to me.
If it's not a prelude to SPAM, I suggested you take a look at the courses offered by...
--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)

November 23, 2023 at 5:55 pm

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

Steve Jones - SSC Editor wrote:
lol.
Not sure we'd get tickets for posters, but it's not a bad idea.
I agree on fixing some things. Quite a few were delayed because of upgrade work. (Linux->Wordpress->Nami->Forums) all...
--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)

November 23, 2023 at 4:34 pm

#4333178
Reply To: IX rebuilds, stats , stats with full scan
Just a few "litmus strip" questions to start with:
1. What is the exact call code that you're using to call Ola's script? (Please post it for the database in question...
--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)
November 23, 2023 at 4:28 pm

#4333170
Reply To: Best Practice for character replacement within Table.Column

All-righty then...
You say that you want all of the special characters to be replaced by spaces except for "&" to be replaced by "+" and "=" to be replaced by...
--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)

November 23, 2023 at 4:31 am

#4332816

Viewing 15 posts - 901 through 915 (of 59,063 total)