Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 59,082 total)

Reply To: Best Practice Analyzer for SQL Server 2019

Crud... sorry. I'd posted a link to the BPA for Windows, not SQL server. I took the post down.
Looking into it further, I don't even know if such a thing...
--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 16, 2023 at 11:43 pm

#4212973
Reply To: Why do my queries lose connection?

Sounds to me like some connection zealot wrote a proc to drop all sleeping connections every night.
--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, 2023 at 5:16 pm

#4212108
Reply To: Converting rows into columns

don075 wrote:
Thanks a lot. Much appreciated.
Do you understand how 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 15, 2023 at 2:46 am

#4211565
Reply To: Calculating Prime Numbers With One Query

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Peter "Peso" Larsson wrote a nasty fast Prime Numbers function years ago and I tested it to confirm it. I'll see if I can find it in my...
--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, 2023 at 12:27 am

#4211489
Reply To: how to determine if we can delete the index can be removed

892717952 wrote:
Thank you Erland Sommarskog. I have done some testing based on different cases ,thank you!
AND? What did you find out?
--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, 2023 at 5:52 pm

#4211289
Reply To: INSERT INTO with tally is slower than INSERT INTO within WHILE LOOP

BOR15K wrote:
Thank you all for the valuable replies, but I think this discussion diverted from my original question: why my tally table's function had worse execution plan than my colleague's...
--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, 2023 at 5:51 pm

#4211288
Reply To: Calculating Prime Numbers With One Query

Peter "Peso" Larsson wrote a nasty fast Prime Numbers function years ago and I tested it to confirm it. I'll see if I can find it in my archives this...
--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, 2023 at 5:10 pm

#4211271
Reply To: Calculating Prime Numbers With One Query

My question would be... why do you use a resource intensive, slow as a While loop recursive CTE as your sequence generator? There are many better methods. See the following...
--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, 2023 at 2:28 am

#4210739
Reply To: Help with BCP in SQL 2022

tommiwan wrote:
We copied xmlrw.dll from a working machine to the /system32/ and /SysWOW64/ directories on our Azure SQL VM in order to get this working. I think system32 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)

June 14, 2023 at 2:01 am

#4210722
Reply To: INSERT INTO with tally is slower than INSERT INTO within WHILE LOOP

BOR15K wrote:
Thank you, Jonathan. Almost every step in the execution plan now marked as "No Join Predicate" and the whole function now costs 100% with my original tally one costing...
--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, 2023 at 6:02 pm

#4210510
Reply To: Changing Recovery mode Purges Plan Cache

Alexp012 wrote:
Outside of these two things I can't think how doing a defrag would cause performance issues.
THAT, my friend, is the very problem with 99.9% of the world. 🙂
As Michael...
--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, 2023 at 4:16 pm

#4210382
Reply To: Changing Recovery mode Purges Plan Cache

Alexp012 wrote:
Hi
To stop transaction log growth, our index rebuild process changes databases to Bulk Logged from full recovery and then back again at the end of the process.
What we've noticed,...
--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, 2023 at 7:26 pm

#4209757
Reply To: Changing Recovery mode Purges Plan Cache

Michael L John wrote:
Here's a thought. Stop reindexing.
+1,000,000!!!

--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, 2023 at 7:05 pm

#4209756
Reply To: Help with BCP in SQL 2022

tommiwan wrote:
We were able to get this to work by copying xmlrw.dll from another VM to this VM. I would prefer to understand why this file wasn't in place, but...
--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, 2023 at 7:01 pm

#4209744
Reply To: What's Your Job?

I envy people that can work at that level, as well. 😛 While I still work hard, I no longer want to work THAT hard. 😀
--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, 2023 at 9:17 pm

#4209132

Viewing 15 posts - 1,396 through 1,410 (of 59,082 total)