Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,446 through 20,460 (of 59,072 total)

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
RE: A Case FOR Cursors...

Brian J. Parker (6/5/2015)
This is completely branching off the topic of the original article, but... I've grown accustomed to instantiating a Tally table whenever possible in any database I work...
--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:19 pm

#1803439
RE: Should Salary Information Be Confidential?

robert.sterbal 56890 (6/5/2015)
Most government jobs have published salaries.
This is for Illinois teachers:
http://www.familytaxpayers.org/ftf/ftf_salaries.php
I found a spreadsheet for the city of Pittsburgh at:
https://docs.google.com/spreadsheets/d/1AgIDIpQ4B-u0C2RrnYFEgdnpJKlWH0qyBGkhRTiOK9A/edit?pli=1#gid=0
Wow... no wonder some cities and school districts go broke....
--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 8:58 am

#1803332
RE: Should Salary Information Be Confidential?

Andy Warren (6/5/2015)
Jeff, I'll take you up on that. This year, about a 100k. Two years ago, 250k. It varies based on how much I want to work, how much...
--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 8:43 am

#1803324
RE: Should Salary Information Be Confidential?

Andy Warren (6/5/2015)
Jeff, if you make me more that he does, that's his problem isn't it? It's entirely possible you do on a salary basis, but for most managers 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)

June 5, 2015 at 8:26 am

#1803317
RE: New T-SQL Functions: How to modify an ORDER BY clause at run-time using a parameter

Alan.B (6/4/2015)
Dynamic SQL as Luis showed is the way to go here. I don't know if this helps; I used my own sample data. Just another way to go about...
--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 7:56 am

#1803303
RE: Usages for Powershell

schleep (6/5/2015)
Only a problem insofar as you have to actually know that the info is in HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\BackupDirectory, as opposed to simply asking for the server object for it's default backup...
--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 7:53 am

#1803301
RE: Usages for Powershell

schleep (6/5/2015)
I also use a PoSh script to do restores from prod to dev. Getting the default backup folder in TSQL requires xp_regread.
In Posh, get an instance of 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 5, 2015 at 7:44 am

#1803297
RE: Should Salary Information Be Confidential?

Andy Warren (6/5/2015)
Why is it bad if others know what you make? Aside from pride/legal constraints on the employer and all that, why is the idea of others knowing 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 5, 2015 at 7:21 am

#1803288
RE: Should Salary Information Be Confidential?

Heh... my salary is no one's business. Even my immediate supervisor has no clue what I make. If a company were to publish my salary, I could retire...
--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 4, 2015 at 9:03 pm

#1803221
RE: Help with date table

dwain.c (6/4/2015)
Jeff Moden (6/4/2015)
... constantly recalculating that which will not change seems very expensive...
That's going into my table of Jeff Moden quotes.
Oh, be careful. I truly meant "in 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)

June 4, 2015 at 6:56 pm

#1803214
RE: SQL Views Problem

TJT (5/29/2015)
Sorry, solved - small issue on my end
What was the problem and how did you fix it? It might help someone else having a similar problem. Thanks.
--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 4, 2015 at 6:08 pm

#1803209

Viewing 15 posts - 20,446 through 20,460 (of 59,072 total)