Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,386 through 44,400 (of 59,097 total)

RE: You have 1,000,000 records in your customers table....

I would imagine that everyone would get this question right, but... this is why I hate Microsoft and other tests... totally unreal scenario's. Who on this good green Earth...
--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)

April 3, 2009 at 12:56 pm

#971793
RE: T-Sql rant

Jeff Moden (4/3/2009)
foxjazz (4/3/2009)
Jeff Moden (4/3/2009)
foxjazz (4/3/2009)
But who am I to say anything about the limitations of t-sql?
When it comes to data manipulation, I've not found any limitations yet.
Jeff, ummm...
--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)

April 3, 2009 at 12:02 pm

#971752
RE: T-Sql rant

foxjazz (4/3/2009)
Jeff Moden (4/3/2009)
foxjazz (4/3/2009)
But who am I to say anything about the limitations of t-sql?
When it comes to data manipulation, I've not found any limitations yet.
Jeff, ummm what do...
--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)

April 3, 2009 at 11:51 am

#971746
RE: T-Sql rant

foxjazz (4/3/2009)
But who am I to say anything about the limitations of t-sql?
When it comes to data manipulation, I've not found any limitations yet.
--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)

April 3, 2009 at 11:37 am

#971736
RE: Fix date format in a query.. Split/Array?

Maybe... but you don't ever want to send dates to the GUI as VARCHARS if you don't need to. Send it as a date/time so the local settings can...
--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)

April 3, 2009 at 9:35 am

#971688
RE: T-Sql rant

Spot on, DC.
--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)

April 3, 2009 at 9:32 am

#971679
RE: Fix date format in a query.. Split/Array?

shane (4/2/2009)
Hi,
So I have this table and one of the fields has a Date in it… but its not in needed format, it is YYYY-DD-MM and I need MM-DD-YYYY.
Is 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)

April 2, 2009 at 11:25 pm

#971313
RE: ADDING COLUMNS VALUES!

Vijaya Kadiyala (4/2/2009)
Hi
All the summing operations based on the amount should be part of Front-End.
One Big Reasons behind this:
1) If you have Pagination in UI you would want to display...
--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)

April 2, 2009 at 11:23 pm

#971312
RE: Are the posted questions getting worse?

john.arnott (4/2/2009)
GSquared (4/2/2009)
This is the kind that gives me hope:
http://www.sqlservercentral.com/Forums/Topic688912-149-1.aspx
This is the kind that drives me to The Thread:
http://www.sqlservercentral.com/Forums/Topic688302-338-1.aspx
I keep going on the second type because of the first type.
My...
--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)

April 2, 2009 at 10:55 pm

#971304
RE: Are the posted questions getting worse?

Greg Edwards (4/2/2009)
I'm waiting for Bob to ask him what 1 + 1 is.
It's not always 2.
Reminds me of a saying that's actually a bit of a riddle...
[font="Arial Black"]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)

April 2, 2009 at 10:40 pm

#971302
RE: Are the posted questions getting worse?

Bob Hovious (4/2/2009)
Kit, in my house we had a "Board of Education" which was applied to "The Seat of Learning."
My brothers and I were well-behaved.
Jeff, I have...
--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)

April 2, 2009 at 10:29 pm

#971300
RE: Are the posted questions getting worse?

Bob Hovious (4/2/2009)
So three guys check into a fancy hotel together wanting to share a single room. The night clerk tells them the room is $300 for 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)

April 2, 2009 at 10:18 pm

#971295
RE: Are the posted questions getting worse?

I'm sticking to my rule... if, especially after repeated attempts, the poster to continues to post forever changing data examples and still refuses to even try to post the data...
--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)

April 2, 2009 at 4:55 pm

#971194
RE: Do DBAs Still Read Techincal Books?

maurine (4/2/2009)
Based solely upon this post - I'm ready to preorder the book. When can we sign up?
Heh... you just made a bad day great. Thanks for 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)

April 2, 2009 at 3:46 pm

#971154
RE: Are the posted questions getting worse?

Lynn Pettis (3/30/2009)
Jeff, changing the subject again, how is the rewrite of your Running Balance article coming? Had an OP today that could have benefitted from being able 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)

March 31, 2009 at 11:22 pm

#969620

Viewing 15 posts - 44,386 through 44,400 (of 59,097 total)