Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,071 through 47,085 (of 59,101 total)

RE: The Joy of Numbers

Ok... the Billion row results are in. On the orignal code that Russ submitted (looks like modification of Itzek's code),
Insert Duration - 00:29:00
Convert column to 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)

November 23, 2008 at 6:29 am

#902171
RE: Are the posted questions getting worse?

Is that true, Gail? Is there a book out there with your good name in it as a co-author?
--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)

November 22, 2008 at 9:03 pm

#902133
RE: Are the posted questions getting worse?

Lynn Pettis (11/22/2008)
Jeff Moden (11/22/2008)
GAAAA!!!
http://www.sqlservercentral.com/Forums/Topic606992-65-1.aspx
Yep, the record's stuck, the record's stuck, the record's stuck, the record's stuck...
Heh... the kinder gentler me posted on that one, thought better of it, 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)

November 22, 2008 at 8:38 pm

#902130
RE: Any one can send me answers for these

Heh... sorry, Perry... bit of an inside joke. I'll explain it sometime, but not here.
--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)

November 22, 2008 at 6:30 pm

#902117
RE: Are the posted questions getting worse?

GAAAA!!!
http://www.sqlservercentral.com/Forums/Topic606992-65-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)

November 22, 2008 at 4:30 pm

#902100
RE: Function that finds Sundays

"KISS" it...
SELECT DATEADD(wk,DATEDIFF(wk,0,somedatetimevalue+7),0)-1
--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)

November 22, 2008 at 4:04 pm

#902096
RE: Query to find the row size in a user table

You don't need to write anything to get what you want. Just run the following and some of the things it returns are things like Min, Max, and Average...
--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)

November 22, 2008 at 3:44 pm

#902093
RE: Bulk Insert Grief

Jim Russell (11/21/2008)
I just converted my 558 column format file to ANSI, and imported it to a 558 column temp table
and it WORKED!
Can't thank you guys enough!!
They beat me...
--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)

November 22, 2008 at 3:15 pm

#902089
RE: Are the posted questions getting worse?

Matt Miller (11/22/2008)
Jack Corbett (11/22/2008)
Matt Miller (11/22/2008)
And Jack has got the jack of of trades thing going on, covering most ares in a single bound.
Thanks, but don't forget the 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)

November 22, 2008 at 11:55 am

#902072
RE: Are the posted questions getting worse?

Ok... Going way back to the original post on this thread, lemme ask what you folks think... read the original post on the following thread... don't read the other posts,...
--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)

November 22, 2008 at 10:55 am

#902057
RE: Are the posted questions getting worse?

Wow... it's a huge understatement to say that a good number of the "greats" have joined in on this thread... I've learned a huge amount from all of 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)

November 22, 2008 at 10:31 am

#902050
RE: Are the posted questions getting worse?

Grant Fritchey (11/22/2008)
Terribly late to the party, rude of me, I know.
Did ya bring anything to eat? I'm getting ready to vent... best way I know of to clear...
--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)

November 22, 2008 at 10:08 am

#902045
RE: Are the posted questions getting worse?

GilaMonster (11/21/2008)
Jeff Moden (11/21/2008)
Another favorite are those that ask things like "which would be faster" and they post the code for both... talk about "lazy". :hehe:
Yeah, but at least those...
--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)

November 22, 2008 at 10:02 am

#902042
RE: Are the posted questions getting worse?

Man o' man, I sure am sorry I missed PASS... sounds like everyone I wanted to meet was there.
--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)

November 22, 2008 at 9:59 am

#902039
RE: Any one can send me answers for these

GilaMonster (11/22/2008)
A senior DBA who doesn't know how to do performance monitoring or how to kill a connection? I could accept that of a junior with only a couple years...
--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)

November 22, 2008 at 9:47 am

#902036

Viewing 15 posts - 47,071 through 47,085 (of 59,101 total)