Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,876 through 37,890 (of 59,098 total)

RE: create row for comma seperate

gideon.kahl (6/29/2010)
WayneS (6/29/2010)Out of curiousity, did you use the first solution as it's written, or did you follow the recommendation to build your very own tally table with a clustered...
--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)

June 30, 2010 at 6:42 am

#1187019
RE: Function in Joining column degrades performance in 2008

Heh... I finally beat Grant to the punch for a change. 😀
--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)

June 30, 2010 at 6:35 am

#1187015
RE: Function in Joining column degrades performance in 2008

aravind-305595 (6/29/2010)
Hi,
I have an existing code in sql server 2000, which after migrating to sql server 2008 the performance has become poor.
The query inside the code have a select statement...
--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)

June 30, 2010 at 6:32 am

#1187010
RE: Trying to use a variable as input in SQLStatement within a ForEach Loop

I don't use SSIS so I have no clue but let my post serve as a "bump" to someone who may. 🙂
--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)

June 29, 2010 at 9:13 pm

#1186831
RE: Insert 10,000 records in one second (LogFile??)

Eugene Elutin (6/29/2010)
Morteza,
Hornestly, I believe that your question is not really for a forum discussion. It is too many factors which would determine the best solution for your company....
--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)

June 29, 2010 at 9:10 pm

#1186828
RE: Problem with query on indexed computed column

Duncan Pryde (6/29/2010)
Does anyone have any ideas what I should try looking at to get this working?
Yes... Google for "Parameter Sniffing" for the reason caused by multiple causes and repaired...
--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)

June 29, 2010 at 9:01 pm

#1186823
RE: Kudos to the Community

Michael Valentine Jones (6/29/2010)
Dan.Humphries (6/29/2010)
...I have never gotten the snarky type of responce that is so normally typical on other IT boards...
It's not all love and kisses around here; Check...
--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)

June 29, 2010 at 8:57 pm

#1186821
RE: create row for comma seperate

lmu92 (6/29/2010)
WayneS (6/28/2010)
lmu92 (6/28/2010)
Ok, kinda funny I had to go back to this post within just a few hours...
The first person who "forced" me to do it actually...
--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)

June 29, 2010 at 8:42 pm

#1186819
RE: need some help on a pivot

lmu92 (6/29/2010)
torpkev (6/29/2010)
That worked perfectly, thanks so much..
I was pretty close in what I had but wasn't quite there.. and the link on dynamic cross tab sounds pretty interesting -...
--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)

June 29, 2010 at 8:28 pm

#1186816
RE: Replace single or multiple hyphen(-) with a space.

Dohsan (6/29/2010)
Having a read of this article should help you:
http://www.sqlservercentral.com/articles/T-SQL/68378/
Actually, I have to admit, my really cool (or so I thought :blush: )method got the pants beat off it by...
--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)

June 29, 2010 at 8:22 pm

#1186814
RE: Variable Table Names in SP ?

All good ideas, Wayne. Thanks 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)

June 29, 2010 at 7:49 pm

#1186810
RE: Variable Table Names in SP ?

ColdCoffee (6/28/2010)
homebrew01 (6/28/2010)
In the last code example, what does " SELECT CHAR(10)" and "FOR XML PATH('') " do in this case ?
CHAR(10) inserts a line-break in the output result
FOR XML...
--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)

June 29, 2010 at 7:24 pm

#1186806
RE: T-SQL for creating a text file with with this filename format - Month(MM)Day(dd)Year(yyyy).Log

WayneS (6/29/2010)
vince.chittenden (6/29/2010)
If the month function never returns a zero-length string (and it never will in this case, AFAICS), then why not '0' instead of '00'?
You are correct, this would...
--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)

June 29, 2010 at 7:09 pm

#1186805
RE: Need Expert advice on my sql query for speed improvement

... and to be sure, I stand corrected. Thanks again for the link to Paul's article on the subject.
--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)

June 29, 2010 at 7:02 pm

#1186804
RE: Kudos to the Community

Dan.Humphries (6/29/2010)
... and I have never gotten the snarky type of responce that is so normally typical on other IT boards.
Ya know, I'm glad I'm not the only 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)

June 29, 2010 at 7:00 pm

#1186803

Viewing 15 posts - 37,876 through 37,890 (of 59,098 total)