Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,081 through 40,095 (of 59,098 total)

RE: Extract X and Y coordinates out of a string and check if within range

Hi Charlotte,
I do have a question about the data you were kind enough to provide... how can a polygon have a single "X" coordinate and no "Y" coordinate? Why...
--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 29, 2010 at 7:13 pm

#1111085
RE: Database Design- IS NOT NULL always better choice?

As has been suggested, you could start a real religious war over this.
I believe there are two questions here... the first is "should we use nulls" and the second 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 29, 2010 at 6:47 pm

#1111083
RE: Are the posted questions getting worse?

Grant Fritchey (1/29/2010)
Paul White (1/29/2010)
Jeff Moden (1/28/2010)
Would someone explain to me the attraction to sites like Twitter and FaceBook and explain what they're actually good for so...
It's a bit like...
--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 29, 2010 at 5:50 pm

#1111079
RE: spliting the data using replace function

You bet. Thank you for the feedback.
--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 29, 2010 at 5:45 pm

#1111077
RE: Are the posted questions getting worse?

Paul White (1/29/2010)
Jeff Moden (1/28/2010)
Would someone explain to me the attraction to sites like Twitter and FaceBook and explain what they're actually good for so...
It's a bit like SQL Server...
--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 29, 2010 at 6:18 am

#1110675
RE: How Do You Handle the Stress of Being a DBA?

😛
Ben Moorhouse (1/25/2010)
Ha! So true Jeff!
I've been working alongside another person in my team, and I keep having to solve stupid mistakes.
Such as records not being deleted even though I'm...
--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 28, 2010 at 8:22 pm

#1110434
RE: How Do You Handle the Stress of Being a DBA?

Nicholas Cain (1/27/2010)
I like to make poke fun at us SQL DBA's with our Oracle counterparts in the group. Once you admit to them that SQL Server is just 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 28, 2010 at 8:18 pm

#1110432
RE: any one no where to place these 3 below statements in a CURSOR to find get info on the cursor

adam spencer (1/28/2010)
Lynn and All, thank you for your help. I quit my job, moved my wife and I to Austin Texas (Texas is ranked high as having IT/IS 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)

January 28, 2010 at 8:16 pm

#1110431
RE: spliting the data using replace function

anitha.cherukuri (1/28/2010)
Unfotunately If notetext does not have searching strings ,its giving error.
I was under the impression that all of the "searching strings" would be available for every row. Since...
--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 28, 2010 at 8:09 pm

#1110426
RE: Running total , missing date , NULL in amount, exception handling

karthikeyan-444867 (1/27/2010)
Jeff,
Code has been moved to PROD. Execution time is 26 seconds.
Dynamic Sql Part : 13 Seconds
Quirky Update(#...
--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 28, 2010 at 6:54 pm

#1110415
RE: Are the posted questions getting worse?

Heh... seems to be the week for Twitter... I've gotten a half dozen emails and a couple of in person queries as to why I'm not on Twitter, FaceBook, etc,...
--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 28, 2010 at 6:41 pm

#1110409
RE: Are the posted questions getting worse?

CirquedeSQLeil (1/27/2010)
I need a couple of volunteers if any are willing and have some spare time.
I am wrapping up an article and would like somebody else to review it 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)

January 28, 2010 at 6:32 pm

#1110407
RE: Are the posted questions getting worse?

CirquedeSQLeil (1/27/2010)
Jeff Moden (1/27/2010)
Alvin Ramard (1/27/2010)
Oh, before I forget Jason, we passed on to our local chapter membership the link to your blog about user group participation. That 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 28, 2010 at 6:30 pm

#1110405
RE: Are the posted questions getting worse?

Alvin Ramard (1/27/2010)
Oh, before I forget Jason, we passed on to our local chapter membership the link to your blog about user group participation. That should be required reading...
--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 27, 2010 at 4:36 pm

#1109662
RE: Row to Column Conversion

Thanks for the compliment, Nabha. :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)

January 27, 2010 at 3:28 pm

#1109632

Viewing 15 posts - 40,081 through 40,095 (of 59,098 total)