Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,516 through 40,530 (of 59,072 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (12/22/2009)
Jeff Moden (12/22/2009)
CirquedeSQLeil (12/22/2009)
...And chastising QODs:blush:
Heh... nah... "tweeking" is the word that I would chose on the one you're thinking of. 😀 I bashed one that Steve...
--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 22, 2009 at 7:17 pm

#1095773
RE: Are the posted questions getting worse?

Gail... awesome picture. Thanks for the bit of holiday cheer.
--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 22, 2009 at 2:25 pm

#1095707
RE: Are the posted questions getting worse?

CirquedeSQLeil (12/22/2009)
...And chastising QODs:blush:
Heh... nah... "tweeking" is the word that I would chose on the one you're thinking of. 😀 I bashed one that Steve posted pretty darned...
--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 22, 2009 at 2:24 pm

#1095705
RE: SQL Mail

I see the necessary high velocity pork has already been flung on this one... moving 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)

December 22, 2009 at 2:19 pm

#1095700
RE: Are the posted questions getting worse?

CirquedeSQLeil (12/22/2009)
Bru Medishetty (12/22/2009)
CirquedeSQLeil (12/22/2009)
Bru Medishetty (12/22/2009)
Our good old friend has another doubt anyone care to answer ?
http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx
Recollect some of his / her famous threads.
Lock Pages in Memory
How to see...
--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 22, 2009 at 2:17 pm

#1095698
RE: Are the posted questions getting worse?

Lynn Pettis (12/22/2009)
Oh well, some of us like the hopeless cases. Now, where did I leave that halo? 😛
Heh... me too... now where did I leave that pork...
--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 22, 2009 at 2:15 pm

#1095695
RE: Are the posted questions getting worse?

GSquared (12/22/2009)
Lynn Pettis (12/22/2009)
I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing that trend?
(Okay,...
--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 22, 2009 at 2:11 pm

#1095689
RE: Data reformatting question

Murphy,
The solutions posted by Gus and Chris both use an ancillary "helper" table known as a "Tally" or "Numbers" table. Despite the different names, they are identical in nature....
--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 22, 2009 at 1:56 pm

#1095678
RE: Data reformatting question

And nice job to you both.
--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 22, 2009 at 12:49 pm

#1095613
RE: Data reformatting question

If you quote the original post, I believe you'll find that there are tabs in the data... not spaces.
--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 22, 2009 at 12:47 pm

#1095611
RE: Inserting data into very first and very last row

Sql_query (12/22/2009)
Is it possible to insert data into a table so that it will be the very first row or the very last row of the table?
According to what?...
--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 22, 2009 at 9:59 am

#1095502
RE: How to ignore columns when using union all

Just add a Carriage Return/Line Feed at the end of column 10.
--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 22, 2009 at 9:51 am

#1095493
RE: Data reformatting question

mmdmurphy (12/22/2009)
How can I convert the following sample rows (from a table called Staging that gets reloaded every night. Yes, the double ampersand is the delimiter..). Please rule out changing...
--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 22, 2009 at 9:43 am

#1095480
RE: Question of the Day for 21 Dec 2009

vk-kirov (12/22/2009)
Msg 208, Level 16, State 1, Line 13
Invalid object name 'dbo.Tally'. 😉
I guess there are natural numbers in this table. This would work:
Heh... spend some more time on 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 22, 2009 at 8:07 am

#1095419
RE: functions

Thanks for the great compliment but you might also want to take a look at what Sergiy has written in posts like this. He doesn't necessarily solve the problem...
--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 22, 2009 at 7:57 am

#1095409

Viewing 15 posts - 40,516 through 40,530 (of 59,072 total)