Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,776 through 44,790 (of 59,101 total)

RE: Tune Stored Proc

Mike... how long do just one of these take to run?
select count(*) as ControlTotals
from ' + @RevStateDB + '.dbo.Budget1995 where srcflag =...
--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)

March 6, 2009 at 8:16 pm

#955383
RE: Tune Stored Proc

Mike Levan (3/6/2009)
Can i do this through SSIS pkg or BULK Insert to spped up my load.??
Few questions on BULK INSERT
1. Does a user need to be bulkadmin to do...
--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)

March 6, 2009 at 8:04 pm

#955380
RE: Are the posted questions getting worse?

Jeff Moden (3/6/2009)
Bob Hovious (3/6/2009)
Fine then. Me and Roy will just pack up our CTEs and go home.
Got some cold ones? We can look up some old...
--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)

March 6, 2009 at 7:44 pm

#955377
RE: Are the posted questions getting worse?

Bob Hovious (3/6/2009)
Fine then. Me and Roy will just pack up our CTEs and go home.
Got some cold ones? We can look up some old ISO standards...
--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)

March 6, 2009 at 7:43 pm

#955375
RE: Lets help the experts help themselves

Bob Hovious (3/6/2009)
Does that mean all pork chops, katanas, longbows, and trebuchets would have to be checked at the door? Doesn't sound like much of a party...
--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)

March 6, 2009 at 7:39 pm

#955374
RE: Are the posted questions getting worse?

Bob Hovious (3/6/2009)
Nah.... I'd never get invited.
Seriously, what is to be gained by exclusivity? If you have a complex topic or problem you want to discuss, why not...
--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)

March 6, 2009 at 7:28 pm

#955371
RE: Are the posted questions getting worse?

Michael Valentine Jones (3/6/2009)
Instead of this being a club, I like to think of SSC as more like a bar. Come in, set down, have a cold one, 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)

March 6, 2009 at 7:22 pm

#955370
RE: Lets help the experts help themselves

t.walker (3/6/2009)
I think a more private invited members forum would enable me to speak more freely.
Heh... With all the ring knocking going on, I just knew THAT was coming.
--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)

March 6, 2009 at 6:34 pm

#955362
RE: "Answered" Posts

Steve Jones - Editor (3/6/2009)
I don't see how comments are rated in the New Scientist thing. I missing something?
I'm not sure of the benefit to users of ranking things. 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)

March 6, 2009 at 4:25 pm

#955335
RE: Are the posted questions getting worse?

GilaMonster (3/6/2009)
Grant Fritchey (3/6/2009)
Remember, don't feed the trolls.
Indeed. He thinks we hate him, let's not prove him right.
Heh... It's way, way too late for 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)

March 6, 2009 at 4:14 pm

#955329
RE: Are the posted questions getting worse?

Grant Fritchey (3/6/2009)
At this point, I'm calling this a troll.
http://www.sqlservercentral.com/Forums/FindPost670625.aspx
Remember, don't feed the trolls.
Heh... what? They don't like pork chops? 😉
I told him to stop trolling way back on...
--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)

March 6, 2009 at 4:10 pm

#955324
RE: How generate Dates on the fly

Lynn Pettis (3/6/2009)
Not the request I made. I know which I'd use. I want Mangal to justify to me why I should use his solution even though 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)

March 6, 2009 at 4:08 pm

#955321
RE: Calculating Work Days

bindu.muttavarapu (3/6/2009)
Hi,
Can any one help in calculating wordays starting from monday to friday
right now I am using (DATEDIFF(DAY, DATES.StartDate, DATES.EndDate)+1) to get monday to sat but
what to do 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)

March 6, 2009 at 3:24 pm

#955309
RE: How generate Dates on the fly

CTE (3/6/2009)
why so much of noise about it?
So people don't use the ones that cause performance problems.
--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)

March 6, 2009 at 3:16 pm

#955304
RE: Are the posted questions getting worse?

Bruce W Cassidy (3/5/2009)
[font="Verdana"]Potato Launchers? Have we graduated from Pork Chops?[/font]
Heh... you missed it... somewhere around 15 or 16 hundred posts back. Don't worry... the Pork Chop still...
--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)

March 5, 2009 at 10:56 pm

#954651

Viewing 15 posts - 44,776 through 44,790 (of 59,101 total)