Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,741 through 46,755 (of 59,101 total)

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
RE: how to recursively do this?

Yihong (12/7/2008)
Thank you guys, it worked beautifully in my code.
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 7, 2008 at 9:50 am

#908934
RE: how to recursively do this?

Ken Simmons (12/7/2008)
Thanks Jeff.
I knew there was a way to do it without the math, I just cound't think of it last night.
S'ok... Heh... not much coffee at night. 😛
--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 9:49 am

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

Replace the derived table in the from clause with your real table...
SELECT PARSENAME(d.IpAddr,4) As ColA,
PARSENAME(d.IpAddr,3) As ColB,
...
--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 6, 2008 at 11:44 pm

#908902
RE: Optimum Backup Strategy

Are you saying that [font="Arial Black"]all [/font]the T_R tables are Truncated before data is added? If so, then, yeah, you could go to SIMPLE recovery mode. Keyword is...
--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 6, 2008 at 11:40 pm

#908901
RE: how to recursively do this?

If you throw in the appropriate partition clause, it get's even simpler...
Declare @t Table(i int)
Insert Into @t
Select 1
Union All
Select 1
Union All
Select 1
Union All
Select 2
Union All
Select 2
Union All
Select 3
Union All
Select 3
Union...
--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 6, 2008 at 11:31 pm

#908900
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Very cool... 2 seconds huh? That was going to be my next question. What kind of hardware are you running? I'm running a 6 year old P4...
--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 6, 2008 at 11:22 pm

#908899
RE: Which is better

Heh... what I'd like to do is to be able to show emoticons AND leave a hanging parenthesis in the same post. None of the emoticons use just a...
--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 6, 2008 at 9:31 pm

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

This will fly... even in the face of a million rows...
--===== Create the same test data as before.
-- This is NOT part 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)

December 6, 2008 at 9:08 pm

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

Um... I'm thinking that's not what you want. Look at the ACTUAL execution plan for that... tell me where, with only 11 rows in the original table, you come...
--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 6, 2008 at 7:30 pm

#908890

Viewing 15 posts - 46,741 through 46,755 (of 59,101 total)