Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 59,067 total)

Reply To: How do I query to exclude the "first position of a 3 digit number"

aaron.reese wrote:
So with my Joe Celko hat on 🙂
Is Room Number a numeric value or not? Most people would say yes, but in fact I would say no. The reason...
--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)

September 1, 2022 at 3:10 am

#4082670
Reply To: Is It Possible to Join a Table-Valued Function w/Param To DB table

If your "TVF" has the word BEGIN in it, that'll make a world of hurt no matter how you're using it. That would make it an mTVF (Multi-statement Table Valued...
--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)

September 1, 2022 at 2:05 am

#4082665
Reply To: Add another column with some commands

I guess I don't understand why you need to do this. The role grants those privs. Why do you want/need to do it separately?
--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)

September 1, 2022 at 1:50 am

#4082660
Reply To: Unlimited PTO

What I'd really like to see are companies that stop punishing people for not taking time off. I've had more vacation just vanish because I had more on the books...
--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)

September 1, 2022 at 1:32 am

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

ScottPletcher wrote:
Here's a sample table and the corresponding view, with one non-nullable datetime and one non-nullable int column that have placeholder values that return NULL when querying the table.
For now,...
--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)

September 1, 2022 at 1:25 am

#4082656
Reply To: Find replace using regular expressions

I've done some things using the "RegEx" button (which is a serious misnomer of it's own) on Search'n'Replace in SSMS but nothing like this. I can see other uses 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)

August 30, 2022 at 8:20 pm

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

Viewing 15 posts - 2,851 through 2,865 (of 59,067 total)