Jeff Moden

Forum Replies Created

Viewing 15 posts - 931 through 945 (of 59,082 total)

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
Reply To: Best Practice for character replacement within Table.Column

YSLGuru wrote:
Is there a better/more efficient way to do what the below does? It is replacing several characters that are known to be problematic for this table/column(s) with a space.
BONUS...
--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 3:59 am

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

Steve Jones - SSC Editor wrote:
Registration isn't open, but you can sign up: https://passdatacommunitysummit.com/twentyfour/
That way you can get the lowest price when it opens.
I do think they're pretty good about moving registration 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)

November 22, 2023 at 3:47 am

#4332164
Reply To: Pivot data without aggregating
Just a suggestion... Keep It Super Simple and flexible at the same time.
Here's the test table (not part of the solution):
```
   DROP TABLE IF EXISTS #TestTable;
GO
 SELECT *
  ...
```
--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 22, 2023 at 3:36 am

#4332161
Reply To: FAIL_PAGE_ALLOCATION

andreas.kreuzberg wrote:
We do Statistic Updates every 6h, maybe we should do this more often?
Hopefully, you're REALLY selective about which stats get updated.
--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 21, 2023 at 1:51 am

#4331418
Reply To: Scheduling SQL Agent Jobs on Alternating Weeks

Actually, it could be simplified even more. Since it always tries to run on Thursdays, we don't need to figure that out. We just need to figure out if 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)

November 21, 2023 at 1:41 am

#4331415
Reply To: Recovery Point Objective (RPO)

Totally agreed.
--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 20, 2023 at 11:08 pm

#4331372

Viewing 15 posts - 931 through 945 (of 59,082 total)