Jeff Moden

Forum Replies Created

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

RE: Collapsing a Table

BWAA-HAA!!!! I just realized the "Deep Dive" method is nothing more than the now old "difference between two sets of ROW_NUMBER()'s trick. Stupid me for not thinking 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)

May 31, 2010 at 7:45 pm

#1174615
RE: Collapsing a Table

WayneS (5/31/2010)
This post is just to include an alternate method. I haven't tested the various methods, but I believe that the "Quirky Update" solution that Jeff presented will probably be...
--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)

May 31, 2010 at 7:39 pm

#1174614
RE: Retrieve Previous Available Date Records

vijay.s (5/30/2010)
Paul White NZ (5/29/2010)
This version is more efficient:
SELECT This.ClientCode,
This.FlowDate,
This.TempletID,
...
--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)

May 31, 2010 at 6:18 pm

#1174607
RE: DBA, phantom job title?

David.Poole (5/30/2010)
Even the best designed database system is going to crack under the pressure of that much data.
Heh... it hasn't yet. 😛
--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)

May 31, 2010 at 6:10 pm

#1174606
RE: Collapsing a Table

Not to worry... I was going down the same path before I gave in to the lure of the Quirky Update.
--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)

May 31, 2010 at 5:45 pm

#1174605
RE: Set based approach to get previous rows value for same column which is a calculation

You bet. Thanks for the feedback and thanks for listening. Gotta run, though... I've gotta call OSHA and tell them handrails won't be necessary. 😛
--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)

May 31, 2010 at 4:36 pm

#1174602
RE: Collapsing a Table

Heh... dammit. I almost didn't post my solution for fear of just that. I really wanted to see a good self referencing solution.:pinch:
--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)

May 31, 2010 at 4:22 pm

#1174600
RE: Collapsing a Table

Here's my take on the problem... sometimes ya just gotta cheat to keep it both simple and fast. 😛
declare @rangeTable table (start int, [end] int PRIMARY KEY CLUSTERED, MinStart...
--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)

May 31, 2010 at 4:08 pm

#1174597
RE: cluster agents

@charipg,
I agree with Gail and I think that's the key to answering this question. What kind of clustering are you talking about?
I don't believe the original question you were...
--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)

May 31, 2010 at 3:05 pm

#1174594
RE: cluster agents

Lynn Pettis (5/30/2010)
Though worded differently, this looks like a cross post. Please post any answers here.
I agree... same question. I have a possible answer and I'll post 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)

May 31, 2010 at 2:56 pm

#1174593
RE: Set based approach to get previous rows value for same column which is a calculation

all4miller (5/31/2010)
Thanks for commenting Jeff. I actually got my result from the The ‘Subscription List’ SQL Problem but since the part I used is essentially the same as your post...
--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)

May 31, 2010 at 2:33 pm

#1174590
RE: Collapsing a Table

lmu92 (5/31/2010)
I'm not sure if this is the fastest way, but at least it's an option... 😉
That seems to loose the bubble when the ranges on the same row are...
--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)

May 31, 2010 at 2:03 pm

#1174585
RE: SQL Server Training

saiphanindrait (5/31/2010)
Hello Ali,
This is Sai Phanindra and working as Production DBA in one of the top MNCs in India. I have been providing trainings during my free times. The course...
--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)

May 31, 2010 at 11:27 am

#1174565
RE: Set based approach to get previous rows value for same column which is a calculation

all4miller (5/31/2010)
NB# I'm not sure if the top and order by are enough to guarantee the correct order if someone can comment on that will be great
Heh... I'm thinking 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)

May 31, 2010 at 11:17 am

#1174562
RE: ADD column storeID while bulk inserting

I guess I wouldn't do it that way then. Have you tried the code I posted?
--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)

May 31, 2010 at 10:50 am

#1174554

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