Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,816 through 34,830 (of 59,099 total)

RE: Parse City and State

As you can see, unless you know the names of the cities, it's going to be just about impossible. My recommendation would be to buy a CASS certification program...
--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)

March 3, 2011 at 9:16 pm

#1294432
RE: user defined function

mwwheeler (2/28/2011)
I basically wanted to use this function to make sure the contents can be safely converted to an integer and not cause an exception (if it contained a word)....
--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)

March 3, 2011 at 9:07 pm

#1294431
RE: Difference between varchar(max) and varchar(8000)

GilaMonster (3/3/2011)
Please note: 2 year old thread
Heh... yeah, but it's still fun. 😀
--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)

March 3, 2011 at 8:27 pm

#1294425
RE: Subroutines in TSQL

Telarian (3/3/2011)
Jeff Moden (3/3/2011)
Oh, be careful now. "It Depends". 🙂 Scalar and Multi-Line Table Valued Functions (mTVF) can very quickly turn code into some pretty nasty, performance challenged...
--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)

March 3, 2011 at 8:20 pm

#1294423
RE: Without using CTE, Please provide a recursive method

dba.varun.in (3/3/2011)
Dont use CTE because limit exceeds.
The limit of a CTE will not be exceeded if you set MAXRECURSION to zero. Read about it in Books Online.
Please provide solution...
--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)

March 3, 2011 at 7:36 am

#1294013
RE: Subroutines in TSQL

HowardW (3/3/2011)
This seems fitting given the circumstances:
http://xkcd.com/292/
:hehe:
Perfect!
--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)

March 3, 2011 at 7:23 am

#1294002
RE: SSIS Flat File Import with different file layouts

Koen Verbeeck (3/3/2011)
I would like to see your solution for 1 million+ rows.
I think the cursor and the fact that you need to store everything in a temp table will...
--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)

March 3, 2011 at 7:15 am

#1293995
RE: Subroutines in TSQL

Telarian (3/3/2011)
There can be any number of reasons to call a bit of code repeatedly. If that code is very simple and can easily fit into a UDF and perhaps...
--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)

March 3, 2011 at 6:51 am

#1293972
RE: Subroutines in TSQL

Eric M Russell (5/17/2010)
Jeff Moden (5/17/2010)
...
...
I used them to overcome the N4k and C8K barriers in SQL Server 2000.... and, yep... it was from another stored procedure.
Basically, how did creating...
--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)

March 3, 2011 at 6:32 am

#1293967
RE: Odd Questions

GSquared (3/2/2011)
Koen Verbeeck (3/2/2011)
GSquared (3/2/2011)
Actually, to partially refute my own assertion, I was once told why I wasn't hired. It was because "I was too strong a candidate". ...
--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)

March 2, 2011 at 11:17 pm

#1293855
RE: Odd Questions

Eric M Russell (3/1/2011)
CirquedeSQLeil (3/1/2011)
Koen Verbeeck (2/28/2011)
CirquedeSQLeil (2/28/2011)
Worst / strangest question was "how many of _______ can fit in a bus?" The interviewer wanted to argue with my answer...
--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)

March 2, 2011 at 11:13 pm

#1293853
RE: Missing row delimeter {CR}{LF} in .txt file

Yelena Varshal (3/1/2011)
Is there anything special with the character #40?
Hex or decimal?
--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)

March 2, 2011 at 11:09 pm

#1293852
RE: 'Pretty-up' the code

Thanks for the education, folks.
As a sidebar, I have a pharmacist that told me that there are a whole lot of MD's that don't even know how 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)

March 2, 2011 at 10:58 pm

#1293850
RE: Books/Online samples for SQL

georgetanner5 (3/2/2011)
Okay, I finally purchased and installed SQL 2008 Developer Edition (thanks to all who steered me in that direction) and I'm now looking to download/purchase some sample databases 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)

March 2, 2011 at 10:03 pm

#1293842
RE: Supposed embedded text qualifiers

opc.three (3/2/2011)
You have a nice file with escaped text delimiters but SSIS still does not care 🙂 This in my opinion is a *glaring* deficiency in SSIS and one that...
--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)

March 2, 2011 at 9:42 pm

#1293839

Viewing 15 posts - 34,816 through 34,830 (of 59,099 total)