Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,476 through 20,490 (of 59,098 total)

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
RE: Test connection failed because of an error in initializing provider

I don't even know how to spell "SSIS" but let me bump this for you. Everyone keeps telling me how easy SSIS is so this should be an easy...
--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:07 pm

#1803207
RE: The right way to query an extended events session?

The more I see about XE, the less I like 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)

June 4, 2015 at 6:02 pm

#1803206
RE: Trying to get running Total in SQL Server

j-1064772 (6/3/2015)
No need to respin the same wheel over and over again.
]
BWAAA-HAAAAA!!!!! If that were true, there would be no use for forums at all because everything that 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 4, 2015 at 6:01 pm

#1803205
RE: Help with date table

Shifting gears a bit... constantly recalculating that which will not change seems very expensive to me (in this case). Why not make another smaller table with the start 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 4, 2015 at 5:53 pm

#1803204

Viewing 15 posts - 20,476 through 20,490 (of 59,098 total)