Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,221 through 44,235 (of 59,097 total)

RE: Performance issue with tally solution

Sratch the above... I found the index. Still looking.
--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)

April 12, 2009 at 11:32 pm

#976394
RE: Performance issue with tally solution

Florian Reischl (4/12/2009)
Hello everybody!
I have a performance issue with a set based solution. Please could you advice me what I'm doing wrong?
ORDER BY on unindexed Tally table, for starters. ...
--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)

April 12, 2009 at 11:21 pm

#976392
RE: T-SQL 2005 Help

Paul White (4/12/2009)
Jeff Moden (4/12/2009)
...That brings me to another subject... I hate deprecation. Who is it to say that certain features are no longer useful? The masses? ...
--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)

April 12, 2009 at 10:39 pm

#976386
RE: T-SQL 2005 Help

Understood... I used to say "Never" use a cursor. Don't get me wrong, I always try to avoid it and have been very successful at doing so. But,...
--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)

April 12, 2009 at 9:43 pm

#976379
RE: T-SQL 2005 Help

It's so odd to hear everyone talking about getting "better" and not programming like they were in the '60's or '70's anymore. I wonder what people would say if...
--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)

April 12, 2009 at 9:10 pm

#976373
RE: T-SQL 2005 Help

Sorry... had a change of thought... posted those thoughts further below.
--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)

April 12, 2009 at 8:55 pm

#976370
RE: TSQL help needed

Bob Hovious (4/12/2009)
Jeff you shoulda been a lawyer :-D. Wasn't it you asking why people needed to do this on another thread? I'm in total agreement 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)

April 12, 2009 at 8:46 pm

#976367
RE: Just Walk Away - Blacklisting - and Twits without Twitter

GilaMonster (4/8/2009)
Steve Jones - Editor (4/7/2009)
GilaMonster (4/7/2009)
Similar thing here. In my country, woman and IT don't usually go in the same sentence. The number of times I've been 'mistaken' 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)

April 12, 2009 at 7:53 pm

#976364
RE: Are the posted questions getting worse?

GilaMonster (4/12/2009)
Alvin Ramard (4/12/2009)
Being a contractor, that would be without pay too
Same here. It comes out of my 'education and training' savings.
If you're paying your own way, ignore the conference...
--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)

April 12, 2009 at 7:45 pm

#976363
RE: Which is more efficient or does it matter?

Paul White (4/12/2009)
Jeff,
You are so right to point out the data-consistency advantage of the computed column. I guess I could add a constraint or something to simulate that benefit,...
--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)

April 12, 2009 at 7:43 pm

#976362
RE: How to make this stored procedure flexible?

sku370870 (4/12/2009)
I now have this ...
SELECT #tblHolidays.HolidayDescription As [Description], #tblHolidays.HolidayDate AS [Holiday Date],
count(case #tblDepartmentHolidays.DepartmentID when 0 then 1 else null end) as [Global],
count(case #tblDepartmentHolidays.DepartmentID when 1 then 1 else...
--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)

April 12, 2009 at 7:38 pm

#976361
RE: How to make this stored procedure flexible?

Heh... ok, Paul. From the way you were talking, I thought you were on to an improvement.
--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)

April 12, 2009 at 7:35 pm

#976360
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Thanks for your concern. If I'm not mistaken, PIVOT can do multiple aggregations... I just gotta look back in my notes because I don't use PIVOT for all 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)

April 12, 2009 at 7:25 pm

#976359
RE: T-SQL 2005 Help

All of that may be true... I just hope they never remove the capability because it is an option. It's kind of like cursors... I generally deplore their usage...
--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)

April 12, 2009 at 7:52 am

#976281
RE: How to make this stored procedure flexible?

Paul White (4/12/2009)
Jeff Moden (4/11/2009)
You may want to reconsider ever using a Pivot operator... a properly formed crosstab can be nearly twice as fast...
http://www.sqlservercentral.com/articles/T-SQL/63681/
Performance meaurements are at the bottom 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)

April 12, 2009 at 7:39 am

#976279

Viewing 15 posts - 44,221 through 44,235 (of 59,097 total)