Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,341 through 44,355 (of 59,097 total)

RE: The T-SQL Paradigm

Steve Jones - Editor (4/6/2009)
Jeff Moden (4/6/2009)
Heh... no, I get it. But there are still rules of thumb that absolutely must be followed.
There are, but unfortunately we...
--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)

April 6, 2009 at 9:49 pm

#973058
RE: The T-SQL Paradigm

Heh... brackets... they sure did take a shortcut there. It would be nice if the automatic code generators didn't put those in unless actually required.
--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)

April 6, 2009 at 9:47 pm

#973057
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/6/2009)
Jeff,
We have two developments ongoing. One was our regular developer/week a month that I believe tried to fix some code items. Those are in test now,...
--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)

April 6, 2009 at 9:28 pm

#973053
RE: Challenging SQL interview questions

On the Halloween thingy... that's what I call an "oolie" and it shouldn't make or break an interview. If someone knows it, then it may be a bonus unless...
--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)

April 6, 2009 at 7:05 pm

#973025
RE: Challenging SQL interview questions

Paul White (4/5/2009)
Also try to remember what it was like when you first started out.
Actually, that's a pretty good point. So is the point about newbies not knowing some...
--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)

April 6, 2009 at 7:00 pm

#973021
RE: Challenging SQL interview questions

Paul White (4/6/2009)
@jeff,
Thanks! But all those smileys have left me emotionally confused :-DPaul
BWAA-HAAA!!! Now that's funny! Like I said, "Welcome aboard"... you're gonna fit in just fine.
--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)

April 6, 2009 at 6:46 pm

#973016
RE: T-Sql rant

cs_troyk (4/6/2009)
Not to mention, Jeff, that you missed your mark by one post. Or is it OK for Sergiy to call Steve's post (or was it Steve?) "a pile of...
--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)

April 6, 2009 at 4:57 pm

#972990
RE: Challenging SQL interview questions

GSquared (4/6/2009)
Jeff Moden (4/6/2009)
Here's a perfect example...
http://www.sqlservercentral.com/Forums/Topic688949-8-1.aspx
My answer would have been... "Thanks for the setup code... please post the code that you've tried so far so we can point you...
--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)

April 6, 2009 at 10:42 am

#972722
RE: The T-SQL Paradigm

davidandrews13 (4/6/2009)
i code in VB.net and i'm relatively new to using SQL, only doing it for about 1 and a half years, so i have to admit that i dont...
--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)

April 6, 2009 at 10:16 am

#972691
RE: Challenging SQL interview questions

Here's a perfect example...
http://www.sqlservercentral.com/Forums/Topic688949-8-1.aspx
My answer would have been... "Thanks for the setup code... please post the code that you've tried so far so we can point you in the right...
--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)

April 6, 2009 at 8:57 am

#972590
RE: Challenging SQL interview questions

I agree... Barry's initial response was a bit "curt"... and I also think it was absolutely appropriate.
Look at the list of items asked in the Original post... these are relatively...
--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)

April 6, 2009 at 8:50 am

#972585
RE: Timed Triggers.. Possible ???

Jack Corbett (4/6/2009)
Jeff Moden (4/4/2009)
Heh... I agree... probably an inteview question.
I believe the question actually asks "how would you write a trigger that executed another stored procedure but only at...
--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)

April 6, 2009 at 8:22 am

#972560
RE: The T-SQL Paradigm

Aaron N. Cutshall (4/6/2009)
Jeff Moden (4/6/2009) The first rule that many developers seem to omit is that the code actually has to work. 😉
OK, you got me there!:-P However,...
--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)

April 6, 2009 at 8:17 am

#972555
RE: Duplicate Records using SQLCMD

First, let me take nothing from the article. It's well written and clear. Well done.
However, the following statement seems to destroy whatever utility was intended in the code...
Note...
--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)

April 6, 2009 at 8:01 am

#972539
RE: Are the posted questions getting worse?

GSquared (4/6/2009)
I noticed that a lot of the pages here slowed down like crazy when the prettier code blocks were added in. There's a script that formats them, 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)

April 6, 2009 at 7:36 am

#972518

Viewing 15 posts - 44,341 through 44,355 (of 59,097 total)