Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,471 through 52,485 (of 59,098 total)

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

Christopher Ford (2/18/2008)
For totals that involve groups, I wonder if you can split the work in half.
A multi-thread CLR?
Where the first query get the first half while the second query...
--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)

February 19, 2008 at 9:26 am

#779783
RE: Questions to ask of a new application vendor

Matt Miller (2/18/2008)
Jeff Moden (2/18/2008)
Heh... do be a bit careful... my questions, although certainly appropriate, are likely to be taken as a high insult. 😉 I know this because...
--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)

February 19, 2008 at 8:59 am

#779771
RE: setiing variables in a temp table

Ummm... all of that's fine, but it's all RBAR (see my tagline for the explanation).
I assume that you're just a bit new to this. What would be...
--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)

February 18, 2008 at 6:25 pm

#779520
RE: Identity Column in SQL Server - Transaction - MultiUSer

First, I love your "handle"... "Ivana Noh"... that's outstanding. Someday, ya gotta tell me at least your first name.
Your observation is spot on... It would be MUCH better to...
--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)

February 18, 2008 at 6:16 pm

#779519
RE: The ARRAY In SQL Server 2000

It seems to me that the real big difference between a mere table and an array, are the array indicies themselves... You know, the stuff where you 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)

February 18, 2008 at 6:03 pm

#779514
RE: plz help me urgent regd Warning 0x8020200f: Data Flow Task: There is a partial row at the end of the file.

If there's no confidential info in the file, recommend you attach the file to a post and lets take a peak. Can't really tell, otherwise.
--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)

February 18, 2008 at 5:56 pm

#779513
RE: Questions to ask of a new application vendor

Heh... do be a bit careful... my questions, although certainly appropriate, are likely to be taken as a high insult. 😉 I know this because new vendors I try...
--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)

February 18, 2008 at 5:54 pm

#779512
RE: differiniate quotes as data vs quotes as column identifier

I'll have to defer to someone else because I always end up using the BCP format file 😀
Hey folks, can anyone else help here? I don't use DTS 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)

February 18, 2008 at 5:45 pm

#779508
RE: Set-based approach for getting a date range from mult rows

Heh... the method certainly is useful for a lot of things that would otherwise require a cursor... and a heck of a lot faster, too!
Matt, that's perfect... the only thing...
--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)

February 18, 2008 at 5:15 pm

#779504
RE: differiniate quotes as data vs quotes as column identifier

A proper format file using BCP will do... dunno if you can do that in DTS without writing some sort of script...
--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)

February 18, 2008 at 4:25 pm

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

Wow... Outstanding job, Matt! Thanks for that!
I'm pretty tickled that one or the other of us can beat the CLR methods pretty much hands down on eveything except RegEx,...
--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)

February 18, 2008 at 1:03 pm

#779440
RE: UDF Taking More Time than the base query

The fact that the UDF is taking longer than the embedded code is normal... there's a bit of an overhead associated with running UDF's in many cases especially when 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)

February 18, 2008 at 12:51 pm

#779437
RE: UDF Issue

Cross post...
http://www.sqlservercentral.com/Forums/Topic457027-8-1.aspx?Update=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)

February 18, 2008 at 12:49 pm

#779435
RE: UDF Taking More Time than the base query

Why? That's as bad a double post. You're just gonna make people mad...
--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)

February 18, 2008 at 12:48 pm

#779434
RE: Questions to ask of a new application vendor

Good list, like everyone else said. Just no hair in the list...
I'd first ask them if they've actually tested their code on a 64 bit machine. I'd want...
--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)

February 18, 2008 at 12:45 pm

#779433

Viewing 15 posts - 52,471 through 52,485 (of 59,098 total)