Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,541 through 36,555 (of 59,067 total)

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
RE: I need some help with a test, please.

steve-893342 (9/23/2010)
Jeff Moden (9/22/2010)
steve-893342 (9/22/2010)
Jeff Moden (9/22/2010)
The problem with the Tally Table related splits is that I forgot :blush: to add 1 to the length....
WHERE N BETWEEN 1...
--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:43 pm

#1226672
RE: I need some help with a test, please.

Deleted. Made an error on datalength.
--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 22, 2010 at 9:17 pm

#1226037
RE: I need some help with a test, please.

steve-893342 (9/22/2010)
Jeff Moden (9/22/2010)
The problem with the Tally Table related splits is that I forgot :blush: to add 1 to the length....
WHERE N BETWEEN 1 AND LEN(@Parameter)+1
Shouldn't 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 22, 2010 at 7:28 pm

#1226029
RE: I need some help with a test, please.

Paul White NZ (9/22/2010)
Jeff Moden (9/22/2010)
The problem with the Tally Table related splits is that I forgot :blush: to add 1 to the length....
WHERE N BETWEEN 1 AND...
--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 22, 2010 at 7:26 pm

#1226028
RE: I need some help with a test, please.

steve-893342 (9/22/2010)
Jeff Moden (9/22/2010)
The problem with the Tally Table related splits is that I forgot :blush: to add 1 to the length....
WHERE N BETWEEN 1 AND LEN(@Parameter)+1
Shouldn't 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 22, 2010 at 6:54 pm

#1226023

Viewing 15 posts - 36,541 through 36,555 (of 59,067 total)