Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,946 through 9,960 (of 59,093 total)

RE: DEV - Execution plan IF there were more CPUs

Davis H - Friday, January 25, 2019 1:19 PM
I am completely on board with everything said. My issue is we have 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)

January 25, 2019 at 2:32 pm

#2020172
RE: Move clustered index to a new filegroup

as1981 - Friday, January 25, 2019 12:27 PM
Hello,
Thanks for your help. I'd thought before that the amount of fragmentation seemed high but wasn't...
--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)

January 25, 2019 at 2:24 pm

#2020170
RE: Move clustered index to a new filegroup

as1981 - Friday, January 25, 2019 10:05 AM
s Hello,
Thanks for your help. Sorry I don't recognise the abbreviation BASF?
My maintenance plan (runs...
--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)

January 25, 2019 at 11:13 am

#2020152
RE: Fast Enough

patrickmcginnis59 10839 - Friday, January 25, 2019 9:25 AM
Jeff Moden - Thursday, January 24, 2019 9:34 AM
--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)

January 25, 2019 at 10:07 am

#2020143
RE: Move clustered index to a new filegroup

as1981 - Friday, January 25, 2019 9:01 AM
Hello,
Thanks for your help. The statement for the largest table is here:
--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)

January 25, 2019 at 9:55 am

#2020138

RE: Move clustered index to a new filegroup

as1981 - Friday, January 25, 2019 8:15 AM

With regards to the fill factor. That's something I've been investigating but not really decided...

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

January 25, 2019 at 8:39 am

#2020118

RE: Move clustered index to a new filegroup

as1981 - Friday, January 25, 2019 7:29 AM

Hello,

Apologises. I should have posted code. It's just SSMS generated code altered to specify the...

--Jeff Moden

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)

January 25, 2019 at 7:39 am

#2020113

RE: Move clustered index to a new filegroup

Hold on a minute... HOW are you trying to do the move? What code?

--Jeff Moden

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)

January 25, 2019 at 7:24 am

#2020110

RE: RPC:Completed in SQL Profile, but the data is not updated

Gamleur84 - Friday, January 25, 2019 12:10 AM

Thank you for all the input.

I know it seems that I am not looking...

--Jeff Moden

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)

January 25, 2019 at 6:20 am

#2020096

RE: DEV - Execution plan IF there were more CPUs

The trouble is that you can look at execution plans all day and still have problems because even actual execution plans are riddled with estimates. The only method to accurately...

--Jeff Moden

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)

January 25, 2019 at 6:09 am

#2020093