Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,866 through 50,880 (of 59,091 total)

RE: Blackle

Thanks, Steve... I'll take a look. One test is worth a thousand guesses...
I still like the ultimate power saver... turn it off when you're not using it. 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)

April 30, 2008 at 9:18 am

#809140
RE: Create a Tally or Numbers Table

Thanks guys... I sure do appreciate your feedback.
I just got word that it's coming out on May the 7th.
--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)

April 30, 2008 at 9:15 am

#809135
RE: IT salary is going down !

I agree, nothing beats experience...
--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)

April 30, 2008 at 9:14 am

#809132
RE: Row-By-Row Processing Without Cursor

See the following URL... almost identical situation...
http://www.sqlservercentral.com/Forums/Topic491969-149-1.aspx#bm492576
--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)

April 30, 2008 at 9:10 am

#809123
RE: difference

Mahesh Bote (4/30/2008)
[font="Verdana"]
... and, just to be sure, you can do INSERTs, UPDATEs, and DELETEs on Table Variables in a UDF... just not on external tables.
Jeff, I was talking about...
--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)

April 30, 2008 at 9:08 am

#809120
RE: Combine multiple rows

Yeah... I agree... if it's a return to the GUI, the comma separated list would probably be the way to go for the very reasons you stated. Thanks...
--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)

April 30, 2008 at 9:07 am

#809119
RE: Blackle

Steve Jones - Editor (4/30/2008)
On CRTs, to product light takes energy, black is less power.
On LCDs, all colors require energy, so Blackle doesn't really help, especially over time. It was...
--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)

April 30, 2008 at 9:04 am

#809117
RE: Blackle

Adrian Nichols (4/30/2008)
Jeff,
Here's a link to Googles Earth Hour effort....
http://www.google.co.uk/intl/en_uk/earthhour/
And this one's for the official blog saying that it may actually use more energy!
http://googleblog.blogspot.com/2007/08/is-black-new-green.html
Thanks, Adrian!
--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)

April 30, 2008 at 9:00 am

#809114
RE: Ordereing an IP address

Casting to an INT should actually run a bit faster over a large number of rows.
--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)

April 30, 2008 at 8:55 am

#809108
RE: Performance Problem

While you're at it... check to see what other traces you have running. Too many or the wrong kind of trace will also slow the world to a crawl.
--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)

April 30, 2008 at 8:54 am

#809106
RE: Find Last Day of Month

The code I posted work without error on my end. If you are typing, are you sure that your typing a zero and not an "OH"?
You know the rules......
--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)

April 30, 2008 at 8:53 am

#809105
RE: Combine multiple rows

Bruna (4/30/2008)
I dont know, Its dynamic...
Could be 3-4-5-6... 🙁
Putts (4/30/2008)
Dynamic is gonna cause the problem there......maybe someone else knows a way of doing a SELECT statement with a dynamic number...
--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)

April 30, 2008 at 8:38 am

#809080
RE: User Defined Function - Passing and Processing a Table

Matt Miller (4/30/2008)
I was being funny last night - just remember the "math" version and the "stats" version actually give you different results (based on their different definitions)....
Not a problem......
--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)

April 30, 2008 at 8:05 am

#809048
RE: cursor through user databases the SEQUEL

Do you have a database with a name like %customer%???
--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)

April 30, 2008 at 8:01 am

#809046
RE: Ordereing an IP address

hb21l6 (4/30/2008)
Appologies guys,
I only needed a SQL line to run from an ASP page, I didn't want to do this through an SP as there is more going on...
--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)

April 30, 2008 at 7:49 am

#809037

Viewing 15 posts - 50,866 through 50,880 (of 59,091 total)