Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,521 through 8,535 (of 59,091 total)

Reply To: remove double quotes from file ssis- azure

@Phil...
As you know, I'm not a great study of SSIS or Azure and so I have to ask... for something like this (consistent use of delimiters and text qualifiers), it'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)

October 23, 2019 at 1:51 am

#3691178
Reply To: remove double quotes from file ssis- azure

Phil Parkin wrote:
Azure Blob Source does not supports multiple-character delimiter.
Nit-picking a little, but the delimiter is only a single comma. The double quotes are text qualifiers.
Now I don't feel so bad...
--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)

October 23, 2019 at 1:47 am

#3691176
Reply To: Transaction log full but TL backups is is just 8KB

Have you checked to see if you actually do have an open transaction on the database? And, yeah... I agree with Steve T in his suggestion. I've not had 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)

October 23, 2019 at 1:31 am

#3691175
Reply To: Alternate to temporary table in azure sql

While you're at it, don't forget to store a date with the age so that you can estimate the actual age in the future. You might want to consider further...
--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)

October 23, 2019 at 1:21 am

#3691173
Reply To: Is SSIS really that bad?

Rod at work wrote:
Chris Harshman wrote:
Over the years as both a Database Developer and DBA, I've found SSIS to be a good tool. As others have said, not necessarily the best tool, 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)

October 23, 2019 at 1:02 am

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

Steve Jones - SSC Editor wrote:
London would be interesting. The SuperBowl is such an event and exepnsive. Likely not much more cost in London than LA for attendees.
Long as they don't change the 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)

October 23, 2019 at 12:49 am

#3691166
Reply To: remove double quotes from file ssis- azure

Lowell wrote:
dang i missed that part.
https://social.msdn.microsoft.com/Forums/SECURITY/en-US/dfa95b28-e2aa-465d-b34a-b230b3d0b624/ssis-azure-blob-source-limitation?forum=sqlintegrationservices
that literally says bring it into someplace where you can use a flat file connection manager, since it is not supported yet.
sorry:
Azure Blob Source does...
--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)

October 23, 2019 at 12:40 am

#3691165
Reply To: Inserting Data

Just use an outer join to the Products table.
--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)

October 22, 2019 at 3:11 pm

#3691028
Reply To: STRING_SPLIT with Index as Table-Valued Function

bteague wrote:
Fair points. I've updated the function to return a "0, No value" record if a NULL value is passed to the function. An empty string within the function returns...
--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)

October 22, 2019 at 3:01 pm

#3691020
Reply To: CHECKSUM(3) = CHECKSUM(-3) ???

The only thing I use checksums and hashes for is a quick check to prove things are not the same. If the checksum or hash indicates they are, then further...
--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)

October 22, 2019 at 2:45 pm

#3691006
Reply To: Is SSIS really that bad?

I know that a lot of people don't have the following kinds of problems with SSIS but I see them happen enough where I'm really happy that I've mostly divorced...
--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)

October 21, 2019 at 11:40 pm

#3690782
Reply To:

Welcome aboard.
--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)

October 21, 2019 at 1:12 pm

#3690561
Reply To: Script multiple queries

GaryV wrote:
The better option would be to have your database object definitions in your code store, so you can grab them and run them in the new server.
+1 million 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)

October 21, 2019 at 11:59 am

#3690538
Reply To: Removing a double space in the middle of a name
The most efficient method for reducing any number of spaces up to 8000 that I've ever seen is as follows...
```
 SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
     ...
```
--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)
October 21, 2019 at 1:36 am

#3690475
Reply To: STRING_SPLIT with Index as Table-Valued Function

This is a pretty common "fix" for this problem but, Microsoft makes no guarantees that such a thing will actually work forever. Knowing how most managed code would work 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)

October 20, 2019 at 4:30 pm

#3690451

Viewing 15 posts - 8,521 through 8,535 (of 59,091 total)