Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,726 through 46,740 (of 59,095 total)

RE: Replacing multiple occurrences of a string in a text column

Dan Epps (12/7/2008)
Jeff Moden (12/6/2008)
Can't the TEXT column be changed to a VARCHAR(MAX) column?
Not without tons of mods the the forum software. We're only talking about a half-million or...
--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)

December 8, 2008 at 7:57 pm

#909423
RE: UPDATE SET =NULL running over an hour

Same here... thanks for the feedback. Sorry I got side tracked...
--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)

December 8, 2008 at 7:45 pm

#909421
RE: Cursor Help

No apology necessary... I'm not the one that just put a cursor into production.
--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)

December 8, 2008 at 7:42 pm

#909419
RE: The Exceptional DBA: Soft Skills

'Zactly... 🙂
--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)

December 8, 2008 at 7:21 pm

#909418
RE: finding min/max while data remains unchanged

Oblio Leitch (12/8/2008)
Jeff,
That looks pretty good, but I was just working with a reduced dataset as an example. I need to expand it to use groups of IDs. ...
--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)

December 8, 2008 at 7:10 pm

#909417
RE: finding min/max while data remains unchanged

rbarryyoung (12/8/2008)
Dang, every time I see that "NOT EXISTS using a JOIN" trick, I think that it's a No-Op and I take it out... 🙁
Anyway, this corrected version gives...
--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)

December 8, 2008 at 7:08 pm

#909416
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

rbarryyoung (12/8/2008)
Kris (12/8/2008)
The reason it must dragged into a spread sheet is because researcher want to be able to extract the data from the DB and perform statistical analysis 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)

December 8, 2008 at 7:01 pm

#909415
RE: Cursor Help

Alan Naylor (12/8/2008)
Ths is the correct solution.
No... it's not... not if it has a cursor in it. 😉 But, if you would rather do that than posting 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)

December 8, 2008 at 12:36 pm

#909307
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Kris (12/8/2008)
Do you have any advice on increasing the performance of this query?
Heh... yeah... use the CrossTab code instead. 😉
The reason it must dragged into a spread sheet is because...
--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)

December 8, 2008 at 12:28 pm

#909304
RE: finding min/max while data remains unchanged

rbarryyoung (12/7/2008)
Actually, a couple of tweaks to noel's version will make it much better:
You need to check the output on that... 😉
--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)

December 8, 2008 at 5:44 am

#909102
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Kris (12/5/2008)
Revised post:
Is it save to assume that both Pivot and Cross Tabs preform better than tabulating the data from a view that inner joins the table on itself for...
--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)

December 8, 2008 at 5:07 am

#909089
RE: How to place IP address(one field) into different fields.

Suraj (12/7/2008)
Thank you Jeff.
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)

December 8, 2008 at 4:54 am

#909082
RE: How to place IP address(one field) into different fields.

Bob Hovious (12/7/2008)
Jeff, I would never have thought to use parsename on an IP address, but it makes perfect sense because it has four elements separated by periods. ...
--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)

December 8, 2008 at 4:54 am

#909081
RE: Optimum Backup Strategy

leonp (12/7/2008)
Thanks a lot you all!
To Jeff's question -
T_r data is never truncated - it has a few DMLs issued very infrequently
To Gail/Krishna's question -
As I understand, since...
--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)

December 7, 2008 at 10:15 am

#908941
RE: Error processing

Patricia Monreal (12/7/2008)
Thank you for your detailed reply. I think I understand what you are saying when you say that I am thinking procedurally and not terms of sets. I...
--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)

December 7, 2008 at 10:09 am

#908938

Viewing 15 posts - 46,726 through 46,740 (of 59,095 total)