Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,916 through 6,930 (of 59,091 total)

Reply To: Banker’s Rounding. What is it good for?

<quote>From the Last Sentence of the Conclusion in the Article...
To maintain the best precision of the final result all intermediate calculations must be performed on numbers in floating point formats,...
--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 15, 2020 at 12:29 pm

#3763089
Reply To: Sum days for fiscalyear

cbrammer1219 wrote:
I've attached a screen shot of the table definitions.
Ya know... If you were to post an actual CREATE TABLE bit of code for the pertinent columns for this problem...
--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 15, 2020 at 1:02 am

#3762998
Reply To: Performance Tuning a SQL Server Database in Amazon RDS

I have to ask... were the databases previously on-premise? If so, did they "work fine"?

--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 8:09 pm

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

VoldemarG wrote:
Also, please enjoy sp_Who3
https://www.sql.ru/forum/96127/sp-who3
Perhaps the author should spend a bit more time on it first.
Msg 8152, Level 16, State 13, Line 1
String or binary data would 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 14, 2020 at 7:28 pm

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

Viewing 15 posts - 6,916 through 6,930 (of 59,091 total)