Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 59,086 total)

Reply To: Ask Help to split string by split‘;&;’

Eirikur Eiriksson wrote:
You might want to use the Lead version of the splitter
I absolutely agree. In fact, my personal copy of DelimitedSplit8K has Eirikur's wonderful performance improvement in it (and has...
--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)

August 30, 2022 at 4:32 am

#4081797
Reply To: All spids showing resource semaphore waits

To add to Jo's and Scott's good suggestions, check on MAXDOP while you're at it If it's set to "0" (something can use ALL the CPU's at the same time),...
--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)

August 30, 2022 at 4:29 am

#4081796
Reply To: MS Visual Basic OR MS Visual C# ??

Just do a BULK INSERT to import the XML file as a BLOB and parse it with the normal XML tools.
--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)

August 30, 2022 at 12:44 am

#4081774
Reply To: Clustered Index leaves a lot of empty space

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
You state, "A monster index will have to be rebuilt where it may not have been fragmented at all without compression." What is the basis for 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)

August 30, 2022 at 12:40 am

#4081773
Reply To: between is not working the way I would think?

bswhipp wrote:
Would like to post the data but I have a solution now. This will run once a quarter at night so it is not a huge hit on processing....
--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)

August 29, 2022 at 6:01 pm

#4081707
Reply To: Clustered Index leaves a lot of empty space

@haahof,
I'd like to setup a test table to do the some testing on for all of this. With in mind...
Could you tell us what is meant by "This table only...
--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)

August 29, 2022 at 5:50 pm

#4081705
Reply To: Clustered Index leaves a lot of empty space

ScottPletcher wrote:
You state, "A monster index will have to be rebuilt where it may not have been fragmented at all without compression." What is the basis for that claim?
Same as...
--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)

August 29, 2022 at 5:37 pm

#4081703
Reply To: MS Visual Basic OR MS Visual C# ??

Jobs90312 wrote:
Ok and what about Python? I heard somewhere that it can also be used as an alternative of SSIS tasks?
Yes it can... so can C#, Visual Basic, PowerShell, a...
--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)

August 29, 2022 at 5:05 am

#4081452
Reply To: Clustered Index leaves a lot of empty space

It was not "obvious" that you were speaking of VARCHAR because they are NOT affected by row compression at all. Only CHAR is affected by row compression and you clearly...
--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)

August 29, 2022 at 5:01 am

#4081445
Reply To: Clustered Index leaves a lot of empty space

When you read this, Scott, remember that I LOVE page compression...
You say the following but you need to qualify, especially to a person who might not know what compression 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)

August 29, 2022 at 12:09 am

#4081413
Reply To: Performance degradation - Help troubleshooting

This is going to sound strange but it's happened where I work at twice now...
On high performance storage, there's usually a rechargeable cache battery. Most people don't even know such...
--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)

August 28, 2022 at 11:18 pm

#4081410
Reply To: SQL Audit to File

Jeffrey Williams wrote:
Jeff Moden wrote:
Instead of using PowerShell, why not make a call to BCP and us the "out" functionality? It's nasty fast. I'll also tell you that if they have 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)

August 28, 2022 at 10:55 pm

#4081405
Reply To: Clustered Index leaves a lot of empty space

It doesn't take much to cause a page split with compression enable on tables that aren't suffering from page splits to being with. If you're going to use compression 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)

August 28, 2022 at 5:00 am

#4081296
Reply To: Calculations in TSQL

What about your QA Department??? They're the ones that should be checking to see if things worked.
Also, did you check it? Have you found any problems with it? Generally, forums...
--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)

August 28, 2022 at 4:51 am

#4081295
Reply To: SQL Audit to File

Instead of using PowerShell, why not make a call to BCP and us the "out" functionality? It's nasty fast. I'll also tell you that if they have SQL Server at...
--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)

August 28, 2022 at 4:46 am

#4081293

Viewing 15 posts - 2,881 through 2,895 (of 59,086 total)