Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,036 through 46,050 (of 59,101 total)

RE: Grouping rows together

In that case... see this... especially the last part where the performance tests were done...
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

January 9, 2009 at 1:55 pm

#924571
RE: SQL Server 2000 problem

EdVassie (1/7/2009)
I had this on a SQL 2000 box some years back. The ultimate fix for my problem was to add a -g startup parameter to leave more memory...
--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)

January 9, 2009 at 1:48 pm

#924564
RE: Datediff not calculating corectly

I was just getting ready to comment on how much Lynn's complexion has improved. 😛 Barry still has to wear his helmet to hide his...
By the way... where'd...
--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)

January 9, 2009 at 1:31 pm

#924548
RE: The New Year - 2009

BWAA-HAA!!! I guarantee Business Intelligence won't take off because it's an oxymoron... government gives 700 billion to banks and can't account for any of it... big 3 are going...
--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)

January 9, 2009 at 1:28 pm

#924543
RE: Update table without cursors and Temp tables , in a single query

That's absolutely the way to do it... but, I'd be tempted to just drop the ID column and add it back in as an IDENTITY column. When you add...
--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)

January 9, 2009 at 12:43 pm

#924502
RE: Auto Creation and Insertion Of Table Through Executing Procedure

If I read you right, you want to use the output of a given stored procedure as input to another table. There are several ways to accomplish 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)

January 9, 2009 at 12:22 pm

#924487
RE: How to populate 1 row multi field from 3 rows single field

eddy (1/8/2009)
Ps: Jeff, i'm sorry for mispelling your name, did just notice that i managed to do it twice,, stupid me :hehe:
Heh... not really a problem, Eddy... just had 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)

January 9, 2009 at 11:32 am

#924449
RE: How to retrieve 2nd value of a user defined column in database

Of course, the best thing to do would be to normalize the table... even if it's just "temporary". Here's how to do that... then you can select from 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)

January 9, 2009 at 11:06 am

#924415
RE: Adding running number on groups of records in a table

Man... talk about "hijacking a thread"... sorry about that, folks. It was a much needed attitude repair.
--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)

January 9, 2009 at 10:12 am

#924365
RE: Adding running number on groups of records in a table

Lynn Pettis (1/9/2009)
Good to see you back in a good mood! You're no fun when your grumpy!:w00t:
Opportunities to hurl some well deserved pork overhand always bring the best out...
--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)

January 9, 2009 at 10:09 am

#924362
RE: Selecting from temp table outside SP?

Jack is correct.
Switching gears a bit... If blocking is present and you don't want to kill the job, you may have to get people to understand that you need 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)

January 9, 2009 at 9:59 am

#924352
RE: Dropping database did not free disk space

BWAA-HAAA!!! ...
... "It depends". 😛
--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)

January 9, 2009 at 9:53 am

#924345
RE: Adding running number on groups of records in a table

Garadin (1/9/2009)
Had to add to it, a small reward for not allowing myself to respond the other day when I first that post :hehe:.
Oh, very well done, Seth. Thanks...
--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)

January 9, 2009 at 8:25 am

#924232
RE: Adding running number on groups of records in a table

BWAA-HAAA!!! Everything that comes around, goes around. Talk about nearly instant gratification... Pork chops... AWAY!! 😛
http://www.sqlservercentral.com/Forums/Topic632886-149-1.aspx?#BM633444
I feel MUCH better, 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)

January 9, 2009 at 8:14 am

#924212
RE: highest unused ID

Now, now, Grant... that's outside of the requirements. 😉 You don't want to actually do anything more than the requirements state, especially for this OP, or you end...
--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)

January 9, 2009 at 8:10 am

#924207

Viewing 15 posts - 46,036 through 46,050 (of 59,101 total)