Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,696 through 37,710 (of 59,072 total)

RE: The Utilty

Steve Jones - Editor (7/12/2010)
jcrawf02 (7/12/2010)
mbricker-600840 (7/12/2010)
I agree whole-heartedly with Jeff. IT is there to serve. Too many people forget that.
Oh, and another thing, I certainly hope I provide service...
--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 7:21 pm

#1192475
RE: return calculated null as 0

LutzM (7/11/2010)
Ooops! My fault (never had / been forced to use it, fortunately)...
So, the correct answer would then be: use a c.u.r.s.o.r.? ;-):-D;-)
Absolutely NOT! 😉 Good setbased code is...
--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 7:12 pm

#1192472
RE: Performance on Views that span databases on multiple servers

TheSQLGuru (7/13/2010)
Grant Fritchey (7/12/2010)
If you're working with linked servers and running queries against them, you need to know that unless you specifically use a construct like OPENQUERY and pass in...
--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 7:07 pm

#1192470
RE: Function in Joining column degrades performance in 2008

aravind-305595 (7/13/2010)
Yes both are 2008 servers
Ok... then you might want to try the "computed column" thing that I suggested and that Howard materialized with code. You can (most likely,...
--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:30 pm

#1192456
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

Viewing 15 posts - 37,696 through 37,710 (of 59,072 total)