Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,726 through 37,740 (of 59,098 total)

RE: create a function

Joe Celko (7/12/2010)
These "tables need to have keys. and constraints; they are not really tables at all.
CREATE TABLE TB1
(something_name VARCHAR(255) NOT NULL PRIMARY KEY,
something_age INTEGER NOT NULL...
--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 13, 2010 at 6:24 pm

#1192452
RE: Assigning some week numbers

m.dunster (7/12/2010)
Through your example for creating the data...I have learnt about table variables and will now be replacing all my temp table work !!
Don't do that. It could 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)

July 13, 2010 at 6:13 pm

#1192442
RE: Are the posted questions getting worse?

Stefan Krzywicki (7/13/2010)
Jeff Moden (7/13/2010)
CirquedeSQLeil (7/13/2010)
Here's another one in the same doc.
As a rule of thumb, once a table has more than five indexes, updates to that table may 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)

July 13, 2010 at 5:56 pm

#1192434
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/13/2010)
Anybody have any comments on this nugget?
•Never include a USE <database> statement in scripts.
I just found this in a doc here at work.
I'd like to see the context 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)

July 13, 2010 at 5:50 pm

#1192433
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/13/2010)
Here's another one in the same doc.
As a rule of thumb, once a table has more than five indexes, updates to that table may be adversely affected since 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)

July 13, 2010 at 5:38 pm

#1192426
RE: Are the posted questions getting worse?

Trey Staker (7/12/2010)
Hearing the ops story reminded me of someone I worked with when I was new in my career. He had been working in IT/Technology a long time...
--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 13, 2010 at 5:36 pm

#1192424
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/12/2010)
Chad Crawford (7/12/2010)
Jeff Moden (7/9/2010)
I promise to publish it right after PASS if it's not called upon.
🙁 I don't want to wait. I...
--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 13, 2010 at 5:03 pm

#1192412
RE: Are the posted questions getting worse?

Chad Crawford (7/12/2010)
Jeff Moden (7/9/2010)
I promise to publish it right after PASS if it's not called upon.
🙁 I don't want to wait. I had to build a...
--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 13, 2010 at 5:00 pm

#1192411
RE: Are the posted questions getting worse?

GilaMonster (7/12/2010)
CirquedeSQLeil (7/9/2010)
Oh and Congrats Jeff.
Ditto.
Aye... thanks old friend. I'm very much looking forward to finally meeting you in person.
--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 13, 2010 at 4:55 pm

#1192410
RE: Are the posted questions getting worse?

Roy Ernest (7/12/2010)
Congrats Jeff... Hopefully I will see you all at the Pass Summit..!!!!
Thanks, Roy. Like they say down South, "Can't wait to meet all'y'all!"
--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 13, 2010 at 4:48 pm

#1192407
RE: Are the posted questions getting worse?

Gianluca Sartori (7/12/2010)
I think yesterday it was Emperor Paulpatine's birthday.
Happy birthday, Paul!
Heh... does it mean more Vuvuzelas?
--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 13, 2010 at 4:45 pm

#1192404
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Awesome feedback. As a side bar... Heh... no appologies for wanting to for wanting to form an opinion on some things on my own (which I still have to...
--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 13, 2010 at 4:38 pm

#1192402
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Almost forgot... thanks for the warning on Rule 6, Tom. I haven't seen anyone address the "problem" you're talking about but I suspect that the word "View" in 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 13, 2010 at 12:34 am

#1191801
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Thanks, Tom. Yep... this is one of the many versions of seen. Obviously I was hoping for the real thing but if someone like you, Barry Young, or...
--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 13, 2010 at 12:32 am

#1191800
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/11/2010)
Steve Jones - Editor (7/11/2010)
I added my thoughts to the thread. I think the guy/gal was humble enough, admitting he was in over his head there. I am hoping,...
--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 12, 2010 at 2:03 am

#1191342

Viewing 15 posts - 37,726 through 37,740 (of 59,098 total)