Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,651 through 37,665 (of 59,098 total)

RE: Are the posted questions getting worse?

Paul White NZ (7/16/2010)
Jeff Moden (7/16/2010)
...using IDENTITY in combination with some table and index hints, have been able to resolve the ones I haven't be able to avoid (guaranteed multi-row...
--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)

July 16, 2010 at 2:36 pm

#1194360
RE: Help with using mulitple replace in a function

I'll try to remember it on Monday, then, Julie. Thanks for your patience.
--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)

July 16, 2010 at 1:42 pm

#1194336
RE: SQL DBA to BI Developer Role

Outstanding. Thanks for your time, Steve! It'll help everyone that happens to read this thread.
--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)

July 16, 2010 at 1:28 pm

#1194332
RE: Performance on Views that span databases on multiple servers

CirquedeSQLeil (7/15/2010)
My 2 bits on Vendor support of their databases.
That's a load of crap. Vendors should support their database despite other databases being present. I know they pull...
--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)

July 16, 2010 at 1:26 pm

#1194331
RE: Multi-parent heirarchy query

Joe Celko (7/16/2010)
The nodes (parts) are in one table and the tree structure (blueprint) is in another. The (lft, rgt) pairs are the primary in a BOM tree so...
--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)

July 16, 2010 at 1:21 pm

#1194323
RE: Help with using mulitple replace in a function

Julie Breutzmann (7/16/2010)
I've modified Lowell's function and performed a time-comparison test. Ihaven't thoroughly tested the function, since if it's too slow it won't be useful anyway. I used and input...
--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)

July 16, 2010 at 1:13 pm

#1194320
RE: Calendar Tables

Now [font="Arial Black"]there's [/font]an idea for an article... comparing the pros and cons of using a DateTime dates compared to INT dates.
--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)

July 16, 2010 at 12:56 pm

#1194308
RE: Becoming a business intelligence architect

da-zero (7/14/2010)
Jeff Moden (7/13/2010)
Have you got a link for all of the requirements, Steve? Thanks.
:blink:
I think I have an URL where you can download experience. If I can find...
--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)

July 16, 2010 at 12:43 pm

#1194295
RE: Are the posted questions getting worse?

Gianluca Sartori (7/16/2010)
Paul White NZ (7/15/2010)
Jeff Moden (7/15/2010)
Can you good folks give me an example of when IDENTITY will not work?
When you need a sequence across several tables
When you need...
--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)

July 16, 2010 at 12:35 pm

#1194291
RE: Multi-parent heirarchy query

CirquedeSQLeil (7/15/2010)
Joe Celko (7/15/2010)
Talking about multiple parents in a Hierarchy makes no seine by definition.
Full on agree with that.
Maybe for a hierarchy but have you ever seen a BOM?...
--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)

July 15, 2010 at 5:23 pm

#1193833
RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

gary.strange-1058508 (7/15/2010)
This is a forum, inviting users to express their opinion.
I would consider using cut & paste to repeat your comment along the thread contributes nothing of substance.
Perhaps 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)

July 15, 2010 at 2:11 pm

#1193770
RE: Help with using mulitple replace in a function

Julie Breutzmann (7/15/2010)
I work in higher ed and our budget has been cut significantly. To make matters worse a significant portion of our budget is non-discretionary. 🙁
Damn... I'll never understand...
--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)

July 15, 2010 at 2:05 pm

#1193767
RE: Help with Query

Eralper (7/15/2010)
Hello dheer,
Please thy the following select query
select
name,
MAX(dob), MAX(maths), MAX(science), MAX(chemisty), MAX(physics),
MAX(maths) + MAX(science) + MAX(chemisty) + MAX(physics)
from lessons
group by name
I hope that helps you
The problem with 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)

July 15, 2010 at 1:59 pm

#1193761
RE: Getting Data back from a Stored Proc

Paul White NZ (7/15/2010)
Gianluca Sartori (7/15/2010)
...but consider that this solution can lead to very extensive row locks if run inside transactions...
Yes that's one of the things to watch out 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)

July 15, 2010 at 1:56 pm

#1193759
RE: Function in Joining column degrades performance in 2008

TheSQLGuru (7/15/2010)
I might have missed it, but did anyone mention that when upgrading from SQL 2000 to SQL 2008 you MUST update ALL statistics with a FULL SCAN?
Also did 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)

July 15, 2010 at 1:51 pm

#1193756

Viewing 15 posts - 37,651 through 37,665 (of 59,098 total)