Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,266 through 5,280 (of 59,089 total)

Reply To: LATCH_EX when creating a clustered index

I'll try to get back to this later today but... the load should not actually cause the Clustered Index to fragment... if I'm reading things right, it's a wholesale load/replacement.
--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)

May 17, 2021 at 12:48 pm

#3884367
Reply To: SSIS Import only new values from a CSV without using a staging table

Yep... you can avoid a staging table if you'd like but... if something goes wrong, there's going to be a long rollback and your target table might be close to...
--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)

May 17, 2021 at 12:25 pm

#3884351
Reply To: UDF could not be bound

No. And deleting a mistake that you found on your own would be depriving someone of some information that might help them in the future. I'm glad you found it...
--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)

May 17, 2021 at 3:26 am

#3884176
Reply To: UDF could not be bound
frederico_fonseca wrote:
Select b.* from #Imports
CROSS APPLY dbo.UDF_datasummary(a.HS_code) b
missing alias - "a"
frederico_fonseca wrote:
```
Select b.* from #Imports
  CROSS APPLY dbo.UDF_datasummary(a.HS_code) b
```
missing alias -...
--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)
May 17, 2021 at 2:31 am

#3884169
Reply To: UDF could not be bound

Scott745618 wrote:
Resolved
Scott745618 wrote:
Resolved
So, what was the 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)

May 16, 2021 at 6:26 pm

#3884080
Reply To: loading data from staging table to final with validations to data specific

It may be that this could mostly be done during the original insert into the staging table. In order to know that, we'd need to know what the "Facets Feed"...
--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)

May 16, 2021 at 6:25 pm

#3884079
Reply To: Loading a csv file into sql server table

One of the methods to read a CSV file is to make a "temporary" linked server, use it, then drop it. I don't know enough about SSIS to say 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)

May 15, 2021 at 11:09 pm

#3883900
Reply To: prevent certain characters being inserted into table

My apologies... I flat out forgot that this is a VENDOR supplied table. I absolutely agree with the others but will take it one step further... unless you get written...
--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)

May 15, 2021 at 11:06 pm

#3883899
Reply To: Limit database restores to specific drive locations

I don't suppose removing privs from users and forcing them to use a stored procedure to do restores is an option?
--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)

May 15, 2021 at 12:28 am

#3883646
Reply To: prevent certain characters being inserted into table

The "best" way would be to have an "INSTEAD OF" trigger that checks the entry. You could also do it after the fact with a normal "after" trigger that would...
--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)

May 15, 2021 at 12:06 am

#3883644
Reply To: prevent certain characters being inserted into table

What are you saying you want done if an attempted entry contains one of the taboo characters? Do you want to silently reject the entire entry or just remove the...
--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)

May 15, 2021 at 12:00 am

#3883641
Reply To: Loading a csv file into sql server table

I avoid SSIS like the plague and so I'm not sure but it looks to me like SSIS isn't able to access the file. Have you checked to make sure...
--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)

May 14, 2021 at 11:42 pm

#3883639
Reply To: How to rebuild index on Internal Table?

Please read the second paragraph from the article at the following URL for the answer to that...
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-internal-tables-transact-sql?view=sql-server-ver15
--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)

May 14, 2021 at 11:28 pm

#3883630
Reply To: Monitor SQL Server Agent Jobs No Longer Executed

If you stop and think about it, all the supposed light-weight things you propose are just another way of capturing history except they are more heavy weight.
--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)

May 14, 2021 at 11:22 pm

#3883629
Reply To: Are the posted questions getting worse?

The other part about the documentation on index maintenance is that it's spread all over hell's little half acre. This IS a spot that actually describes what REORGANIZE does 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)

May 13, 2021 at 6:51 pm

#3883139

Viewing 15 posts - 5,266 through 5,280 (of 59,089 total)