Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,786 through 37,800 (of 59,098 total)

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
RE: Strange UNION ALL behaviour

Gianluca Sartori (7/2/2010)
I decided to fix the thing using a table variable, but I didn't save the plans.
Just a thought... My recommendation would be to exercise the query that returns...
--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 4, 2010 at 11:50 am

#1188625
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Mike C (7/3/2010)
There are times when I recommend a T-SQL cursor over the alternatives, but they are few and far between. The issue though seems to be that there'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 4, 2010 at 10:55 am

#1188622
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

jyurich (7/3/2010)
Yes, you are correct and I thank you for clarifying that point. However, typically when I'm inserting PK int values only into a Memory based temp table, I do...
--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 4, 2010 at 10:50 am

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

azadpeyma.parham 32837 (7/3/2010)
Hi,
I have implemented a database in SQL-server 2008. In all tables, I have set all the primary keys to int. (Still, there is no data in database.)
I want...
--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 4, 2010 at 10:40 am

#1188618

Viewing 15 posts - 37,786 through 37,800 (of 59,098 total)