Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,191 through 38,205 (of 59,072 total)

RE: Query-generated Column Expressions

Douglas Osborne-456728 (5/25/2010)
Nick,
This seemed to work a little better for me:
How so? Please describe.
--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)

May 25, 2010 at 7:42 pm

#1172426
RE: Dataimport from csv-file

varkstad (5/24/2010)
Hi again,
Now I have solved even this last problem. Thank you for all help today.
Gunilla
Two way street here, Gunilla. 😉 How did you fix that last problem?
--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)

May 25, 2010 at 6:25 pm

#1172420
RE: Warning or no warning?

With what Jeffrey posted from BOL, I'd be content to not have any additional warnings mostly because I'm a defensive programmer to begin with.
--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)

May 25, 2010 at 6:04 pm

#1172419
RE: Parsing millions of records without index

Allow me to give you an example of why it's important for us to have all the information we ask for. We're not asking you this stuff to run...
--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)

May 25, 2010 at 5:50 pm

#1172418
RE: Parsing millions of records without index

rajiv.varma (5/25/2010)
@jeff
I agree I stripped down the code for posting purpose, but the actual code definitely works. The whole reason behind combining data from 4 columns is that if there...
--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)

May 25, 2010 at 5:32 pm

#1172416
RE: Getting most common value from several fields into one record

kramaswamy (5/25/2010)
This scenario is not actually important to me - I'm fine with choosing any one of them.
Heh... now that would have been nice to know up front. 😛 ...
--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)

May 25, 2010 at 5:26 pm

#1172414
RE: Warning or no warning?

lmu92 (5/25/2010)
But...
wouldn't it be nice to have a SQL Server setting (like IDENTITY_INSERT), something like STRING_TRUNC with ON as a default (truncate strings, like it currently does...)? That would allow...
--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)

May 25, 2010 at 5:08 pm

#1172410
RE: Substring function generates error when I try to use (LEN(expression)-1) as length argument

Cheat... no CASE required.
SELECT ISNULL(SUBSTRING(@exp1,1,(LEN(NULLIF(@exp1,'')) - 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)

May 25, 2010 at 4:07 pm

#1172394
RE: Warning or no warning?

I'd prefer that it operate like it does... no warning. I'll sometimes (many times, actually) use it as a cheater (LEFT).
--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)

May 25, 2010 at 4:00 pm

#1172390
RE: Passing many parameters to a stored procedure

Heh... yep... depends on whether you want to be nice to the "pipe" or not.
--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)

May 25, 2010 at 3:55 pm

#1172388
RE: Convert this date to calendar format...?

tacy.highland (5/25/2010)
Thank you everyone for the quick and knowledgeable responses! This works wonderfully now.
Thank you so much!
Tray... I have a concern about your floating year code with the date format...
--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)

May 25, 2010 at 3:54 pm

#1172387
RE: http call embedded in stored proc

Oddly enough, I was looking for a similar thing today. I found the following. Not sure it applies here but might be helpful in what to look for...
Declare...
--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)

May 25, 2010 at 3:46 pm

#1172383
RE: High Transactions per second

Grant Fritchey (5/25/2010)
Jeff Moden (5/25/2010)
Grant Fritchey (5/25/2010)
Why on earth would you want to reduce the number of transactions per second? This is indicative of a high load on the system....
--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)

May 25, 2010 at 11:09 am

#1172249
RE: High Transactions per second

Grant Fritchey (5/25/2010)
Why on earth would you want to reduce the number of transactions per second? This is indicative of a high load on the system. You should be working...
--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)

May 25, 2010 at 8:33 am

#1172100
RE: Cursor performance

Just to add to what has already been said...
There are a lot of places where well meaning folks use Cursors/While Loops because a job "can't be done using set...
--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)

May 25, 2010 at 8:29 am

#1172099

Viewing 15 posts - 38,191 through 38,205 (of 59,072 total)