Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,791 through 8,805 (of 59,102 total)

Reply To: A Self-Tuning Fill Factor Technique for SQL Server – Part 2

Apologies... I posted a reply on the wrong thread and removed 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)

August 27, 2019 at 6:38 pm

#3674814
Reply To: How can I convert %5B and %5D to [ and ] in a string

guerinto wrote:
Thanks Jeff. This appears to be exactly what I am looking for. How would I replace the string with a field name called int_ID now? I don't know what...
--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 27, 2019 at 6:30 pm

#3674808
Reply To: Importing Files in Parallel with SSIS

You're correct in saying that loading a table with a Clustered Index in place does mean that you have to only use a single thread to be able to take...
--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 27, 2019 at 5:23 pm

#3674794
Reply To: Importing Files in Parallel with SSIS

Some of the details may be irrelevant to parallel processing but, in my mind anyway, parallel processing during the initial load is just one part of the equation. As you...
--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 26, 2019 at 11:55 am

#3674351
Reply To: Importing Files in Parallel with SSIS

@iposner ,
I'm curious... Did all 10,000 files have precisely the same format? And what was that format? CSV? TSV? Fixed Width Fields? And can you make a guess as 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)

August 25, 2019 at 6:11 pm

#3674264
Reply To: Primary Key and Clustered Index

nova wrote:
In my previous post I wasn't making any point at all about portability, which I agree is no necessary consideration in designing a database. My point was just about...
--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 25, 2019 at 4:01 pm

#3674259
Reply To: deadlock issue

vsamantha35 wrote:
1. Why a unique non-clustered index ? why not just a non-clustered index for [NI_APPLIED_LOCK_SBL3R8]. Because I don't know the nature of the data if those columns has repeated...
--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 25, 2019 at 3:35 pm

#3674258
Reply To: Primary Key and Clustered Index

nova wrote:
Business data belongs to nominated data controllers and data subjects. Data does not belong to database designers and developers and as a technology professional myself I try to keep...
--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 25, 2019 at 1:52 pm

#3674251
Reply To: Importing Files in Parallel with SSIS

iposner wrote:
Rather than having a master package distribute the list of files to process, another approach is to give each package the rules it needs to process the subset of...
--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 25, 2019 at 3:16 am

#3674223
Reply To: How can I convert %5B and %5D to [ and ] in a string

Just my take on this... single and fairly short formula that does the replacements only once. This, of course, assumes that you'll always be working values where you want 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)

August 25, 2019 at 2:39 am

#3674222
Reply To: SSIS - Adding Columns to existing table and load data

sunshine wrote:
I am working in SSIS (Sql server version 2012) , I have a requirement to add two new columns to a destination table which already has five years of...
--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 25, 2019 at 1:35 am

#3674221
Reply To: deadlock issue
I think that three things need to be done before anything else....
1. Add an index to support the lookup for the update. It should be a unique index consisting of...
--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 25, 2019 at 1:24 am

#3674220
Reply To: Primary Key and Clustered Index

A part of the reason why I use IDENTITY instead of sequence is because IDENTITY IS much more difficult to update and it's flat out not supposed to ever 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)

August 24, 2019 at 11:47 pm

#3674217
Reply To: pre-validate csv to SQL load

Bruin wrote:
before loading csv to SQL is there a way to validate against table schema to catch potential data issues and row number
create a good file(records pass) and bad file(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 24, 2019 at 4:50 am

#3674131
Reply To: deadlock issue

Actually, the code is doing one UPDATE and one DELETE.
The UPDATE needs an index on LOCK_GROUP_STR and ROWID_TABLE to make it fast.
The DELETE needs an index on just the LOCK_GROUP_STR...
--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 24, 2019 at 2:49 am

#3674129

Viewing 15 posts - 8,791 through 8,805 (of 59,102 total)