Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,846 through 7,860 (of 59,098 total)

Reply To: Month-over-Month calculation using DAX in Power BI

pietlinden wrote:
Has my customer conversion rate improved since this time last quarter?
What is my annual sales growth as compared to last year?
The answers to the questions can be found by...
--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)

January 27, 2020 at 3:19 pm

#3720641
Reply To: Month-over-Month calculation using DAX in Power BI

Shifting gears to the subject matter... I don't see how anything led to answering the two questions posed at the beginning of the article, which were...
It can be used 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)

January 27, 2020 at 2:08 am

#3720491
Reply To: Month-over-Month calculation using DAX in Power BI

The problem with links on other sites is that other sites have been known to go away. Could you attach the .ZIP file to this site please?
--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)

January 27, 2020 at 1:50 am

#3720486
Reply To: Extract date from String
Lynn Pettis wrote:
Jeff Moden wrote:
SELECT LEFT(RIGHT(@Text,12),8);
Simple and to the point. I would put a comment with it to explain what is being so that someone with less SQL...
--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)
January 27, 2020 at 12:11 am

#3720479
Reply To: Extract date from String
```
 SELECT LEFT(RIGHT(@Text,12),8);
```
--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)
January 26, 2020 at 12:04 am

#3720408
Reply To: Error converting data type varchar to float

It still makes a difference even on something small when you're working with millions of rows.
--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)

January 25, 2020 at 9:58 pm

#3720405
Reply To: Recruitment question

You say the "standard job boards are not pulling the right people at all". What kind of people are you getting that are disappointing you?
I can tell you that filling...
--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)

January 25, 2020 at 6:44 pm

#3720396
Reply To: Master database is "cleanly shutdown"

I've never seen such a thing. I have to admit, though, I've never thought to look for such a thing simply because I'd never have thought such a thing was...
--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)

January 25, 2020 at 4:49 pm

#3720388
Reply To: RTO 15 minutes with differential backups

You have come across one of the primary reasons why I hate certification courses, exams, and the related books/articles. They're a possibly decent starting point but, oh my...
IMHO, it 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)

January 25, 2020 at 3:58 pm

#3720385
Reply To: How to handle date on temp table when is null or not ?

There is no way to automatically distinguish differences between dd/mm/yyyy and mm/dd/yyyy for values of mm and dd that are less than 13 and so there is no way 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)

January 25, 2020 at 3:20 pm

#3720384
Reply To: Recruitment question

Yes... post a couple of links that point to your specific posts on the job posting sites and let us have a look.
I can also tell you that, based on...
--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)

January 25, 2020 at 12:21 am

#3720332
Reply To: Cranky Curmudgeons

skeleton567 wrote:
Jeff, tell us how you REALLY feel! You are hilarious. With that, I have get off here and go share a glass of wine with my sweetheart of 40...
--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)

January 23, 2020 at 11:44 pm

#3717948
Reply To: Cranky Curmudgeons

skeleton567 wrote:
Well, here is an interesting sidelight to all of this. I've been sitting here today listening and agreeing that I truly am a full-fledged CC. Conversely, in my last...
--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)

January 23, 2020 at 10:47 pm

#3717932
Reply To: Cranky Curmudgeons

Look at the changes they did in 2016... they made it so that all files in Temp DB suffer the equivalent of TF 1117 to force all files to grow...
--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)

January 23, 2020 at 10:31 pm

#3717924
Reply To: Cranky Curmudgeons

Grant Fritchey wrote:
Jeff Moden wrote:
wayne Freeman-369096 wrote:
Congrats on the license upgrade. one more level to go.
We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better...
--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)

January 23, 2020 at 9:37 pm

#3717920

Viewing 15 posts - 7,846 through 7,860 (of 59,098 total)