Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,136 through 30,150 (of 59,101 total)

RE: Finding rows with wildcards in the string and rows with spaces in front or at the end of the string.

Do you really mean that all you want to see is things that have other than 0-9 or A-Z or embedded spaces in them?
If so, you can use something 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)

May 8, 2012 at 6:00 pm

#1484828
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (5/8/2012)
I assume most of you saw it, but for those that didn't, my wife quit her job[/url].
Absolutely awesome! Congratulations to you both, Steve!
--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)

May 8, 2012 at 5:00 pm

#1484818
RE: RegEx for DBAs

Cadavre (5/8/2012)
Let's create some sample data to play with first.
I should have known it would be you. 🙂 Very well done, Craig! Thanks for stepping up to the plate!
--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)

May 8, 2012 at 4:55 pm

#1484817
RE: RegEx for DBAs

borisk 57245 (5/8/2012)
Jeff Moden (5/8/2012)
borisk 57245 (5/8/2012)
RegEx is Thee best tool in order to find any pattern within given string[did couple of test including .Net String manipulation and limited RegEx...
--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)

May 8, 2012 at 4:52 pm

#1484815
RE: Referential Integrity: Who needs it - right? (Discussion)

GilaMonster (5/8/2012)
Jeff Moden (5/8/2012)
I've worked with a couple of supposedly "hot" front end developers lately and they designed tables like the one I cited. When I asked them "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)

May 8, 2012 at 4:37 pm

#1484810
RE: Count Data in Large Seprated Text

ahmedhussein787 (5/8/2012)
thanks dwain.c
what if the cell may contain more than one country or more than one city
SELECT 1, 'Ronaldo', 'Country:Spain, City:Madrid, Country:Spain'
UNION ALL SELECT 2, 'Messi','Country:Spain, City:Barcelona, City:Madrid'
UNION ALL SELECT...
--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)

May 8, 2012 at 4:31 pm

#1484807
RE: insert 100 rows without using loop or union etc.,

michael vessey (5/8/2012)
i see my humour is lost on you jeff
Nah... I had a smiley face there. 🙂 I just didn't want a newbie reading that to miss the...
--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)

May 8, 2012 at 9:04 am

#1484583
RE: Referential Integrity: Who needs it - right? (Discussion)

opc.three (5/8/2012)
jasonmorris (5/8/2012)
Has anybody come across the CADIS Enterprise Data Management product?
Where I work they always insist that any import tables for third party text data are nvarchar(4000) and there...
--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)

May 8, 2012 at 9:01 am

#1484578
RE: Referential Integrity: Who needs it - right? (Discussion)

Ok. Now I see where you're coming from and THAT's what I envisioned as "premature optimization".
The problem is how certain mantra's get bastardized over time. I've worked with...
--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)

May 8, 2012 at 8:56 am

#1484575
RE: RegEx for DBAs

Solomon Rutzky (5/8/2012)
Jeffrey Bijkerk (5/8/2012)
If you use regex combined with a where clause it can not use the index anymore. I think this is very important.
Hi Jeffrey. It is important...
--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)

May 8, 2012 at 8:41 am

#1484557
RE: RegEx for DBAs

borisk 57245 (5/8/2012)
RegEx is Thee best tool in order to find any pattern within given string[did couple of test including .Net String manipulation and limited RegEx in SQL , Like/PATIndex....],...
--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)

May 8, 2012 at 8:37 am

#1484554
RE: RegEx for DBAs

I completely agree, Solomon... that's why I'm discussing the "con" side of this.
What I've found is that people will take some nice tools like you've developed and use them 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)

May 8, 2012 at 8:32 am

#1484547
RE: RegEx for DBAs

david.rowland (5/7/2012)
Although RegEx is powerful, I have tried using it once and found that coding my own CLR function to manipulate strings to what I want was 100 times faster...
--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)

May 8, 2012 at 12:21 am

#1484330
RE: RegEx for DBAs

Great and very nicely put together article, David. My hat is off to you. But what of performance? Have you done any comparisons between the Regex 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)

May 8, 2012 at 12:19 am

#1484328
RE: Are the posted questions getting worse?

Sorry... comment removed.
--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)

May 7, 2012 at 11:55 pm

#1484319

Viewing 15 posts - 30,136 through 30,150 (of 59,101 total)