Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,821 through 35,835 (of 59,099 total)

RE: Default trace - A Beginner's Guide

Thanks for the tip, Jack.
--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 2, 2010 at 10:11 pm

#1258201
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Nicole Bowman (12/2/2010)
Thanks Jeff! That is really helpful!
Cheers,
Thanks for the feedback and for stopping by, Nicole. 🙂
--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 2, 2010 at 10:08 pm

#1258200
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

James Stephens (12/2/2010)
crashdan (12/1/2010)
please also consider 0E0 and numbers like them.
Wasn't that covered in the Old_MacDonald() Function? Or was that the Flying_Monkeys() I'm thinking of?
Sorry...couldn't help it. 🙂
Heh... too...
--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 2, 2010 at 10:07 pm

#1258199
RE: Default trace - A Beginner's Guide

peter-970097 (9/21/2010)
Helpful article Adam - thank you.
How can I use this to trace Queries and Sp activity?
Peter
Melbourne, Australia
I don't believe you can. The default trace wasn't setup to detect...
--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 2, 2010 at 1:00 pm

#1258081
RE: Default trace - A Beginner's Guide

I recently had cause to revisit this fine article... well done, Adam. Great for neophytes and alumni alike.
As a side bar, here's the code I ended up using which...
--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 2, 2010 at 12:52 pm

#1258073
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Steve Jones - SSC Editor (12/1/2010)
Excellent article. Thanks for this bit of SQL Spackle.
Thanks Steve but the real thanks goes to you. You had a wonderful idea when you...
--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 2, 2010 at 7:41 am

#1257892
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

steven.malone (12/1/2010)
First off thanks, like others I had not stopped to think about "d" and "e" and I am a little surprised "x" was not included if they were. go...
--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 2, 2010 at 7:31 am

#1257882
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

crashdan (12/1/2010)
please also consider 0E0 and numbers like them.
Good point but that's actually and explicity covered in the article. 🙂
--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 2, 2010 at 7:22 am

#1257872
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Holy moly... 61 posts. I've read them all and I'll try to summarize...
First, thank all of you again for the high quality level of discussion. This one 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)

December 2, 2010 at 7:14 am

#1257863
RE: Are the posted questions getting worse?

David Burrows (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
Anyone know if there will be a recording available, 2.30AM is 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 1, 2010 at 7:37 pm

#1257704
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/30/2010)
Jeff Moden (11/30/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
Very cool... looking forward to that.
Put it on the calendar 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 1, 2010 at 7:35 pm

#1257703
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Wow! Great discussions going on here, folks! I'm at work right now so can't respond in detail. I'll have to wait until tonight. In the meantime,...
--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 1, 2010 at 10:47 am

#1257506
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

CirquedeSQLeil (11/30/2010)
Good stuff Jeff. Got that spackle article out pretty quick.
Thanks, Jason. Heh... When Steve first came out with the "Requested Articles" forum, I banged out 2 "spackles"...
--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)

November 30, 2010 at 10:32 pm

#1257147
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

autoexcrement (11/30/2010)
sharath.chalamgari (11/30/2010)
Simple and nice article,
some time back i was working on validating a column in the database and i came across this issue and we had this function...
--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)

November 30, 2010 at 10:28 pm

#1257145
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

sharath.chalamgari (11/30/2010)
Simple and nice article,
some time back i was working on validating a column in the database and i came across this issue and we had this function 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)

November 30, 2010 at 10:26 pm

#1257144

Viewing 15 posts - 35,821 through 35,835 (of 59,099 total)