Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,316 through 45,330 (of 59,101 total)

RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

idrees.butt (2/2/2009)
Can you tell some articles that list common mistakes?
http://www.sqlservercentral.com/Forums/Topic627665-338-1.aspx
--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)

February 3, 2009 at 4:15 am

#937007
RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

Go for it. 😉
--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)

February 3, 2009 at 4:08 am

#937004
RE: Top 1 or Max??

Bruce W Cassidy (2/2/2009)
[font="Verdana"]Is the MyDateColumn unique? Because if it's not, the second form could return more than one row.
Ooops, really should read all of the replies before posting....
--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)

February 2, 2009 at 8:26 pm

#936889
RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

Max (2/2/2009)
Jeff Moden (2/2/2009)
The chicken was loyal...
... the pig was dedicated. 😛
Only problem was that the pig didn't last that long - minor omission though, everyone give Jeff a round...
--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)

February 2, 2009 at 8:24 pm

#936888
RE: Difference between varchar(max) and varchar(8000)

charlesz (2/2/2009)
Second, NVarchar(MAX) and Varchar(MAX) can only hold up to 65535 bytes ( The number posted by Gail Shaw was wrong).
Any bets on that?
DECLARE @test-2 VARCHAR(MAX),
...
--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)

February 2, 2009 at 8:19 pm

#936887
RE: list of month names and week ranges between dates

ghughes (2/2/2009)
ok, you are right. At the time I was swamped and trying to fix the next dozen problems on my list. I cant find my link...
--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)

February 2, 2009 at 7:58 pm

#936883
RE: list of month names and week ranges between dates

Bruce W Cassidy (2/2/2009)
[font="Verdana"]Heh, that's kinda ironic. Jeff Moden asking for a URL to one of his own posts.[/font]
It had to happen, someday. It's funny as hell that'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)

February 2, 2009 at 7:56 pm

#936882
RE: how to reterive a single record from a table

GSquared (1/29/2009)
Do you know how to write a Select statement?
Heh... bad day, Gus? 😉
--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)

February 2, 2009 at 7:53 pm

#936881
RE: how to reterive a single record from a table

The real answer to this question should have been "Since data is not guaranteed to be in any order in a table or query result, and ORDER BY would be...
--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)

February 2, 2009 at 7:51 pm

#936880
RE: how to reterive a single record from a table

Max (1/29/2009)
Lowell (1/29/2009)
... insulting people who are trying to help will not get you anything...
here here
... but you still answered the question, didn't you? 😉 If it were...
--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)

February 2, 2009 at 7:31 pm

#936876
RE: Permissions for Developers

I 110% agree with that! And, there may be restrictions on some other tables, as well. For example, tell me why a developer would need to know anyone...
--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)

February 2, 2009 at 7:25 pm

#936875
RE: Strange network error

kevriley (2/2/2009)
Todd,
it is happening everytime with one id and not with another - but I've checked anti-virus and that isn't kicking in.
Kev
I can't remember exactly what the phrase in 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)

February 2, 2009 at 7:23 pm

#936874
RE: Count() with expressions, vs. numerics

GSquared (2/2/2009)
Look up Jeff Moden's article on Running Totals (on this site). Should be able to use that for what you need.
The article is temporarily "offline" until I can...
--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)

February 2, 2009 at 7:19 pm

#936872
RE: non sysadmin needs to modify a couple of sql agent jobs

fizzleme (2/2/2009)
We have a contractor who needs to modify a couple of SQl agent jobs on our server. He is using standard SQl security to connect.
The SQL agent jobs...
--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)

February 2, 2009 at 7:05 pm

#936864
RE: Logs for table updates

SQL Server 2000 has none of those features.
--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)

February 2, 2009 at 7:01 pm

#936862

Viewing 15 posts - 45,316 through 45,330 (of 59,101 total)