Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,101 through 20,115 (of 59,072 total)

RE: Are the posted questions getting worse?

Eirikur Eiriksson (7/15/2015)
Ah, now I get it, migrate from one version of SQL Utopia to another:hehe:
😎
Or one version of ANSI Utopia to another. 😀 ANSI and ISO standards...
--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 15, 2015 at 8:16 am

#1812644
RE: Records per hour within a time span

Sorry... made a pretty bad mistake. Post withdrawn.
--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:10 pm

#1812521
RE: Records per hour within a time span

laudena (7/14/2015)
What about something like this?
SELECT month(DateField) as DteFld_Month, DAY(DateField) AS DteFld_Day, { fn HOUR(DateField) } AS DteFld_Hour, COUNT(MeasMyID) AS DupCount
FROM ...
--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:00 pm

#1812519
RE: Records per hour within a time span

daveb-840383 (6/22/2010)
I want an hourly count, but just the current day. The current day will always be the day of the stop time. I want to force the start 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 14, 2015 at 7:56 pm

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

Viewing 15 posts - 20,101 through 20,115 (of 59,072 total)