Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,311 through 14,325 (of 59,101 total)

RE: Are the posted questions getting worse?

Eirikur Eiriksson - Friday, September 15, 2017 6:36 AM
paul s-306273 - Friday, September 15, 2017 4:21 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)

September 15, 2017 at 6:09 pm

#1959680
RE: Are the posted questions getting worse?

paul s-306273 - Friday, September 15, 2017 4:21 AM
Jeff Moden - Thursday, September 14, 2017 9:10 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)

September 15, 2017 at 6:06 pm

#1959679
RE: The struggle to renormalize data

Ah... ok. Then we're still talking about the same methodology of having some "unique" single character delimiter. The unfortunate part of using a pipe or any other character and "standard"...
--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)

September 15, 2017 at 5:58 pm

#1959676
RE: Fill Factor on Clustered Index

The FILL FACTOR really only comes into play if you make the mistake of rebuilding or reorganizing the Clustered Index. Stop that and let the "Natural Fill Factor" be 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)

September 15, 2017 at 11:05 am

#1959635
RE: The struggle to renormalize data

Ed Wagner - Thursday, September 14, 2017 9:13 PM
Jeff Moden - Thursday, September 14, 2017 5:38 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)

September 14, 2017 at 10:35 pm

#1959535
RE: Are the posted questions getting worse?

Jeff Moden - Thursday, September 14, 2017 7:39 PM
Jeff Moden - Thursday, September 14, 2017 7:37 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)

September 14, 2017 at 9:10 pm

#1959533
RE: Are the posted questions getting worse?

Jeff Moden - Thursday, September 14, 2017 7:37 PM
Steve Jones - SSC Editor - Thursday, September 14,...
--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)

September 14, 2017 at 7:39 pm

#1959529
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, September 14, 2017 7:06 PM
Jeff Moden - Thursday, September 14,...
--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)

September 14, 2017 at 7:37 pm

#1959528
RE: Determining Memory Pressure

GilaMonster - Thursday, September 14, 2017 12:09 PM
Jeff Moden - Thursday, September 14, 2017 6:52 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)

September 14, 2017 at 5:42 pm

#1959522
RE: The struggle to renormalize data

ManicStar - Thursday, September 14, 2017 11:28 AM
I loathe json... don't see the point of it over XML or even flat files.
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)

September 14, 2017 at 5:38 pm

#1959521
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, September 14, 2017 2:15 PM
Lynn Pettis - Thursday, September 14,...
--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)

September 14, 2017 at 5:36 pm

#1959520
RE: Date Causing Problem

ScottPletcher - Thursday, September 14, 2017 3:31 PM
As an aside, I suggest you use >= and < for all date/time/datetime comparisons rather...
--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)

September 14, 2017 at 5:33 pm

#1959519
RE: Forum Etiquette: How to post data/code on a forum to get the best help

drew.allen - Thursday, September 14, 2017 7:44 AM
stanteitelbaum - Thursday, September 14, 2017 6:05 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)

September 14, 2017 at 8:12 am

#1959441
RE: New company use c# code instead of SSIS

Given my own lead, I'd avoid both methods and do it all in T-SQL but the C# method doesn't sound bad. I just like to avoid compiled code for such...
--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)

September 14, 2017 at 7:17 am

#1959418
RE: Date Causing Problem

r5d4 - Thursday, September 14, 2017 4:08 AM
Ah, I thought I'd avoided Sargability by not manipulating my date column, only the GETDATE()...
--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)

September 14, 2017 at 7:15 am

#1959417

Viewing 15 posts - 14,311 through 14,325 (of 59,101 total)