Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,976 through 33,990 (of 59,099 total)

RE: Get the First letter of each word within a string and returned a concatenated string

Vedran Kesegic (5/9/2011)
If explanation about very few loop iterations was not enough for you, here is a complete test case:
1 Row of test data simply doesn't constitute a "complete" test...
--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 10, 2011 at 8:51 am

#1322368
RE: Get the First letter of each word within a string and returned a concatenated string

Vedran Kesegic (5/10/2011)
You claim 700% faster yet I see no test data.
Jeff, did you run the script ?
Yep... 1 row does not constitute adequate test 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)

May 10, 2011 at 7:42 am

#1322302
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

By a "cell", I mean an intersection of a row and a column. I should have just said "data element".
I forgot about the dash. It's used 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)

May 9, 2011 at 9:46 pm

#1322077
RE: Get the First letter of each word within a string and returned a concatenated string

peterzeke (5/9/2011)
Jeff Moden (5/9/2011)
peterzeke (5/6/2011)
I'm trying to figure out how to concatenate the first letter of each word within a given string. It's bit like parsing a delimited list, I'd...
--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 9, 2011 at 9:38 pm

#1322074
RE: Get the First letter of each word within a string and returned a concatenated string

Vedran Kesegic (5/9/2011)
Jeff Moden (5/9/2011)
Vedran Kesegic (5/9/2011)
I could easily write it in the form of the non-RBAR, but the performance would not be as fast.
You have test code 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)

May 9, 2011 at 9:34 pm

#1322071
RE: manager - employee relationships

Try this out... and, no... there's no dynamic SQL in it. The bloody forum software just makes it look that way...
USE AdventureWorks;
WITH
cteDirectReports AS
(
SELECT EmployeeID, ManagerID,...
--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 9, 2011 at 7:49 pm

#1322053
RE: manager - employee relationships

I believe you're trying to solve too many problems at the same time. "Divide'n'Conquer". Solve the hierarchy first then join the other tables to get the amplifying information.
--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 9, 2011 at 7:03 pm

#1322049
RE: How to Denormalize Data / How to Flatten Normalized Data

jhorowitz10 (5/6/2011)
You might also want to check out this link:
http://www.sqlservercentral.com/articles/T-SQL/63681/
How to easily Converting Rows to Columns using Crosstabs
With a first post like that, I've just gotta say, "Welcome Aboard!"...
--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 9, 2011 at 6:48 pm

#1322047
RE: STOREPROC VERY SLOW

terrykzncs (5/9/2011)
Hi
Have you had any luck tuning your query?
Like they said before, start with replacing the cursors with set statements. But then replace the temp tables with table variables.
How big...
--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 9, 2011 at 6:39 pm

#1322046
RE: some questions ??

I actually prefer that people in the office ask me if there's something they don't know. The internet has way too many bad answers to a lot of things...
--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 9, 2011 at 6:28 pm

#1322045
RE: Are the posted questions getting worse?

SQLRNNR (5/7/2011)
GilaMonster (5/7/2011)
Jeff Moden (5/7/2011)
GilaMonster (5/6/2011)
Off to SQLSaturday, the first one in Africa
You can only say that once. I don't know if you had anything to do with it...
--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 9, 2011 at 6:04 pm

#1322043
RE: SQL Spackle - Find 0 values in sums by date

WayneS (5/9/2011)
Jeff Moden (5/9/2011)
I've got one still outstanding, myself.
Plus ~~a rewrite~~ an expansion of Tally OH! based on new findings, plus your book, plus the varchar(max) splitter, plus the Running...
--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 9, 2011 at 5:38 pm

#1322038
RE: Get the First letter of each word within a string and returned a concatenated string

peterzeke (5/6/2011)
I'm trying to figure out how to concatenate the first letter of each word within a given string. It's bit like parsing a delimited list, I'd imagine. Nonetheless, I...
--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 9, 2011 at 5:30 pm

#1322035
RE: Get the First letter of each word within a string and returned a concatenated string

Vedran Kesegic (5/9/2011)
I could easily write it in the form of the non-RBAR, but the performance would not be as fast.
You have test code that proves that, right?
--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 9, 2011 at 5:22 pm

#1322033
RE: Can you use a tally table to drive inserting X number of records in another table?

Thanks for the feedback, Christian.
--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 9, 2011 at 5:17 pm

#1322032

Viewing 15 posts - 33,976 through 33,990 (of 59,099 total)