Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,441 through 40,455 (of 59,072 total)

RE: Are the posted questions getting worse?

Roy Ernest (12/28/2009)
Its fun once in a while to go around to shoot everything that moves...
Heh... reminds me of one of my favorite bumber stickers....
"I miss my first wife.... but...
--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 3:49 pm

#1096859
RE: Are the posted questions getting worse?

I loved the old "brainless shoot something" games.... anyone remember the old Atari "River Raid" game or, a bit more recently, "Comanche"?
--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 11:44 am

#1096781
RE: Need query

cthariharan (12/28/2009)
Thank you Jeff. I've added it. Let me know any improvements required.
Very cool and welcome aboard!
--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 11:36 am

#1096778
RE: Need query

freeman.e.l (12/28/2009)
Jeff, I have to disagree please see the example below:
Your reebar example does not include the filter nid = nid. Also note, on smaller queries the optimizer will pull...
--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 11:09 am

#1096772
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

Viewing 15 posts - 40,441 through 40,455 (of 59,072 total)