Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,316 through 45,330 (of 59,095 total)

RE: list of month names and week ranges between dates

Bruce W Cassidy (2/2/2009)
[font="Verdana"]Heh, that's kinda ironic. Jeff Moden asking for a URL to one of his own posts.[/font]
It had to happen, someday. It's funny as hell that's...
--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 2, 2009 at 7:56 pm

#936882
RE: how to reterive a single record from a table

GSquared (1/29/2009)
Do you know how to write a Select statement?
Heh... bad day, Gus? 😉
--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 2, 2009 at 7:53 pm

#936881
RE: how to reterive a single record from a table

The real answer to this question should have been "Since data is not guaranteed to be in any order in a table or query result, and ORDER BY would be...
--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 2, 2009 at 7:51 pm

#936880
RE: how to reterive a single record from a table

Max (1/29/2009)
Lowell (1/29/2009)
... insulting people who are trying to help will not get you anything...
here here
... but you still answered the question, didn't you? 😉 If it were...
--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 2, 2009 at 7:31 pm

#936876
RE: Permissions for Developers

I 110% agree with that! And, there may be restrictions on some other tables, as well. For example, tell me why a developer would need to know anyone...
--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 2, 2009 at 7:25 pm

#936875
RE: Strange network error

kevriley (2/2/2009)
Todd,
it is happening everytime with one id and not with another - but I've checked anti-virus and that isn't kicking in.
Kev
I can't remember exactly what the phrase 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 2, 2009 at 7:23 pm

#936874
RE: Count() with expressions, vs. numerics

GSquared (2/2/2009)
Look up Jeff Moden's article on Running Totals (on this site). Should be able to use that for what you need.
The article is temporarily "offline" until I 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)

February 2, 2009 at 7:19 pm

#936872
RE: non sysadmin needs to modify a couple of sql agent jobs

fizzleme (2/2/2009)
We have a contractor who needs to modify a couple of SQl agent jobs on our server. He is using standard SQl security to connect.
The SQL agent jobs...
--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 2, 2009 at 7:05 pm

#936864
RE: Logs for table updates

SQL Server 2000 has none of those features.
--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 2, 2009 at 7:01 pm

#936862
RE: SQL Server 2005 upgrade changes column order of tables.

rich.ramos (2/2/2009)
The PeopleTools upgrade would not affect the field order of custom records. And the column order does not affect the way the PeopleSoft application interacts with the table....
--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 2, 2009 at 6:59 pm

#936861
RE: What Duties Would a Junior DBA Have?

John Bates (2/2/2009)
hi DBAs,
I'm a Oracle and SQL Server 2005 DBA for my employer. I have been asked to list some of the skills that a *Junior* DBA position would...
--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 2, 2009 at 6:54 pm

#936856
RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

GSquared (2/2/2009)
Go for it. Might take more than a quarter, so don't be disappointed if you aren't up to Jeff Moden's or Gail's skill level by that time.
:blush: ...
--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 2, 2009 at 6:38 pm

#936851
RE: SQL or Oracle

Jeff Moden (2/2/2009)
noeld (2/2/2009)
Bruce W Cassidy (2/2/2009)
[font="Verdana"]Relational Integrity is over-rated.
OMG, did I really just say that? And I was just reading an article by Joe Celko too! Aaaargh!...
--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 2, 2009 at 5:51 pm

#936834
RE: SQL or Oracle

noeld (2/2/2009)
Bruce W Cassidy (2/2/2009)
[font="Verdana"]Relational Integrity is over-rated.
OMG, did I really just say that? And I was just reading an article by Joe Celko too! Aaaargh! 😛
[/font]
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)

February 2, 2009 at 5:49 pm

#936832
RE: list of month names and week ranges between dates

ghughes (2/2/2009)
ok, I give up. I defer to everyone greater judgement in the matter. Make perfect sense. I have created table......thank you for the help.
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 2, 2009 at 5:35 pm

#936824

Viewing 15 posts - 45,316 through 45,330 (of 59,095 total)