Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,211 through 45,225 (of 59,095 total)

RE: How do you feel about your hard earned tax payer money going to pay for bankers bonuses?

Heh... I have a hard time with a bank executive of a bank in trouble getting 500G to begin with. I'm with Rudy... "Pork chops awaaaaaaayyyyy!"
--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 13, 2009 at 9:11 pm

#944025
RE: Bulk Insert question

Note possible using Bulk Insert alone. Is possible if you use a calculated column on the target table and, maybe, a bcp format file... but a simple post-import update...
--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 13, 2009 at 9:01 pm

#944022
RE: Import CSV without BULKADMIN permissions

Clarie Smith (2/13/2009)
However, I do NOT want to give the AppID the BULKADMIN server role for bulk import.
Why not? The only thing folks can do is execute a Bulk...
--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 13, 2009 at 8:58 pm

#944021
RE: with out using the cursor/while

arun.sas (2/13/2009)
Thanks Lynn Pettis
but if i create the #temp with SLNO identity,then the clustered index realy needed?
ARUN SAS
Absolutely. And, since you can't use an index by name in 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 13, 2009 at 8:49 pm

#944020
RE: Function - Check Count

There's no need for any local variables nor the flow control of IF in this function...
CREATE FUNCTION uf_future_classes --uf_future_classes 15
(
...
--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 13, 2009 at 8:09 pm

#944015
RE: 1-M join, concat all records

Thanks Tony. Just one more question... is your goal to create a text file for Lucene or are you just going to pass it through the API?
--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 13, 2009 at 7:55 pm

#944014
RE: Need input on changing the size of a decimal field

Just a note... if I need a decimal of a certain precision and scale, I always lookup the number of storage bytes for that precision and go for the highest...
--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 13, 2009 at 7:45 pm

#944012
RE: Conservative or Risky?

The term "don't want to rock the boat" is frequently practiced at all levels of management in a large number corporations that I've been exposed to. They should practice...
--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 13, 2009 at 7:40 pm

#944011
RE: How to convert INTEGER to TIME

pshvets (2/13/2009)
Hello,
I have a column which is integer data type and it represents number of seconds.
I need to convert it into MINUTES:SECONDS format.
Conversion of int into time is prohibited in...
--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 13, 2009 at 6:48 pm

#944006
RE: 1-M join, concat all records

Tony (2/13/2009)
Very nice! It's working and performs well.
I'll have to try this in similar places using functions and CTEs, and see what performs better.
I can end my week on...
--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 13, 2009 at 6:39 pm

#944004
RE: Moving TempDB

Just an FYI for everyone in case there's a doubt... I've recently (10 minutes ago) had reason to move TempDB on one of my 2k5 dev boxes... it worked perfectly...
--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 13, 2009 at 4:12 pm

#943990
RE: Passing a Table to a Stored Procedure

sushila (2/13/2009)
Jeff Moden (9/20/2007)
Thanks John and Rog... much appreciated!
You may be using the wrong layer to do database things in. The type of activety that you've both described should probably...
--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 13, 2009 at 11:44 am

#943858
RE: how to split following string

DURGESH (2/13/2009)
hi all,
i have a string as 'a;b;cde;f;ghi;d' or 'a;b;cde;f;ghi;defg'
now i want to split the given string as 'a;b;cde;f;ghi;' or 'a;b;cde;f;ghi;'
i tried using substring,left,charindex functions but i did 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)

February 13, 2009 at 6:22 am

#943499
RE: Convert Interger Time to 00:00:00

I think you'll find that Michael's solution is absolutely the fastest because it uses only 1 implicit conversion and it's not character based.
--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 12, 2009 at 9:02 pm

#943342
RE: Query Tune

Daryl (2/12/2009)
- meaning full alibi's... I always use alibis but A & B crapcodea
The term is "alias"... 😉
- do not Select INTO ____ , define the table and...
--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 12, 2009 at 8:53 pm

#943340

Viewing 15 posts - 45,211 through 45,225 (of 59,095 total)