Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,821 through 32,835 (of 59,099 total)

RE: Back in the saddle

In that case, lookup the new ranking functions. ROW_NUMBER() has revolutionized the ease with which formally complex queries can now be resolved.n The read up on Common Table...
--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 18, 2011 at 9:35 pm

#1370517
RE: Improving Delete Performance

Gosh... I just thought of this... if all these things are properly FK'd (heh... if that doesn't sound like an HR violation, I don't know what does), then what would...
--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 18, 2011 at 9:18 pm

#1370510
RE: Add a range of scores to a parameter

fergusoj (8/18/2011)
I used a case statement in a dataset: CASE WHEN PGM_HRS_ERN BETWEEN '10.00' AND '19.00' THEN '10.00-19.00' ....etc. to give me the ranges:>=45.00, 30.00-44.00, 20.00-29.00 and 10.00-19.00.
When 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)

August 18, 2011 at 9:08 pm

#1370508
RE: TSQL question

Ummm... so what do you want done if the following row is add to the rows you posted?
INSERT INTO TestTable(ParentId,ChildId,RecordType) Values('8','20','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)

August 18, 2011 at 9:05 pm

#1370507
RE: Removing redundant information

Are you saying that both the "add" and "delete" tables have exactly the same columns? If so, what in the tables relates "Adds" to "Deletes"?
--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 18, 2011 at 8:51 pm

#1370506
RE: Improving Delete Performance

I don't normally recommend it but have you considered changing the FK's to "Cascade on Delete"? It sounds like that would be the easiest and fastest way to do...
--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 18, 2011 at 8:44 pm

#1370503
RE: Back in the saddle

Hi Christi,
First, welcome back and congrats on beating your illness.
If you can afford it, I'd buy a copy of the "Developers Edition". I don't know what the latest...
--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 18, 2011 at 8:39 pm

#1370502
RE: Real value of TSQL Batches?

As a bit of a side question, why are you trying to do these things from the client instead of within SQL Server itself?
--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 18, 2011 at 8:19 pm

#1370501
RE: Stored Procedure with Totals

If you want a really a good tested answer, the graphic helps a bit but a lot of well meaning folks just won't touch it. Please see the farticle...
--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 18, 2011 at 8:15 pm

#1370500
RE: UDF Works with literal value but with Dynamic Values

I absolutely agree with Sean. Please see the following article and pay particular attention to the "Prologue" at the beginning of the article...
http://www.sqlservercentral.com/articles/T-SQL/68378/
--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 18, 2011 at 8:11 pm

#1370498
RE: Finding it impossible to Split a column based on a delimiter

I would just pork chop the provider of the spreadsheet and get them to do things right. 😉
--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 18, 2011 at 7:59 pm

#1370496
RE: The Mystery of Transaction Log Size Growth???

Just in case you don't know... even though you're doing constant backups on the T-Log file during maintenance, IIRC, the TLog file will still grow to about 1.5 times 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)

August 18, 2011 at 7:57 pm

#1370494
RE: Are the posted questions getting worse?

Almost forgot to ask... how many "fields" did you have per "record" and what was the average length of each record in bytes for the delimited string method 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)

August 18, 2011 at 7:34 pm

#1370492
RE: Are the posted questions getting worse?

SQLRNNR (8/18/2011)
Jeff Moden (8/18/2011)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I've never used them. I've always used something else because they didn't use to be available....
--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 18, 2011 at 7:32 pm

#1370491
RE: Are the posted questions getting worse?

Evil Kraig F (8/18/2011)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I see it as the first step needed for ORM and RDBMS to start liking each other...
--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 18, 2011 at 6:39 pm

#1370486

Viewing 15 posts - 32,821 through 32,835 (of 59,099 total)