Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,421 through 42,435 (of 59,102 total)

RE: A script I was working on. Your thoughts and opinions?

shannonjk (8/9/2009)
The original took about 40 minutes.
The current is still running but running right now at an hour and 25 minutes.
I appreciate all the help 🙂
I'd just go ahead...
--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)

August 9, 2009 at 7:44 pm

#1036566
RE: Self Join

Chuck Lucking (8/9/2009)
This would be the max(PhoneNumber) for each EmployeeID and PhoneType.
You just about wrote the query with that statement...
SELECT EmployeeID, PhoneType, MAX(PhoneNumber) AS PhoneNumber
FROM EmpPhone
...
--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)

August 9, 2009 at 7:37 pm

#1036565
RE: A script I was working on. Your thoughts and opinions?

Not good. I don't know if you've reached that "tipping point" I was talking about or if it's just that we're self-joining a 5.4 million row table. Can...
--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)

August 9, 2009 at 7:29 pm

#1036563
RE: problem with query to update based on value in previous row

RichSmith (8/9/2009)
This worked beautifully. The results of the query were exactly what was expected. Thank you so much. Now, I need to go through it all and figure...
--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)

August 9, 2009 at 7:19 pm

#1036562
RE: How to divide results into two somewhat-equal piles?

Sorry folks... I'm just a bit sour on things like this. We had one guy at work that would get other people to help him do his work while...
--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)

August 9, 2009 at 7:03 pm

#1036560
RE: Formatting issue with a calculated value

Heh... kewl. 🙂 In that case, I stand corrected.
--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)

August 9, 2009 at 6:58 pm

#1036558
RE: Formatting issue with a calculated value

Do you know of anything that you can use in SELECT/INTO that will create a float column that isn't specifically cast as a float?
--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)

August 9, 2009 at 6:34 pm

#1036553
RE: Formatting issue with a calculated value

Paul White (8/9/2009)
Jeff Moden (8/9/2009)
No need for rounding if you're going to cast the answer...
Hey Jeff,
Valid point, but let me explain myself: I left the ROUND in for two reasons:
1....
--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)

August 9, 2009 at 6:14 pm

#1036549
RE: How to divide results into two somewhat-equal piles?

Paul White (8/9/2009)
(@Beverley: Jeff is kidding)
Heh... not quite. 😉
--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)

August 9, 2009 at 6:12 pm

#1036548
RE: problem with query to update based on value in previous row

First of all, take a look at the article at the first link in my signature line at the bottom of this post. Then take a look at 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)

August 9, 2009 at 6:01 pm

#1036546
RE: problem with query to update based on value in previous row

RichSmith (8/9/2009)
Can anyone help me get this to work as a recursive query in SQL Server 2000?
Nope... but I can show you the right way. 😉 Gimme a couple...
--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)

August 9, 2009 at 4:47 pm

#1036536
RE: hour and time dim

mesql (7/29/2009)
I have two time demission in my warehouse
One is the the time dim and the hour dim
In the time dim I have timeid, fulldate (2000-01-05 00:00:00.000) month...
--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)

August 9, 2009 at 4:43 pm

#1036535
RE: Joining on view with a group by or distinct causes slow query

If you need all the columns from all 3 of the tables, I'm not sure you'll ever be able to make it as snappy as you'd like for a view......
--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)

August 9, 2009 at 4:34 pm

#1036534
RE: Cant see the wood for the trees ! ...help on query please

Heh... I like the last line of that conversation except that's normally where I break out the pork chops with the bone in them. 😛 Getting back 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)

August 9, 2009 at 4:25 pm

#1036533
RE: A script I was working on. Your thoughts and opinions?

Thanks for the feedback. 5.4 million rows, eh? If the solution I posted takes longer than, ummm... 40 seconds or so, post back... there's a little trick we...
--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)

August 9, 2009 at 2:33 pm

#1036524

Viewing 15 posts - 42,421 through 42,435 (of 59,102 total)