Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,231 through 46,245 (of 59,095 total)

RE: Multi-column primary keys

paulhunter (12/31/2008)
Welcome to the other side of the looking glass.
Heh... more like a one way mirror... could be interpreted as "check valve". 😛
--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 1, 2009 at 12:20 pm

#919996
RE: How Would You Rate This? - Database Weekly (Dec 29, 2008)

Steve Jones - Editor (12/31/2008)
I do think they ought to adhere to a schedule, but not at the expense of bad code.
[font="Arial Black"]FINALLY![/font] That's exactly what I've been saying...
--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 1, 2009 at 12:18 pm

#919995
RE: Cursors Be Gone!

npfitzner (1/1/2009)
Tom.Thomson (1/1/2009)
He wants to remove the From clause from the Update statement? Seriously?
No - I think that's what the 😉 was for.
🙂
Yes! He actually...
--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 1, 2009 at 12:15 pm

#919994
RE: Cursors Be Gone!

Tom.Thomson (1/1/2009)
Jeff Moden (12/31/2008)
Ok... now I'm getting really afraid for you guys... :hehe: you're talking about this like you use cursors and you're listening to the guy who wants 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 1, 2009 at 12:14 pm

#919993
RE: Looking Forward

Heh... yeah... 2.x...
--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 1, 2009 at 12:11 pm

#919990
RE: sp_OAMethod: Refresh pivot sheet without open

Bob Hovious (12/31/2008)
Who was it that defined legacy code as the stuff that has been around so long that you finally got most of the bugs out of it?
I don't...
--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 1, 2009 at 12:06 pm

#919985
RE: Changing Taxonomy

I think everyone would abuse a "Challenges" forum... might as well label it the "Urgent" forum. 😀
--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 1, 2009 at 12:00 pm

#919983
RE: varchar actual size

RBarryYoung (12/31/2008)
Actually, Jeff, you should be using SQL_VARIANTS for the V part. That's what they're there for.:D
Uh huh... and someday they'll make all our dreams come true by making...
--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 1, 2009 at 11:55 am

#919978
RE: Cursors for T-SQL Beginners

Make no doubt about it... Cursors are an advanced subject and no new user of T-SQL should be allowed anywhere near a cursor or any other form of RBAR until...
--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 1, 2009 at 11:46 am

#919975
RE: add business days to a date

Fellow who goes by the handle "Fraggle" posted a function at the following URL... it seems to work quite reliably for the days ahead that I tested it for...
http://www.sqlservercentral.com/Forums/Topic153606-203-3.aspx#BM591629
--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)

December 31, 2008 at 7:55 pm

#919893
RE: add business days to a date

andrewd.smith (12/23/2008)
Here's a method of calculating the Nth working day in the future without using a CTE or tally table.
DECLARE @days int
SELECT @days = 10
DECLARE @inputDate datetime
SELECT @inputDate = '2008-12-23'
DECLARE...
--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)

December 31, 2008 at 7:13 pm

#919891
RE: Calculating Work Days

Fraggle (10/24/2008)
Jeff,
Alright, now that I have had a little time to ponder the imponderable as my dad would say, I figured out how to add X number of business days...
--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)

December 31, 2008 at 7:03 pm

#919888
RE: Common Mistakes in T-SQL

paulhunter (12/31/2008)
Jeff Moden
Nope... haven't written one on dates, yet. Wrote one on how to do dynamic crosstabs using dates, but not one just on dates.
Robyn Page wrote 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)

December 31, 2008 at 6:07 pm

#919883
RE: Common Mistakes in T-SQL

RBarryYoung (12/31/2008)
Huh. and here I always use 121.
But not for trying to find a whole date...
--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)

December 31, 2008 at 5:59 pm

#919881
RE: Common Mistakes in T-SQL

Michael Valentine Jones (12/31/2008)
How about stupid date queries like this:
where Convert(varchar, CreationDate, 101) between Convert(datetime,@FromDate, 101) And Convert(datetime, @ToDate, 101)
which can amount to something like this:
where '12/30/2008' between '12/25/2008' 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)

December 31, 2008 at 4:13 pm

#919868

Viewing 15 posts - 46,231 through 46,245 (of 59,095 total)