Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,406 through 45,420 (of 59,101 total)

RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Martin Stephenson (1/30/2009)
Great article, I 've been able to apply it to a pain in the neck I've been working on, but at the risk of looking like a thicko...
--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)

January 30, 2009 at 8:35 pm

#935940
RE: count of consecutive value

dubem1 (1/30/2009)
Sure
I have a Student table in relation with an exam table. So each student has done n exams.
Each exam has a final cote (the result code in my...
--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)

January 30, 2009 at 7:22 pm

#935935
RE: How do you archive data?

AH! Now that's more like it! Long live "hoopla"! 😛
--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)

January 30, 2009 at 6:53 pm

#935931
RE: How do you archive data?

Thanks for the success story, Gabriel. Like I said, I've not used partitioned tables in production, yet. From all the hoopla in BOL, I have to say I'm...
--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)

January 30, 2009 at 6:33 pm

#935927
RE: Are the posted questions getting worse?

tosscrosby (1/30/2009)
Uh-Oh, Gail's got a light-saber (SP?)..........time for the DARK SIDE to beware.
New haircut, too... although she might try using a little face wax. 😛
--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)

January 30, 2009 at 6:15 pm

#935926
RE: OPENROWSET select statement performance -- runs in 4 seconds on test server vs. 3 minutes on production server.

If someone or something has the file open when your code runs, it will give such an error message. Bouncing the server seems to clear it because the file...
--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)

January 30, 2009 at 5:53 pm

#935919
RE: Calculating UnitPrice Discounts

Correct... and a 30% discount rate would mean you only pay 70% of the unit price and that's the other reason for the 1... you subtract 30% (0.3) from 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)

January 30, 2009 at 12:24 pm

#935782
RE: count of consecutive value

Thanks, Martin... if someone doesn't beat me to it, I'll give it a whirl after work.
--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)

January 30, 2009 at 9:43 am

#935669
RE: What are the Party Plans?

jgrubb (1/30/2009)
Lynn Pettis (1/29/2009)
Jeff Moden (1/29/2009)
jgrubb (1/29/2009)
Completely Off-Topic, I wanted to see who started the Pork Chop thing,
Heh... do you really have to wonder? 😛
Cardinal Moden himself,...
--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)

January 30, 2009 at 9:41 am

#935667
RE: Are the posted questions getting worse?

Sounds like a lot of fun but, consider this, would you like it if your post and name showed up on a "Twit List". Bad enough they show up...
--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)

January 30, 2009 at 9:25 am

#935651
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Thanks for the detailed explanation... I'll take a look tonight after I get home.
--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)

January 30, 2009 at 6:04 am

#935454
RE: Multiple Resultset in a single resultset (UNION)

See the following...
http://www.sqlservercentral.com/articles/Test+Data/61572/
Better question would be, what are you really concatenating and why?
--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)

January 29, 2009 at 11:56 pm

#935312
RE: tempdb - Restricted File Growth option

You can shrink temp DB through the GUI without bouncing the server or the service.
My question would be... what's causing it to grow to 50GB? There's definately something like...
--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)

January 29, 2009 at 11:52 pm

#935311
RE: Determining whether a Stored Procedure returns a resultset

krayknot (1/29/2009)
PhilPacha (1/28/2009)
A former co-worker has asked this question; I admit, I'm a bit intrigued.
Given the name of a stored procedure, is there an “efficient” way to determine...
--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)

January 29, 2009 at 11:44 pm

#935310
RE: records with distinct IDs

rog pike (1/29/2009)
nabajyoti.b (1/28/2009)
the record that appears first in order
select emp_id,emp_name,emp_address,rank
from
(select emp_id,emp_name,emp_address,
row_number()over(partition by emp_address order by emp_name) as rank
from ##emp) as A
where rank=1
order by emp_address,emp_name
emp_id emp_name ...
--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)

January 29, 2009 at 10:56 pm

#935296

Viewing 15 posts - 45,406 through 45,420 (of 59,101 total)