Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,571 through 36,585 (of 59,102 total)

RE: Are the posted questions getting worse?

I got to "meet" the nicest person, today. I'm setting up to give a remote presentation and I got to work with Roy Ernest over the phone. Thanks...
--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)

September 29, 2010 at 12:27 am

#1228778
RE: Are the posted questions getting worse?

Stefan Krzywicki (9/28/2010)
GilaMonster (9/28/2010)
Stefan Krzywicki (9/27/2010)
GilaMonster (9/27/2010)
Tom.Thomson (9/27/2010)
Sturgeon got it wrong. He should have said 95%. At least of the developers I have interviewed I regard 95% as...
--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)

September 28, 2010 at 7:52 am

#1228359
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/27/2010)
Jeff Moden (9/27/2010)
...
I guess I should look at the more postive "at least people are trying" aspect.
If they are trying. Remember that posts, articles, etc....
--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)

September 28, 2010 at 7:47 am

#1228349
RE: Are the posted questions getting worse?

Grant Fritchey (9/27/2010)
Steve Jones - Editor (9/27/2010)
Jeff Moden (9/27/2010)
...
I guess I should look at the more postive "at least people are trying" aspect.
If they are trying. Remember that posts,...
--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)

September 28, 2010 at 7:26 am

#1228328
RE: Are the posted questions getting worse?

UMG Developer (9/27/2010)
Jeff Moden (9/27/2010)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/Forums/Attachment6921.aspx
Jeff,
You may want to edit your signature, your link to how to ask about T-SQL...
--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)

September 28, 2010 at 7:17 am

#1228319
RE: Are the posted questions getting worse?

Tom.Thomson (9/27/2010)
Stefan Krzywicki (9/27/2010)
I just hope I don't fall into the idiots category Jeff was talking about. I don't think I do, but then most idiots don't : -)
I have...
--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)

September 27, 2010 at 3:37 pm

#1228059
RE: Are the posted questions getting worse?

Grant Fritchey (9/27/2010)
Jeff Moden (9/27/2010)
Grant Fritchey (9/27/2010)
I just got bad news. I've seen the schedule for the PASS Summit. I'll be speaking to an empty room because I'm presenting 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)

September 27, 2010 at 3:30 pm

#1228055
RE: Are the posted questions getting worse?

UMG Developer (9/26/2010)
Jeff Moden (9/26/2010)
On that very note, I've recently been doing a whole lot of research for a little project I'm on concerning different methods to do certain 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)

September 27, 2010 at 1:18 pm

#1227948
RE: Are the posted questions getting worse?

Grant Fritchey (9/27/2010)
I just got bad news. I've seen the schedule for the PASS Summit. I'll be speaking to an empty room because I'm presenting the same time as Jeff....
--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)

September 27, 2010 at 1:05 pm

#1227935
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/27/2010)
Alvin Ramard (9/27/2010)
Jeff Moden (9/26/2010)
... there are a whole lot of people that should'na be allowed near a computer never mind a database.
Seen too many 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)

September 27, 2010 at 12:53 pm

#1227922
RE: Are the posted questions getting worse?

Tom.Thomson (9/23/2010)
and it made me thing yet again that we need to ask ourselves if the ANSWERs are getting worse. This was a perfectly reasonable question, but of 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)

September 26, 2010 at 7:20 pm

#1227493
RE: First and first character after space should be capital.

I know this is an older post but, if you're interested in performance, here's a new method I ran across. Yeah... I know. The RBAR method is 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)

September 26, 2010 at 6:50 pm

#1227491
RE: Slow performance in a cursor when using a sub select as part of the where clause

raistlinx (9/24/2010)
"Slow performance in a cursor"... I stopped reading here.
Seriously though, this is a little different than what you asked for, but in addition to looking at your sub select...
--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)

September 24, 2010 at 8:57 am

#1227042
RE: Synchronize 2 tables

cgreathouse (9/24/2010)
Hello
I looking for a way to synchronize 2 tables using SQL and not using external tools (like Red Gate). I have a SQL script that re-creates a lookup...
--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)

September 24, 2010 at 8:54 am

#1227038
RE: Create CSV file using sp_send_dbmail with field delimiters

john.hofmann 74371 (9/21/2010)
I was able to get something similar working, but it doesn't open in Excel. Well, it opens, but each row of data is just crammed into 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)

September 23, 2010 at 8:50 pm

#1226674

Viewing 15 posts - 36,571 through 36,585 (of 59,102 total)