Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,901 through 36,915 (of 59,098 total)

RE: Are the posted questions getting worse?

mtillman-921105 (9/10/2010)
The Dixie Flatline (9/10/2010)
I played a lot of Civilization. It took a while, but it finally dawned on me that the barbarians weren't my true enemies....
--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 10, 2010 at 6:48 pm

#1219565
RE: Are the posted questions getting worse?

Grant Fritchey (9/10/2010)
GilaMonster (9/10/2010)
Jeff Moden (9/10/2010)
I don't have the time to read many books but that was a good one.
Title? Author?
Here you go. First in a trilogy. Ancient stuff.
Ah... that's...
--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 10, 2010 at 9:42 am

#1219295
RE: Are the posted questions getting worse?

GilaMonster (9/10/2010)
Jeff Moden (9/10/2010)
I don't have the time to read many books but that was a good one.
Title? Author?
I only remember that the name of the book was called "Collosus"...
--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 10, 2010 at 9:40 am

#1219293
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/10/2010)
Never read about Collosus. I'm assuming this is the Xmen guy?
I always find time to read. Keeps me sane with a break from this world.
Nope... 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)

September 10, 2010 at 9:37 am

#1219292
RE: Single huge view or mutiple smaller views

clementstore (9/10/2010)
Thanks ppl .
Views generated from both approaches are from same set of tables ( over 100 ) and
they are not partitioned. They are generated by some stored procedures on...
--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 10, 2010 at 6:33 am

#1219126
RE: Oracle Wrap like utility in MS-SQL

Gosh... this seems like a lot of work to keep the honest man honest and does nothing to actually prevent the viewing of the code.
--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 10, 2010 at 6:28 am

#1219123
RE: Poor performance when all RAM allocated, but not in use

Heh... P.S. 15 Seconds for a query may still be too long. 😉
--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 10, 2010 at 6:20 am

#1219117
RE: Are the posted questions getting worse?

Grant Fritchey (9/10/2010)
Alvin Ramard (9/9/2010)
Jeff Moden (9/9/2010)
Alvin Ramard (9/9/2010)
Trey Staker (9/9/2010)
Steve Jones - Editor (9/9/2010)
Twitter is a lot like The Thread, only moving at a slightly faster pace.
You can sign...
--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 10, 2010 at 5:48 am

#1219101
RE: CLR Table-Valued Function Example with Full Streaming (STVF)

Matjaz Justin (9/10/2010)
I would like to take advantage of a chance to join to the discussion with a question which is not directly related to the title but I cannot...
--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 10, 2010 at 5:45 am

#1219099
RE: Using DateDiff to calculate days before a Birthday

Sorry, Ken... I was a bit asleep at the switch and forgot this was for the compact edition (heh... "CE" actually stands for "Crippled Edition", doesn't it? :-P)
There's more than...
--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 10, 2010 at 5:42 am

#1219098
RE: Question: float display as character

Chris Morris-439714 (9/9/2010)
Jeff Moden (9/9/2010)
As a side bar, the "2" option I used in the conversion is the 16 byte option for "E" notation. If I'd used "1", 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)

September 10, 2010 at 5:29 am

#1219091
RE: Question: float display as character

Sharon S (9/9/2010)
I see it now - thx again...
You bet... 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)

September 10, 2010 at 5:25 am

#1219088
RE: Are the posted questions getting worse?

jcrawf02 (9/9/2010)
Jason, dialed into the S3oLV meeting tonight, absolutely phenomenal stuff from Stacia Misner on PowerPivot. Are all the meetings like that? 😉 Think I asked more questions over LiveMeeting...
--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 10, 2010 at 5:19 am

#1219083
RE: Calling a UDF

vani_r14 (9/9/2010)
Hi all
Thanks for all your help in the Forum 🙂
I got it figured out and its working now... If any one needs it in case here is what...
--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 10, 2010 at 5:00 am

#1219075
RE: Calling a UDF

vani_r14 (9/8/2010)[hrI have a function called Split and i would like to know - If can call that function in the where clause of Select Statement. This is a 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)

September 10, 2010 at 4:55 am

#1219074

Viewing 15 posts - 36,901 through 36,915 (of 59,098 total)