Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,991 through 37,005 (of 59,098 total)

RE: Learning Oracle

What version is the government contract using, Lynn?
--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)

September 4, 2010 at 8:05 pm

#1216604
RE: Please don’t Tweet this, but…

[font="Arial Black"]From the article: [/font]
So what should we do now that we live in the new world of social media?
My answer would be... act like adults. 😉
--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)

September 4, 2010 at 7:27 pm

#1216603
RE: Learning Oracle

Lynn Pettis (8/31/2010)
Guess what, Oracle actually has CTE's, they just don't call it that in the reference manual.
True enough. And search for WITH won't do it either. They...
--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)

September 4, 2010 at 6:44 pm

#1216598
RE: Sending scheduled SQL query results via HTML e-mail using SSIS

First, yeah... I know this is a repost of an older article. The author did a nice job on the article. I've got no complaints there. Well...
--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)

September 4, 2010 at 6:29 pm

#1216596
RE: sql

Brian O'Leary (9/4/2010)
I thought I should update due to an error posted.
The assertion that the datetime data type rounds up by 3.33 ms is incorrect. After some research 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)

September 4, 2010 at 5:39 pm

#1216591
RE: Recursive select using UDF against a table?

... and let me know if that's what you wanted. I couldn't do much more because of the missing data in your tables.
--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)

September 4, 2010 at 5:32 pm

#1216590
RE: Recursive select using UDF against a table?

Ok... they pretty much screwed you by using the "Hierarchical Path" method of building hierarchies. There's a much more effecient method called "Nested Set Hierarchies" and if you 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)

September 4, 2010 at 5:30 pm

#1216589
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/4/2010)
OK, I'm off to hit the chores, cut grass ... normal horse stuff.
Now wait just a bloody minute... I though that's what the horses were for!...
--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)

September 4, 2010 at 4:36 pm

#1216580
RE: database mail without cursors?

Ah... almost forgot...
There is no way that I would execute sp_send_dbmail in a trigger. If the email service goes down, new entries to the tables will either fail or...
--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)

September 4, 2010 at 4:25 pm

#1216577
RE: database mail without cursors?

Sorry this took so long... I got pretty far behind and I thought I was going to have to be twins to catch up. I hope you'll think 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)

September 4, 2010 at 4:18 pm

#1216576
RE: The Great Debate!

steve.robson 58295 (8/29/2010)
#3 is about striking the right balance of all the facets involved - not just focusing on performance for the sake of it; good enough is good enough....
--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)

September 4, 2010 at 11:43 am

#1216553
RE: Dates from Calendar control

simon phoenix-479217 (8/31/2010)
Hi
Jeff,
I came to forums after a long time and good to see you again.
Hi Simon. My apologies... I wish I could remember who you are, but I...
--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)

September 4, 2010 at 11:06 am

#1216549
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Actually, thank all you good folks. We've helped a lot of folks together over time.
--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)

September 4, 2010 at 11:01 am

#1216547
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/4/2010)
Jeff - you're single-handedly keeping us at our 24 post/day goal 😉
I'm afraid you'll have to average that over the weekend. 🙂
--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)

September 4, 2010 at 10:39 am

#1216540
RE: Are the posted questions getting worse?

Gianluca Sartori (9/3/2010)
...pocket pork-chop launcher
Aw DUDE! You found one? 😛
--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)

September 3, 2010 at 10:59 pm

#1216504

Viewing 15 posts - 36,991 through 37,005 (of 59,098 total)