Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,471 through 40,485 (of 59,098 total)

RE: Today's Random Word!

Book
--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)

December 28, 2009 at 8:42 am

#1096703
RE: Help with a datediff calc

Paul Morris-1011726 (12/28/2009)
and for Jeff:
Is the above what you were referring to as "readily consumable"?
I am going to need some help as I move along in learning 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)

December 28, 2009 at 8:40 am

#1096702
RE: to show row wise data into column wise

syed_ahmedzama (8/17/2009)
hello,
my requirment is that i have 5 rows of data but i want to show it as clomun
ex:i have like this
rows ...
--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)

December 28, 2009 at 6:28 am

#1096650
RE: Display the record in column wise

rameshduraikannu,
That's what we like to hear. Thanks for the feedback and glad to have been able to help.
--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)

December 27, 2009 at 10:24 pm

#1096606
RE: Service Pack 4

Thanks for the feedback George and Steve. Didn't know that about CU's. Guess I just got lucky by being lazy... if it's not a service pack or 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)

December 27, 2009 at 10:20 pm

#1096605
RE: Query immediately pegs out 24 cores to 100% can someone explain to me why?

As a bit of a side bar, what collation does the column have on 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)

December 27, 2009 at 3:56 am

#1096553
RE: Query immediately pegs out 24 cores to 100% can someone explain to me why?

I believe that my next step would be a serious conversation with the 3rd party vendor... first, for having a design that requires such a query and, second, for apparently...
--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)

December 27, 2009 at 3:50 am

#1096552
RE: Difference between active-active and active-passive clusters?

This information is in Books Online and is explained there probably much better than there than could be explained on a forum post especially since none of these subjects are...
--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)

December 27, 2009 at 3:14 am

#1096550
RE: Service Pack 4

I guess I don't understand the supposed dilema here... if Cumulative Updates really are cumulative and include all fixes since the last service pack, isn't that just as good as...
--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)

December 27, 2009 at 3:11 am

#1096549
RE: Interview Question

I have to give you 2 points for honesty in saying that it's an interview question in the title of this post. However, there are two traits that people look...
--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)

December 27, 2009 at 3:06 am

#1096547
RE: Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Or, in the words of a very well respected denizen of these forums... "There must be 15 ways to lose your cursor". 😛
--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)

December 26, 2009 at 2:15 pm

#1096538
RE: Counter Table (table of numbers) Setter-Upper for SQL Server 2005

I guess I just don't understand why you needed While Loops to do this.
--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)

December 26, 2009 at 11:29 am

#1096533
RE: Running total , missing date , NULL in amount, exception handling

karthikeyan-444867 (12/26/2009)
Any inputs?
Not a one, Karthik... at least not the kind you're expecting. You've simply asked people to do too much of your work, your requirements are quite unclear...
--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)

December 26, 2009 at 9:40 am

#1096531
RE: Convert String to a Table using CTE

Yeah... but confirmation of those things is always a good thing. 😛
--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)

December 26, 2009 at 1:09 am

#1096512
RE: March 13, 2010: PSSUG SQL Camp, pre-Call For Speakers

Matt Miller (#4) (12/25/2009)
Jeff - try this one....
PSSUG call for speakers for march 2010
Thanks, Matt... guess I was being a bit lazy 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)

December 25, 2009 at 9:22 pm

#1096507

Viewing 15 posts - 40,471 through 40,485 (of 59,098 total)