Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,131 through 20,145 (of 59,098 total)

RE: Are the posted questions getting worse?

Eirikur Eiriksson (7/14/2015)
Brandie Tarvin (7/14/2015)
So I'm testing a quick bit of code on a dev version of our bigger reporting database and it found something on the first table it...
--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)

July 14, 2015 at 7:26 pm

#1812515
RE: Are the posted questions getting worse?

Lynn Pettis (7/13/2015)
OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running to 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)

July 14, 2015 at 9:01 am

#1812348
RE: Extract the titles from XML

Eirikur Eiriksson (7/14/2015)
Jeff Moden (7/14/2015)
That IS a good use of XML and, now that you've brought that bit of computational agony up, it's possible that I might do the same...
--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)

July 14, 2015 at 8:56 am

#1812345
RE: Page Life Expectancy drops like a rock at several points throughout the day

mortalic (7/14/2015)
This is probably the larger issue isn't it?
Yes. I'd say so.
You might also want to run the similar report for CPU.
--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)

July 14, 2015 at 8:54 am

#1812344
RE: Extract the titles from XML

mister.magoo (7/13/2015)
Jeff Moden (7/13/2015)
However it does belong in the db, and there are valid cases for it. I might have data like this list of books, perhaps it's old 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)

July 14, 2015 at 7:36 am

#1812316
RE: Trust People

GoofyGuy (7/13/2015)
Jeff Moden (7/13/2015)
GoofyGuy (7/13/2015)
It is a great read, and starts out by talking about the Gauls and their sacking of Rome in 4BC with a superior army.
The Gauls...
--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)

July 13, 2015 at 3:55 pm

#1812163
RE: Page Life Expectancy drops like a rock at several points throughout the day

mortalic (7/13/2015)
Jeff, no, there was no performance issue reported. Our user base is pretty vocal about that too. Cache hit ratio didn't drop very much during that time,...
--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)

July 13, 2015 at 3:42 pm

#1812159
RE: Trust People

GoofyGuy (7/13/2015)
It is a great read, and starts out by talking about the Gauls and their sacking of Rome in 4BC with a superior army.
The Gauls sacked Rome in...
--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)

July 13, 2015 at 3:32 pm

#1812155
RE: Extract the titles from XML

Steve Jones - SSC Editor (7/13/2015)
Storing data in XML ...{snip}... allows for flexibility in format, something that tends to be more problematic with flat files.
People keep saying that but I've...
--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)

July 13, 2015 at 3:25 pm

#1812153
RE: Extract the titles from XML

Eirikur Eiriksson (7/13/2015)
Jeff Moden (7/13/2015)
The correct answer isn't actually available. The correct answer should be to "hunt down the moroff that used XML to transmit purely flat data 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)

July 13, 2015 at 3:05 pm

#1812145
RE: Challenge - dynamically load any file

Abhijit More (7/13/2015)
thxs Lowell the only concern I have in my files it may or may not have headers as well some file has Row Delimiter "CR LF"" and some...
--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)

July 13, 2015 at 9:09 am

#1812025
RE: Challenge - dynamically load any file

Abhijit More (7/13/2015)
Jeff I have considered excel as simple table format columns and rows...no formatting is consider in my scri[t. probably after some tweaking it may work:-)
Thanks for the feedback,...
--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)

July 13, 2015 at 9:05 am

#1812023
RE: Challenge - dynamically load any file

Lowell (7/13/2015)
lol Jeff that's evil;
i could do it with Excel Automation in a script task, but all the columns would end up being "column1" "column2" because the first row does...
--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)

July 13, 2015 at 9:05 am

#1812021
RE: Data Loss or Downtime

kelly.bailey (7/13/2015)
I know this was a re-run of an old editorial, but...
How should people be using data? In general:
1) Big important strategic decisions should be made using...
--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)

July 13, 2015 at 9:01 am

#1812020
RE: Extract the titles from XML

TomThomson (7/13/2015)
Jeff Moden (7/13/2015)
The correct answer isn't actually available. The correct answer should be to "hunt down the moroff that used XML to transmit purely flat data and introduce...
--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)

July 13, 2015 at 8:49 am

#1812011

Viewing 15 posts - 20,131 through 20,145 (of 59,098 total)