Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,966 through 49,980 (of 59,099 total)

RE: Eliminating Cursors

Sergiy (6/17/2008)
Matt Miller (6/17/2008)
Corollary to rule #1: Try not to be that operator....:D
Quality of some programs makes you wish to be the one.
Kinda funny you should say that... I'm going...
--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)

June 17, 2008 at 6:58 pm

#830130
RE: From Developer to DBA - Wise career move?

I made my own career path and I wear many hats including DBA, Developer, ETL monster, performance monger, developer mentor, reality checker, etc, etc. If your new job will...
--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)

June 17, 2008 at 6:34 pm

#830129
RE: Limitation fo AND's and OR's

p.s. When you do find out, be sure to post the answer... inputs are welcome 😉
--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)

June 17, 2008 at 6:14 pm

#830126
RE: Limitation fo AND's and OR's

karthikeyan (6/16/2008)
Hi All,
what is the limitation of AND's and OR's in Sqlserver,sybase,mysql and oracle ?
How to know the maximum level ?
Is there any option to change the level to user...
--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)

June 17, 2008 at 6:13 pm

#830125
RE: Query Performance Difference with Temp Table Scope

How strange... I did it with a million rows...
Scenario 1 = 36 seconds.
Scenario 2 = 8 seconds.
Here's the million rows of data...
--===== Create and populate a 1,000,000 row test...
--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)

June 17, 2008 at 6:01 pm

#830122
RE: Question regarding an interview method- need feedback

It is NOT an Oracle question... it is a general question concerning backups. A hot backup occurs on something that is currently being used by users. A cold...
--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)

June 17, 2008 at 1:10 pm

#829994
RE: Tips for practicing SQL at home

DaveR (6/17/2008)
Thank you, this is perfect! I really just want to keep up with querying and general statements, so this should be great.
Speaking from personal experience... if you really...
--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)

June 17, 2008 at 12:11 pm

#829973
RE: SQLServer 2005 on VMWARE

Heh... yeaup... I like to plan for it, too... but the users never let it happen. They always want everything available even 10 years back... they never summarize... 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)

June 17, 2008 at 9:00 am

#829856
RE: SQLServer 2005 on VMWARE

What? No growth expected on those 5 servers?
--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)

June 17, 2008 at 8:46 am

#829845
RE: Using VBA to pull SQL data into Excel?

Also allows it to possibly be slower because it will recompile every time it's used.
--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)

June 17, 2008 at 8:45 am

#829843
RE: Presentation tips

Ditto... congrats, Karthik!
--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)

June 17, 2008 at 8:26 am

#829816
RE: Error converting data type varchar to numeric.

rbarryyoung (6/17/2008)
I think that you have to at a minimum include '. + -' in that list.
And, a decimal point... but then you run into things like having two decimal...
--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)

June 17, 2008 at 8:23 am

#829814
RE: Need help on preparing PPT

I've found that if your audience doesn't really know what you're talking about, then you have to tell them what you're going to say, say it, then tell them 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)

June 17, 2008 at 8:21 am

#829810
RE: Question regarding an interview method- need feedback

rudy komacsar (6/17/2008)
Good points Jeff. However I would add the caveat that pre-screening testing is always acceptable via services such as BrainBench and ProveIt. As you say it is 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)

June 17, 2008 at 8:12 am

#829799
RE: Date Column Extraction from a flat file.

NULLIF(yourcolumn,'00/00/00')
--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)

June 17, 2008 at 7:22 am

#829766

Viewing 15 posts - 49,966 through 49,980 (of 59,099 total)