Jeff Moden

Forum Replies Created

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

RE: sys.dm_db_index_physical_stats

sarahmp - Sunday, January 27, 2019 6:32 AM
Thank you both. The problem was indeed in the quotations.
Thank you for the feedback and...
--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 27, 2019 at 7:27 am

#2020220
RE: Doing the Right Thing

Great article and thoughts, Kathi.
One time after making a really big goof, I thought I was going to catch no end of being yelled at. Still, it was...
--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 26, 2019 at 3:10 pm

#2020200
RE: Fast Enough

Shifting gears a bit but on the same subject, the code at the following link is a prime example of why it takes so long to make changes to database...
--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 26, 2019 at 7:48 am

#2020196
RE: Dim table showing NULL for date field, but source query to load table showing an actual date

This does us no good. You're showing a table missing something and a query that isn't. What you need to show us is the actual code that does 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)

January 25, 2019 at 6:24 pm

#2020188
RE: Dynamically outputting a set of columns based on another Tables records

jcelko212 32090 - Friday, January 25, 2019 1:39 PM
Weegee2017 - Friday, January 25, 2019 9:57 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 4:25 pm

#2020185
RE: Try Catch Best Practice for Large Stored Procedure

When the step fails, you could have it execute a step to send you an email that the job failed. I typically don't do that, though.
What I end...
--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 4:20 pm

#2020184
RE: Are the posted questions getting worse?

Luis Cazares - Friday, January 25, 2019 11:48 AM
drew.allen - Friday, January 25, 2019 9:46 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 4:05 pm

#2020183
RE: DEV - Execution plan IF there were more CPUs

Luis Cazares - Friday, January 25, 2019 2:42 PM
Jeff Moden - Friday, January 25, 2019 2:32 PM
--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 4:04 pm

#2020182
RE: TempDB

sqlfriends - Friday, January 25, 2019 2:23 PM
i am not ignoring the problem. Just want to separate the hdhoc, or self -service...
--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:34 pm

#2020174
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

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