Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,016 through 9,030 (of 59,067 total)

Reply To: Separate Money Value By "/" Character

jcelko212 32090 wrote:
No. SQL is based on a tiered architecture, like all modern programming. We do not format data for display in the database tier. Essentially you're trying to write some...
--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)

July 17, 2019 at 1:23 pm

#3663753
Reply To: SQL data file split on 2 LUN move to 4 LUN

TRACEY-320982 wrote:
Our vendor recommends 4 LUN with 4 data files.
To what end? WHY does the vendor recommend that?
In almost every case that I've seen, people are splitting databases up...
--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)

July 17, 2019 at 12:19 pm

#3663714
Reply To: How to do Count of values on mutiple columns

jcelko212 32090 wrote:
Next, identifiers cannot be numeric because you don't do any math on them.
This continues to be the most horribly stupid thing you've ever said, Joe.
--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)

July 16, 2019 at 9:29 pm

#3663603
Reply To: Get the Datetime

GeorgeCopeland wrote:
I have a suggestion for you Jeff. Your company may bill by the quarter hour, but that doesn't mean that you have to enter your time that way. Tell...
--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)

July 16, 2019 at 3:13 pm

#3663477
Reply To: Get the Datetime

I DO agree that we have our own personal experiences to contend with. Ironically, I find that people that don't know how to use date math make some pretty complicated...
--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)

July 16, 2019 at 2:11 am

#3663278
Reply To: Get the Datetime

Thanks for the feedback, George. And, yes, I understand that you already handled my objections and, no, I'm not trying to change your convictions. A lot of people could 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)

July 16, 2019 at 12:13 am

#3663254
Reply To: Calculating Total # Days Per Year with Start Date to Today

Jeffrey Williams wrote:
Not so sure it is as bad as you stated, here is what it shows on my system.
The key here is that you have to make it system agnostic. ...
--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)

July 15, 2019 at 11:51 pm

#3663250
Reply To: Calculating Total # Days Per Year with Start Date to Today

Eddie Wuerch wrote:
This is a great excuse to write a recursive query 🙂
Heh... no it's not. ( https://www.sqlservercentral.com/articles/hidden-rbar-counting-with-recursive-ctes )
--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)

July 15, 2019 at 9:49 pm

#3663233
Reply To: Get the Datetime

GeorgeCopeland wrote:
I disagree Jeff, date math is a bad idea for any reason. When I have anything to say about it, it is not allowed. Maybe you know what 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)

July 15, 2019 at 9:30 pm

#3663224
Reply To: Get the Datetime

GeorgeCopeland wrote:
Even though you can do math on datetimes, don't do that. A datetime is not numeric, it is a data structure. Use the proper function for the type.
Actually, 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)

July 15, 2019 at 7:16 pm

#3663184
Reply To: The CUME_DIST ranking

Heh... I wonder how many people won't even try to answer because the test data is done using a cCTE to build a Tally Table and they don't know how...
--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)

July 14, 2019 at 2:44 am

#3662730
Reply To: T-SQL sorting

TomThomson wrote:
Well, I have two problems with this QOTD. Or perhaps I see two faults in the new "improved" website. 1: The select statement isn't there - it's a meaningless...
--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)

July 14, 2019 at 2:24 am

#3662729
Reply To: Do You Have the Gifts to Be a DBA?

skeleton567 wrote:
Jeff, thank you for sharing your experience and memories with us. I believe you and I have lots in common. I think one gift you and I share is...
--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)

July 14, 2019 at 2:04 am

#3662728
Reply To: Do You Have the Gifts to Be a DBA?

TomThomson wrote:
I don't have gifts to be a DBA - DBA requires more patience than I usually have.
Ummm.... "patience". Hang on... let me look that up.
{insert 5 minute timer...
--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)

July 14, 2019 at 1:30 am

#3662722
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

Jonathan AC Roberts wrote:
Alan Burstein wrote:
Does anyone know why you shouldn't use CROSS APPLY for everything? Or does it sometimes come up with bad plans? CROSS APPLY and OUTER APPLY seem to 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)

July 14, 2019 at 1:09 am

#3662716

Viewing 15 posts - 9,016 through 9,030 (of 59,067 total)