Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,526 through 3,540 (of 59,086 total)

Reply To: Drawbacks of having hundreds of data files per database

Jeffrey Williams wrote:
Jeff Moden wrote:
Jeffrey Williams wrote:
ScottPletcher wrote:
Actually, the development team should have nothing to do with how the data in the db is physically stored. That's the DBA's job. (Sorry, just had...
--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)

May 12, 2022 at 10:06 pm

#4032076
Reply To: how to select lowest value of column and corresponding date column

profoundhypnotic wrote:
I am trying to get the lowest cost for a part and the highest cost for a part. along with the dates that they occurred. I almost have 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)

May 12, 2022 at 7:49 pm

#4032022
Reply To: DELETE

metapoesia wrote:
..
Lordy... It would have been RIEALLY nice if you left the original question here so that others no what the final recommendation was 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)

May 12, 2022 at 7:47 pm

#4032021
Reply To: Drawbacks of having hundreds of data files per database

ScottPletcher wrote:
Jeff Moden wrote:
Jeffrey Williams wrote:
ScottPletcher wrote:
Actually, the development team should have nothing to do with how the data in the db is physically stored. That's the DBA's job. (Sorry, just had...
--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)

May 12, 2022 at 7:45 pm

#4032020
Reply To: Cummulative Updates in SQL 2017 & Free space calculataions

Michael L John wrote:
No. The CU will update all of the features you have installed. You can un-select features to update in the install of the CU, but you probably would not...
--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)

May 12, 2022 at 5:50 pm

#4031978
Reply To: How to validate user if input formate no yyyy-MM-dd for created date ?
kaj wrote:
I fully agree with the comments made by others, but if the OP would like to try anyway, this will work with the test data provided:
```
...
```
--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)
May 12, 2022 at 3:47 pm

#4031883
Reply To: How to validate user if input formate no yyyy-MM-dd for created date ?

Jeffrey Williams wrote:
Even if you have a prior agreement - and the provider is sending the data in YYYY-MM-DD format you could still have problems depending on the data type 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)

May 12, 2022 at 3:39 pm

#4031880
Reply To: Drawbacks of having hundreds of data files per database

Jeffrey Williams wrote:
ScottPletcher wrote:
Actually, the development team should have nothing to do with how the data in the db is physically stored. That's the DBA's job. (Sorry, just had to say...
--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)

May 12, 2022 at 3:36 pm

#4031879
Reply To: Pivot - Unpivot

Just a suggestion to a newbie that took the time to nicely format their question... if you were to post your question with some readily consumable data, you'd already have...
--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)

May 11, 2022 at 2:29 pm

#4031161
Reply To: Flattening of hierarchy

Thanks for the feedback, Dan.
--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)

May 11, 2022 at 5:13 am

#4030474
Reply To: Adding leading zeroes after the decimal

In a less subtle manner than Phil already explained, I'll tell you that it's flat-out not possible to have those values in a single numeric column. The ONLY way 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)

May 11, 2022 at 5:00 am

#4030471
Reply To: Is SQL Express enough?

It's free. Try it. If it doesn't work out, upgrade to the Standard Edition.
And do heed Steve's warning about not being able to create jobs or schedule them. As he...
--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)

May 11, 2022 at 4:36 am

#4030464
Reply To: How to validate user if input formate no yyyy-MM-dd for created date ?

You cannot prove that a date like 2022-05-09 is actually in the YYYY-MM-DD format. For example, in SQL Server in the English Language, that will be YYYY-MM-DD but, if 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)

May 11, 2022 at 4:32 am

#4030461
Reply To: JSON String invalid

I guess they don't understand the concept of "DevOps". 😀
Can't you snuggle up to them and tell them, "Yes, you're correct but I really need your help with a tweak...
--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)

May 11, 2022 at 4:20 am

#4030455
Reply To: Drawbacks of having hundreds of data files per database

TheMaskedDBA wrote:
Thanks Jeff. Appreciate the detailed insights regarding performance implications. The product team has so far not engaged with regards to a design discussion, but trying nonetheless. I agree that...
--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)

May 11, 2022 at 4:13 am

#4030454

Viewing 15 posts - 3,526 through 3,540 (of 59,086 total)