Jeff Moden

Forum Replies Created

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

RE: Managing Transaction Logs

Not sure how I missed this when it was first published... very well done!
--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:46 pm

#944033
RE: Geting dead lock error for two users running of the crystal report

"two users running...."
Running WHAT?
Lookup troubleshooting deadlocks in Books Online for a wealth of information on the subject... making shorter batches is just the start.
--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:37 pm

#944032
RE: generating non-numeric primary key

Jeff Moden (2/13/2009)
I agree with Lowell... otherwise, you'd have to resort to some nasty trickery like MAX or a sequence table and both will cause a world of hurt.
And since,...
--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:26 pm

#944029
RE: generating non-numeric primary key

I agree with Lowell... otherwise, you'd have to resort to some nasty trickery like MAX or a sequence table and both will cause a world of hurt.
--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:24 pm

#944028
RE: How to store results for a query to a table?

Chinesinho (2/13/2009)
So here's the problem I'm facing - I'm running an extended stored procedure from a third party vendor, and I want to be able to capture the text (by...
--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:21 pm

#944027
RE: Running a stored procedure for situation updating.

This will do it...
http://www.sqlservercentral.com/articles/Video/65070/
--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:14 pm

#944026
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

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