Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,306 through 40,320 (of 59,098 total)

RE: Are the posted questions getting worse?

Grant Fritchey (1/13/2010)
My sincere apologies to the group for the term I used. I had learned it, a long time ago, in terms like this, not like the first slang...
--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)

January 13, 2010 at 7:49 pm

#1103394
RE: Values from row to columns as indicator

Outstanding. Thanks for the feedback. C'mon back if you get stuck.
--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)

January 13, 2010 at 7:37 pm

#1103393
RE: Optimising “Ends With” searches with REVERSE

Rome1981 (1/13/2010)
I was just about to post the same. Good to know there are people testing these solutions/examples.
Jeff- That is very good advice, I did not know that.
Thanks for 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)

January 13, 2010 at 9:13 am

#1103136
RE: Optimising “Ends With” searches with REVERSE

peter-757102 (1/13/2010)
Note that indexes can only have a limited width (300 bytes or so , I believe).
Because of this, it makes sense to do a reverse of only the last...
--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)

January 13, 2010 at 9:10 am

#1103132
RE: Optimising “Ends With” searches with REVERSE

Jeff Moden (1/13/2010)
Don't get me started on what a poor metric the number of 'logical reads is'
Heh... now you know why I couched it all in "It Depends". ...
--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)

January 13, 2010 at 9:09 am

#1103128
RE: Date Format (mm/dd/yyyy hh:mm), no seconds or milliseconds

Paul White (1/12/2010)
Jeff Moden (1/12/2010)
Check again... op asked for mm/dd/yyyy hh:mm. Above code returns yyyy-mm-dd hh:mi 😉
Assuming you don't mind using the Microsoft version of the Kuwaiti algorithm of...
--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)

January 13, 2010 at 5:22 am

#1102974
RE: Optimising “Ends With” searches with REVERSE

Good article and makes a lot of sense... providing that the table doesn't have a lot of inserts where every index counts AGAINST inserts. Most people don't know 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)

January 13, 2010 at 12:26 am

#1102908
RE: Date Format (mm/dd/yyyy hh:mm), no seconds or milliseconds

imhemal29 (1/12/2010)
Select Cast(convert(varchar(16),Getdate(),120) as DateTime) as [Date]
And
Select convert(varchar(16),Getdate(),120) as [Date]
Check again... op asked for mm/dd/yyyy hh:mm. Above code returns yyyy-mm-dd hh:mi 😉
--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)

January 12, 2010 at 11:27 pm

#1102887
RE: Are the posted questions getting worse?

lobbymuncher (1/10/2010)
bitbucket-25253 (1/9/2010)
Take a look at this one
http://www.sqlservercentral.com/Forums/Topic844889-392-1.aspx
It is one of the worst I have seen on SSC in a long long time.
Lynn - I must compliment you on your...
--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)

January 12, 2010 at 11:21 pm

#1102885
RE: Values from row to columns as indicator

Yes... it's absolutely possible. I realize that you've tried a couple of posts on dynamic SQL and haven't been able to get it because you're "new". However, 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)

January 12, 2010 at 10:26 pm

#1102877
RE: importing tab delimited file with various line length

rnikandrov (1/8/2010)
the goal is to import file so that i can work with it.
here is a sample:
A 919934 [tab] 1 [tab] jason
B 2222 [tab] 999999 [tab] 111111 [tab] 1113
C 2...
--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)

January 11, 2010 at 8:56 pm

#1102157
RE: parse comma-delimited list into seperate columns

@Wayne, Lutz, and Jason,
When some of the Ninjas on this site did some extreme "split" testing, one of the things that we found out was that if all the rows...
--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)

January 11, 2010 at 8:47 pm

#1102156
RE: parse comma-delimited list into seperate columns

WayneS (1/11/2010)
Well, the concept comes from Jeff. 'nuf said. 😉
:blush:
Still, that's an interesting warp on the "quirky update". Nicely done, Wayne.
It would be interesting to run a race between...
--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)

January 11, 2010 at 8:41 pm

#1102151
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

RBarryYoung (1/8/2010)
Great article again, Jeff! You just can't beat the classics. 😀
Thanks, Barry. Always good to hear from you and I hope your back is treating 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)

January 9, 2010 at 9:48 am

#1101400
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Bill Parrott (1/8/2010)
Very good article! I can't tell you how much time I've spent having to parse delimited in T-SQL. While I haven't gotten all the way through...
--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)

January 9, 2010 at 9:45 am

#1101398

Viewing 15 posts - 40,306 through 40,320 (of 59,098 total)