Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,461 through 20,475 (of 59,098 total)

RE: Should Salary Information Be Confidential?

Andy Warren (6/8/2015)
Government work is definitely a different thing. Like any job, it has good and bad. Disclosure of salary would not be for me a factor in deciding.
Jeff, you...
--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 8, 2015 at 9:07 am

#1803723
RE: Should Salary Information Be Confidential?

robert.sterbal 56890 (6/8/2015)
Does that mean you wouldn't take a government job either?
I've been in the military, I've worked for a DOD company, and I've had regular dealings with the military...
--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 8, 2015 at 8:33 am

#1803704
RE: Should Salary Information Be Confidential?

Eric M Russell (6/8/2015)
Jeff Moden (6/8/2015)
Andy Warren (6/8/2015)
Jeff, would you decline an offer from a company that publishes all salaries?
Yes.
Even if the company were financially stable, the IT projects interesting,...
--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 8, 2015 at 8:25 am

#1803700
RE: Should Salary Information Be Confidential?

Andy Warren (6/8/2015)
Jeff, would you decline an offer from a company that publishes all salaries?
Yes. I haven't had to though because I research the companies that I apply to 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)

June 8, 2015 at 8:07 am

#1803692
RE: The Multi-skilled Developer

Vanessa.Grimes (6/8/2015)
@Grasshopper "Developers are knowledgeable about narrow topics. They think in tiny bits and move from bit to bit in the process of creating software." That's a bit condescending...
--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 8, 2015 at 7:57 am

#1803688
RE: Should Salary Information Be Confidential?

Sean Redmond (6/8/2015)
If salaries are to be revealed for one, they are to be revealed for all.
I appreciate the sentiment but someone might use such sentiments for justification 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)

June 8, 2015 at 7:34 am

#1803678
RE: The Multi-skilled Developer

The best communication methods and systems in the world are totally useless unless a company adopts a development and maintenance policy that few companies seem to implement and can be...
--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 7, 2015 at 10:06 am

#1803543
RE: The Multi-skilled Developer

TomThomson (6/6/2015)
Jeff Moden (6/5/2015)
You don't have to win to plant a seed. Even a cement parking lot, like your Dev Guy, has a crack in it. 😉
Great article,...
--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 6, 2015 at 7:49 pm

#1803533
RE: Clearing Temp tables

patelxx (6/6/2015)
I am just learning about temp temps using Iteration, how do I clear the contents of the #temp table because when I re-run the query I get the following...
--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 6, 2015 at 6:22 am

#1803510
RE: UNPIVOT behaves differently in 2005 and 2010/2012

autoexcrement (6/5/2015)
I am in the process of migrating some gnarly old SSIS packages from SQL Server 2005 to SQL Server 2012. The only piece that is behaving discrepantly is an...
--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 5, 2015 at 11:31 pm

#1803506
RE: DB size

You also need some headroom for certain maintenance such as REBUILDing indexes. Any index over 128 extents (that's just 8 megabytes) that needs to be rebuilt will first be...
--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 5, 2015 at 11:21 pm

#1803504
RE: The Multi-skilled Developer

You don't have to win to plant a seed. Even a cement parking lot, like your Dev Guy, has a crack in it. 😉
Great article, though. I hope...
--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 5, 2015 at 11:16 pm

#1803503
RE: A Case FOR Cursors...

Charles Kincaid (6/5/2015)
I'm a bit late to the party but ...
Just because Microsoft does it it or does not do it is no excuse for me to do it 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)

June 5, 2015 at 9:27 pm

#1803501
RE: ETL question: which option is better for performance

dbodell (6/5/2015)
The primary and alternate keys really aren't a factor in this, unless I am not understanding the point. I mean, there are three ways to go: 1) update all...
--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 5, 2015 at 2:45 pm

#1803480
RE: Need Ammunition for Developers Doing Select *'s

EdVassie (6/5/2015)
You could try a little role-play.
Call your developers into a meeting, and have a box of paper left outside the room.
Tell a developer you need some paper and ask...
--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 5, 2015 at 12:36 pm

#1803443

Viewing 15 posts - 20,461 through 20,475 (of 59,098 total)