Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,126 through 13,140 (of 59,095 total)

RE: best practice recommendations requested after data purge

SQLJay - Wednesday, January 17, 2018 9:34 AM
Jeff and Sue,
thank you for the recommendations. We'll start looking into index defragmentation and update...
--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 17, 2018 at 9:44 am

#1976148
RE: It's Not Yours

Steve Jones - SSC Editor - Wednesday, January 17, 2018 8:09 AM
Jeff Moden - Wednesday, January 17,...
--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 17, 2018 at 9:33 am

#1976145
RE: It's Not Yours

patrickmcginnis59 10839 - Wednesday, January 17, 2018 8:32 AM
Jeff Moden - Wednesday, January 17, 2018 6:56 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 17, 2018 at 9:28 am

#1976144
RE: It's Not Yours

The title of this article is "Its not yours". While I definitely agree with that, I'm the DBA for the company I work for. That means that I'm charged with...
--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 17, 2018 at 6:56 am

#1976114
RE: Are the posted questions getting worse?

Sergiy - Tuesday, January 16, 2018 7:48 PM
Online shopping leaves number of traces.Which can be used in police investigation in case 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)

January 17, 2018 at 6:50 am

#1976111
RE: SQL Server Unused Index Script

Sue_H - Tuesday, January 16, 2018 12:11 PM
Jeff Moden - Tuesday, January 16, 2018 11:41 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 17, 2018 at 6:35 am

#1976109
RE: Transaction log issue

WhiteLotus - Tuesday, January 16, 2018 5:13 PM
Guys...
I think I need to change the autogrowth setting as currently is very small ....
--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 16, 2018 at 6:06 pm

#1976085
RE: Transaction log issue

RandomStream - Tuesday, January 16, 2018 5:33 PM
How do you know that there is no open transaction?
Auto growth rate has nothing...
--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 16, 2018 at 6:02 pm

#1976084
RE: auditing using extended events

fizzleme - Tuesday, January 16, 2018 11:10 AM
Ok. Thanks for the advice. This sounds like a pain. However we need to determine...
--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 16, 2018 at 11:47 am

#1976031
RE: Use inserted identity field value to link to identity field from source table question.

You can certainly do this with OUTPUT or MERGE.... the trick is that you need something in your insert to be common with the original table you're inserting from 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 16, 2018 at 11:45 am

#1976030
RE: SQL Server Unused Index Script

Agreed. I've reported this as a "Terms of use" violation for possible plagiarism. It explains a lot about several of this user's recent posts not having any decent information about...
--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 16, 2018 at 11:41 am

#1976029
RE: Running out of space on Server OS drive, where SQL Server app located, what to clear out?

Eric M Russell - Tuesday, January 16, 2018 10:30 AM
I use tool on my personal PC to keep tabs on disk space...
--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 16, 2018 at 11:23 am

#1976027
RE: Unable to shrink Database

jjimenez-1040959 - Tuesday, January 16, 2018 8:04 AM
Jeff Moden - Tuesday, January 16, 2018 7:32 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 16, 2018 at 8:12 am

#1975995
RE: Customize Software or Process

The other issue is of a huge concern and generally a huge PITA for users and that can all be described in a simple, very well worn statement...
"Change...
--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 16, 2018 at 8:01 am

#1975992
RE: Unable to shrink Database

Ah... and to add to that, shrinking a file or a database causes a type of fragmentation that can actually cripple the database. If you shrink a file or 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 16, 2018 at 7:53 am

#1975990

Viewing 15 posts - 13,126 through 13,140 (of 59,095 total)