Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,756 through 37,770 (of 59,072 total)

RE: Convert CSV values in three columns to rows

Thank you for the test harness and your good code, Oleg. I'll check it out.
--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)

July 6, 2010 at 9:24 pm

#1189402
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/6/2010)
WayneS (7/5/2010)
Since there's a bit of talk going on about topics to present and such, I'd like to get some input from some of the Threadizens...
I've been contemplating making...
--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)

July 6, 2010 at 9:18 pm

#1189401
RE: Are the posted questions getting worse?

Paul White NZ (7/6/2010)
Jeff Moden (7/6/2010)
Oddly enough, I'd heard that Forward_Only Read_Only was faster than Fast_Forward. Heh.... guess what I'm NOT going to test. :hehe:
Yep, but you also need...
--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)

July 6, 2010 at 12:14 pm

#1189262
RE: SSRS rendering limits?

Heh... not to worry. Didn't take it the wrong way. I was truly sorry for being short on the subject.
So far as SSAS being a "good GUI".... it's...
--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)

July 6, 2010 at 11:14 am

#1189224
RE: Cursor

j-1064772 (7/6/2010)
why not
WHILE (@@FETCH_STATUS = 0)
You could certainly do it that way... I just like to avoid the extra FETCH that requires.
--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)

July 6, 2010 at 11:03 am

#1189211
RE: Are the posted questions getting worse?

Paul White NZ (7/6/2010)
Jeff Moden (7/6/2010)
...the only reason why I know how to write one (or at least I think I know how to write one :hehe:)...
The cursor you wrote...
--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)

July 6, 2010 at 6:40 am

#1189067
RE: Are the posted questions getting worse?

David Burrows (7/6/2010)
Jeff Moden (7/6/2010)
If you take a look at the rest of that post, it's saying "Don't use cursors" 72 different ways.
Making excuses after the fact does 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)

July 6, 2010 at 6:39 am

#1189065
RE: Should DBAs Be the Protectors of Data?

joel.weiss 70857 (7/6/2010)
I agree with your mentor up to a point, and this is a critical point: a DBA, by definition, is an administrator, not an officer. Seeking out...
--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)

July 6, 2010 at 6:23 am

#1189057
RE: Should DBAs Be the Protectors of Data?

paul s-306273 (7/5/2010)
Off topic, but when did SSC-Insane ranking come in?
It seems like Steve made it up right after I tipped the 20K mark. Since I'm 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)

July 6, 2010 at 6:19 am

#1189053
RE: How to easily create a TableDiff batch file

rajmaiet (7/5/2010)
Hi
I am executing the above query but tables are not being creeated and the script is not giving any error also
Please suggest what needs to be checked.
Thanks
Rajendra:-)
If you ran...
--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)

July 6, 2010 at 6:06 am

#1189042
RE: Are the posted questions getting worse?

WayneS (7/5/2010)
Be still, my heart!
Jeff's now teaching how to write a c.u.r.s.o.r.
:w00t:
(Who would have thought he would be able to even write one??? ;-):-P )
BWAA-HAAA!!! The 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)

July 6, 2010 at 5:59 am

#1189039
RE: Strange UNION ALL behaviour

Ah... I get it. It did seem the other way, though. Too funny... 😛
--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)

July 5, 2010 at 10:46 am

#1188839
RE: Strange UNION ALL behaviour

Gianluca Sartori (7/5/2010)
Both queries returns 30 rows at most, so it should be no problem.
BWAA-HAAA!!! I never thought I'd see you make such a justification. 😀
--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)

July 5, 2010 at 9:50 am

#1188821
Reply To: How to convert int primary key to uniqueidentifier

azadpeyma.parham 32837 (7/4/2010)
Jeff,
I am completely conviced. Your explanation was so thourough and precise. I was wrong. Actualy, it was not my fault, I was kinda misled, since I have seen...
--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)

July 5, 2010 at 9:33 am

#1188817
RE: Cursor

vedpsoni (7/5/2010)
Hello Sir
I just wanna know that what is cursor
is it datatype or object and how
and what is use of cursor when we have its alternate
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)

July 5, 2010 at 9:13 am

#1188808

Viewing 15 posts - 37,756 through 37,770 (of 59,072 total)