Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,861 through 37,875 (of 59,072 total)

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
RE: Fixed width text file and SSIS

huber_jessica (6/28/2010)
Wow! The client ended up going in a different direction for data conversion so I never needed to finish that awful package. However, it's a standard file...
--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 6:49 pm

#1186801
RE: Cross Database Queries...Performance Impact?

bkothe (6/29/2010)
Thanks for the reply Jeff. Based on what I have read and from your response it doesn't seem like there should be any performance impact, at least nothing...
--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 6:32 pm

#1186798
RE: First Tally Table T-SQL

Paul White NZ (6/29/2010)
Agreed. One other important caveat - anyone running 32-bit SQL Server (why?) should go with a Tally solution too. SQLCLR and 32-bit servers are not...
--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 6:15 pm

#1186796
RE: First Tally Table T-SQL

scott.pletcher (6/29/2010)
Fwiw, here's my take on it, using just T-SQL. My upper-casing rule is (1) the first character and (2) any other letter preceded by a character that is...
--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 6:06 pm

#1186793
RE: Convert CSV values in three columns to rows

scott.pletcher (6/29/2010)
So, the inline CTE has better performance than a tally table? Interesting. Sometimes SQL's performance traits are a bit quirky.
In other functions, I've not found that 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)

June 29, 2010 at 6:03 pm

#1186792
RE: Convert CSV values in three columns to rows

WayneS (6/29/2010)
Sigh... I sure wish we could put into the briefcase an individual post on the forum... This one of Jeff's certainly would be in it.
@jeff -
1. Did 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)

June 29, 2010 at 6:00 pm

#1186790
RE: Are the posted questions getting worse?

rjohal-500813 (6/28/2010)
Chris Morris-439714 (6/28/2010)The question reads "What will be the output of the following?" and none of the answers is correct.
If the question was "Which of these options best...
--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 5:45 pm

#1186783
RE: Generating a Distinct Delimited List Using XML

Brian Barkauskas (6/29/2010)
OK, then use GROUP:
--An alternative without ROW_NUMBER()
--How about this?
select
u.UserID
, stuff((
...
--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 5:21 pm

#1186777
RE: Convert CSV values in three columns to rows

WayneS (6/28/2010)
lmu92 (6/28/2010)
This thread include a post by WayneS showing the DelimitedSplit8K function I'm using at the moment.
I believe I saw a follow-up post from Jeff where he found 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 6:38 am

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

GilaMonster (6/28/2010)
Jeff Moden (6/28/2010)
...and the data on each page is also in physical order.
Not necessarily. Rows on a page don't have to be in any specific order, SQL puts them...
--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 5:38 am

#1186285
RE: Code to convert varchar datatype that contains a numeric expression to a date

Paul White NZ (6/25/2010)
Gianluca Sartori (6/25/2010)
Great code, Paul, as usual!!
Thanks. Sorry I didn't notice your reply before.
Just one question: what does schemabinding mean here? The return value depends only...
--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 28, 2010 at 5:51 pm

#1186122

Viewing 15 posts - 37,861 through 37,875 (of 59,072 total)