Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,901 through 6,915 (of 59,072 total)

Reply To: Two Strings compare using t-sql
```
 SELECT STRING_AGG(d.value,',')
   FROM (
         SELECT value
          ...
```
--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 14, 2020 at 12:24 am

#3762898
Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?
1. If you measure it, you change it. (usually for the worse)
2. If you measure everything, you change everything (usually for the worse).
3. If you measure everything, you will see...
--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 13, 2020 at 4:46 pm

#3762854
Reply To: SQL fuzzy logic in join

jcelko212 32090 wrote:
You're doing the wrong thing badly. You don't seem to know the table must have a primary key by definition; this is not an option! A row is 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)

June 12, 2020 at 4:40 am

#3762526
Reply To: SQL fuzzy logic in join

Here's one way to do this... it's horrible because, without a Clustered Index on the ID column, it takes 4 scans of the table and doesn't do much better with...
--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 12, 2020 at 4:33 am

#3762523
Reply To: Confused about CountRows

Martin Schoombee wrote:
I believe it's because an empty string in Power BI is a value. Try using nulls instead and see if you get the intended behavior.
'' <> Blank() in Power...
--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 11, 2020 at 6:51 pm

#3762404
Reply To: All info about all Extended Events on the server - how can i get it via a query?

Heh... sounds almost as bad as the default trace. We blow through that in about 10 minutes.

--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 11, 2020 at 6:45 pm

#3762400
Reply To: Is SELECT a part of DML, DDL or something else?

On that note, I'll see if I have the time to add it. I guess it's also time to have a "come to Jesus" meeting with them about their documentation...
--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 11, 2020 at 6:44 pm

#3762398
Reply To: The Order of Operations

Yep... agreed. But you have to do something "special" for it to work. I guess I don't see any real reason why SQL Server should be any different except 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)

June 11, 2020 at 6:40 pm

#3762396
Reply To: The Benefits and Detractions of Remote

David.Poole wrote:
Still wearing SQLBits clothes from 2014!
That's a really long time, David. You should at least change your underwear every one or two weeks. 😀
--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 11, 2020 at 4:40 pm

#3762361
Reply To: The Order of Operations

The only reason why I got it right was because it has bitten so many people that work in every company that I've ever worked in including me back in...
--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 11, 2020 at 4:28 pm

#3762353
Reply To: Is SELECT a part of DML, DDL or something else?

michael.leach2015 wrote:
Jeff,
Thank you for your input. I'm glad I asked these questions.
With all the replies I am still unclear about which language type SELECT really falls under. Just 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)

June 11, 2020 at 3:33 am

#3762170
Reply To: How do I post a table as part of a forum question?

Steve Jones - SSC Editor wrote:
We haven't supported tables directly. I was surprised myself, and it's on a backlog, but I think it's relatively unimportant. Most of the time, having DDL/DML is better for...
--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 10, 2020 at 10:33 pm

#3762150
Reply To: How do I post a table as part of a forum question?

Mark Dalley wrote:
I have a question which could benefit a lot from having a 3-column table as part of the content.
If you really want help with such a thing, see 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 10, 2020 at 10:32 pm

#3762149
Reply To: Is SELECT a part of DML, DDL or something else?

jonathan.crawford wrote:
Honestly, a little excited to go vote for "this page is full of hooie"...
Let's continue to check out the "hooie" factor...
Since they don't provide any links in that article...
--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 10, 2020 at 10:11 pm

#3762142
Reply To: Is SELECT a part of DML, DDL or something else?

Steve Jones - SSC Editor wrote:
Good points. Submitted a PR to add SELECT to DML.
Anyone can do this: http://voiceofthedba.com/2018/01/03/creating-a-books-online-pull-request/
Did it include a request to move TRUNCATE TABLE from DML to DDL?
--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 10, 2020 at 9:51 pm

#3762133

Viewing 15 posts - 6,901 through 6,915 (of 59,072 total)