Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,931 through 6,945 (of 59,102 total)

Reply To: Are You a Gatekeeper?

Just like the best managers, "GateKeepers" must not be just enforcers... they must also be "servant-providers". That doesn't mean they should just rollover and give in just because someone wants...
--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 3:07 pm

#3762964
Reply To: Two Strings compare using t-sql

Jus wrote:
Worked like a champ. Thanks jeff.
😀 Thanks for the feedback.
To be sure, though, do you understand how and why it works?

--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 3:27 am

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

VoldemarG wrote:
and what are advantages of using trace flags for saving deadlock data to transaction log compared to seeing them in the default XE sessions?
Heh... it's a part of EVERYTHING...
--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 3:25 am

#3762906
Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

Frederico mentioned the most important thing in his very first sentence, which is...
frederico_fonseca wrote:
you don't need to measure everything - if someone asked you to do that they don't know...
--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 3:21 am

#3762905
Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

VoldemarG wrote:
Thank you, Jeff, for your
very valuable comment. And I am doing that , too (top 10 worst , etc.).
but aside along from that, there is a specific question asked...
--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 3:01 am

#3762902
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

Viewing 15 posts - 6,931 through 6,945 (of 59,102 total)