Jeff Moden

Forum Replies Created

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

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
RE: Adding running number on groups of records in a table

Heh... ah yes... THAT one. And because I'm a professional, I'm also supposed to be nice in the face of such abuse. I rewrote that one about 5...
--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:01 am

#924194
RE: Dropping database did not free disk space

Ninja's_RGR'us (1/9/2009)
They shouldn't, unless manually deleted.
How else would they be, Remi? 😉 And, what else can you think of that would cause these symptoms? :hehe:
--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 7:33 am

#924162
RE: Help needed to do performance tune in stored...

KSB (1/8/2009)
Hi All,
I am new to performance tuning. I wanted to do tune below stored procedure. Please help me that anything needs to be change.
My first question would be.... why...
--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 6:57 am

#924134
RE: Archive some records from db

Jack Corbett already suggested the correct solution. If the deletes are huge, then you need to write a loop to do the deletes in groups of 10 or 20,000...
--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 6:49 am

#924128
RE: Dropping database did not free disk space

Are you sure those files aren't simply sitting in the trash bin?
--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 6:08 am

#924076
RE: Selecting from temp table outside SP?

thj (1/8/2009)
Hi
I have a SP that has been running for 408 hours, computing Citrix statistics. The SP writes to a temporary table called #tmpResults, and I would like to know...
--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 6:03 am

#924072

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