Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,931 through 27,945 (of 59,101 total)

RE: An alternative to split for performance benefits?

Rob-350472 (12/7/2012)
I tried with 0x0a as the rowterminator instead but it generated the same results, I need to play some more with this (I've only used it once before 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 7, 2012 at 4:59 pm

#1566808
RE: An alternative to split for performance benefits?

Rob-350472 (12/7/2012)
I'm actually looking at the bulk insert technique now - in terms of data it's very simple, an Excel file with an email address per row, saved as 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 7, 2012 at 4:53 pm

#1566807
RE: Distributing the greatest value by rank in SQL

lmeinke (12/7/2012)
Thank you for taking the time to put into T-SQL. I should have done this to begin with. Hopefully with this and the above post (2 prior)...
--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 7, 2012 at 4:15 pm

#1566803
RE: hours,minutes Between Date Format Of Type Yyyymmddhhmmss

Lowell (12/7/2012)
you will hear this about a million times, but the number one rule is to store datetimes as datatimes; not as strings or bigints or any other datatype;
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 7, 2012 at 2:53 pm

#1566781
RE: hours,minutes Between Date Format Of Type Yyyymmddhhmmss

rajkiran.panchagiri (12/7/2012)
I have 2 dates format like 200903021124 and 200903030254.how to get hours,minutes Between those dates?
Are those stored as BIGINT or some character based datatype? Can't tell from here....
--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 7, 2012 at 2:48 pm

#1566779
RE: xml as input parameter in stored procedure

The problem with XML for such "simple" structures is that they're extremely bloated with totally unnecessary tag information. While it doesn't seem bad on a single call to 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 7, 2012 at 2:39 pm

#1566777
RE: Type A, B, or C

This all (in particular, MB) sounds like the same bad idea that I saw in a movie once. If you didn't have the right type of DNA, you weren't...
--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 7, 2012 at 2:23 pm

#1566773
RE: Made stupid mistake, need help removing duplicates

ryetimothy (12/7/2012)
So I ran the test code and it worked. I'm guessing my next step is to try it on a section of the real table, but I had...
--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 7, 2012 at 1:56 pm

#1566760
RE: Made stupid mistake, need help removing duplicates

That's good info but I still can't figure out what you want deleted from the data that you've provided.
--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 7, 2012 at 12:48 pm

#1566731
RE: Update Gaps

Cadavre (12/7/2012)
Jeff Moden (12/6/2012)
I don't know what others call this type of problem but I call them "data smears" because it's like you smearing strips of color down from one...
--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 7, 2012 at 12:14 pm

#1566724
RE: Made stupid mistake, need help removing duplicates

ryetimothy (12/7/2012)
SELECT '154304W','3','2009','Acer saccharinum','A','4','Aug 10 2009 10:08AM','1265'UNION ALL
SELECT '154304W','3','2009','Acer saccharinum','B','6','Aug 10 2009 10:08AM','1266'UNION ALL
SELECT '154304W','3','2009','Acer saccharinum','C','4','Aug 10 2009 10:08AM','1267'UNION ALL
SELECT '154304W','3','2009','Acer saccharinum','D','1','Aug 10 2009 10:08AM','1268'UNION ALL
SELECT '154304W','3','2009','Acer saccharinum','E','5','Aug 10 2009...
--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 7, 2012 at 12:12 pm

#1566722
RE: Exercises in t-SQL

Rock from VbCity (12/7/2012)
Now, the most remarkable is that nobody yes, nobody ever, mentioned the word " It depends"
BWAAA-HAAA!!!! Maybe not it so many words but that's...
--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 7, 2012 at 9:08 am

#1566659
RE: High availability best practice?

I you have SANS from the same company at each site, you can do SAN replication and relieve SQL Server a bit. That'll also work for non-SQL Server files,...
--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 6, 2012 at 11:54 pm

#1566463
RE: Exercises in t-SQL

I don't think its possible for me to determine, I lack the experience.
In that case, let's leave it as that. +100 for honesty. 🙂
--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 6, 2012 at 11:42 pm

#1566455
RE: Update Gaps

oralinque (12/6/2012)
dwain.c & Jeff Moden, your solutions worked great! Thank you both so much!
Jeff - "Data smears" sounds good to me. Regarding the "clear requirements and readily consumable data"...
--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 6, 2012 at 11:27 pm

#1566451

Viewing 15 posts - 27,931 through 27,945 (of 59,101 total)