Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,676 through 45,690 (of 59,101 total)

RE: Open Source Pay

mtucker (1/22/2009)
Exactly! Full disclosure of salaries allows people to make better decisions because they have more information.
How are my fellow employees going to make better decisions if they know what...
--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)

January 22, 2009 at 6:09 pm

#931566
RE: The Set-Based Limit

GSquared (1/22/2009)
Needed in batches of about 5-10,000 at a time, usually about 100k per week.
So, there's on situation where I consider procedural code valid.
Are you saying it took overnight 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)

January 22, 2009 at 5:54 pm

#931564
RE: Correct use of @variables and uniqueidentifiers

GSquared (1/22/2009)
Because violations of first normal form are so much fun! And the entertainment value from trying to work out delete and update code for string lists is enough...
--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)

January 22, 2009 at 12:24 pm

#931385
RE: Correct use of @variables and uniqueidentifiers

PG... although we're having a bit of fun at the expense of your dilema, it would be good to know why (the actual business reason) the table is denormalized 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)

January 22, 2009 at 12:22 pm

#931383
RE: The Set-Based Limit

peter (1/22/2009)
Jeff, any luck in finding the saved "function argument" you mentioned?
No, sorry... I can't even remember who the "argument" was with...
Touch a minimal set of data, a...
--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)

January 22, 2009 at 12:18 pm

#931379
RE: Is Vince Iacoboni still around?

Yep... that's the one. And, after reading that bad boy, I have to say that the feeling is mutual, Vince. 🙂
--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)

January 22, 2009 at 12:05 pm

#931371
RE: datediff mm between a timestamp in varchar(50) and a small datetime ???

Also, be real careful with ISDATE... the following will return a "1" as will many other things...
SELECT ISDATE('2008')
--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)

January 22, 2009 at 11:50 am

#931355
RE: datediff mm between a timestamp in varchar(50) and a small datetime ???

JPLeBlanc (1/22/2009)
Jeff,
I beleive that would be two months since it is calculating it in days correct?
so not just 1 calendar months difference. or am i backward? 🙂
Lynn is...
--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)

January 22, 2009 at 11:48 am

#931353
RE: Truncating Date

mathur.akhil (1/22/2009)
I have a similar problem. I have lots of tables where the time part is getting stored and need to quickly ensure only the date is stored without changing...
--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)

January 22, 2009 at 5:57 am

#931061
RE: 16 digit unique number

Paresh Prajapati (1/21/2009)
One table has one field and it should be 16 didgit as per client requirement...
Programmer has given me this task...
But, that's not the business reason and you should...
--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)

January 22, 2009 at 5:48 am

#931054
RE: Hidden RBAR: Triangular Joins

ALZDBA (1/22/2009)
Jeff Moden (1/21/2009)
... simple question... "Using a SELECT statement, how do you return the current system date and time as part of the return in either?" ....
Bad 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)

January 22, 2009 at 5:40 am

#931043
RE: VM... Setting up new "box"

Michael Earl (1/22/2009)
Jeff Moden (1/21/2009)
Ok... still not sure what you mean, so I'll come right out and ask... Do you think I'm part of the problem on this one?
No, sorry....
--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)

January 22, 2009 at 5:21 am

#931026
RE: Problem with NULL value

Kent Waldrop (1/21/2009)
Another alternative to the ISNULL function is the COALESCE function; both will work. In addition, COALESCE will also work with both DB2 and Oracle.
In SQL Server, COALESCE...
--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)

January 21, 2009 at 9:23 pm

#930872
RE: datediff mm between a timestamp in varchar(50) and a small datetime ???

JPLeBlanc,
Just making sure that you know what you're getting...How many months would you say the following should give?
StartDate EndDate
20080101 20080229
--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)

January 21, 2009 at 9:17 pm

#930870
RE: Correct use of @variables and uniqueidentifiers

BWAA-HAA!!! Ooooohhh mmmmyyy! Dammit! Stop it, Sergiy... I can't stand laughing this hard! :P:P:P
--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)

January 21, 2009 at 8:24 pm

#930864

Viewing 15 posts - 45,676 through 45,690 (of 59,101 total)