Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,176 through 38,190 (of 59,098 total)

RE: Auto Increment Alphabet

This isn't right. First, using base 26 numbering isn't ever the right thing to do IMHO but if you're going to do it, let's do it so it's 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 28, 2010 at 10:05 pm

#1174209
RE: Auto Increment Alphabet

ColdCoffee (5/28/2010)
@Wayne Shef, mate, am not as experienced or as agile or as smart as u are in coding; please dont mistake me for editing your code, just that i...
--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 28, 2010 at 3:29 pm

#1174162
RE: String Help - LTRIM ?

Atif Sheikh (5/28/2010)
How about writing a function as;
[/code]
Although it's tempting to use such a thing, be very aware that the use of such scalar functions will slow your code down......
--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 28, 2010 at 1:45 pm

#1174112
RE: Simple scalar function slows down query

Nice job, Lowell.
--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 28, 2010 at 1:44 pm

#1174110
RE: Import and Export

If you have a SAN, see if it has the ability to do a "SAN Clone" or "SAN Snapshot". We did that at one company I worked at. ...
--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 28, 2010 at 1:33 pm

#1174107
RE: Delete Vs Truncate

Perry Whittle (5/28/2010)
Jeff Moden (5/27/2010)
Just don't throw the book at me. 😛
No give him a taste of his own medicine and throw a few pork chops instead 😀 :laugh:
Especially if...
--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 28, 2010 at 12:35 pm

#1174096
RE: Delete Vs Truncate

Sahasam (5/28/2010)
Jeff,
I went through many of the questions you answered, i really like your explanations.
Thanks for simplifying the words in layman terms.
Sahasam..
Thanks, Sahasam.
--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 28, 2010 at 12:34 pm

#1174095
RE: Delete Vs Truncate

nitu.guptaji (5/28/2010)
mean at the time of deletion log file is maintened we can recover data but in the case of truncation we can not recover because it doesn't maintain log...
--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 28, 2010 at 12:34 pm

#1174094
RE: Would You Do Your Hobby for a Living

It's a funny thing. I do SQL for a hobby, love it, and do it for a job. I also have several other hobbies but, for some reason,...
--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 27, 2010 at 11:29 pm

#1173726
RE: Delete Vs Truncate

Ratheesh.K.Nair (5/27/2010)
Thanks Jeff.That was really nice example and i liked the way u explained simple but really powerful so that noone will forget
Thanks for the nice compliment, Ratheesh. Heh......
--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 27, 2010 at 11:09 pm

#1173723
RE: Jst a query......

Maddy...! (5/27/2010)
Mr. Moden
I gave that statement bcoz Dave gave me some blog link to verify so i asked him and told him if 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)

May 27, 2010 at 11:06 pm

#1173721
RE: Sending HTML Newsletters in a Batch Using SQL Server

Good article but I guess I'm missing something. Instead of sending things in batches of "x" quantity every 10 minutes, wouldn't it just be easier to send 1 email...
--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 27, 2010 at 10:41 pm

#1173716
RE: JOIN with the resultset from a stored procedure?

How are you passing the parameters from the job to the proc? I believe that the information about service_sql is ancillary in nature and that the real problem has...
--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 27, 2010 at 10:15 pm

#1173708
RE: Delete Vs Truncate

Heh... thanks for the feedback. Just don't throw the book at me. 😛
--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 27, 2010 at 9:58 pm

#1173703
RE: Are the posted questions getting worse?

Paul White NZ (5/27/2010)
Jeff Moden (5/27/2010)
jcrawf02 (5/27/2010)
Paul White NZ (5/27/2010)
Note to self: avoid PeopleSoft.
You have four too many letters on the end there.
Heh... ironicly, I'm glad to see I'm 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 27, 2010 at 9:51 pm

#1173701

Viewing 15 posts - 38,176 through 38,190 (of 59,098 total)