Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,336 through 16,350 (of 59,067 total)

RE: Random 64 Characters alphanumeric String

Eirikur Eiriksson (11/9/2016)
Jeff, have you been thinking about this for the last 7 years?
😎
Nah... just ran into the post. Just went through this in the company I work 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)

November 9, 2016 at 4:36 pm

#1911514
RE: Does the SQL Import wizard imports data in sequence?

halifaxdal (11/9/2016)
Jeff Moden (11/8/2016)
ZZartin (11/8/2016)
Yes it will process text files in line order, that is no guarantee however that they'll come out of a database table in that order. ...
--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)

November 9, 2016 at 7:30 am

#1911410
RE: How to use a CSV as parameter in a query

Henk Schreij (11/7/2016)
@"Quick question, how many parameter values do you expect in a single call?"
Not more then 5. It's the count of the Themes of the Trip.
The number of trips...
--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)

November 8, 2016 at 11:47 pm

#1911332
RE: Table valued fucntion or scalar valued function

sqlfriends (11/7/2016)
A further question, if function are not worked efficiently, why T_SQL has this table valued functions?
In which case we should create functions?
I can think of is for calculation, parse,...
--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)

November 8, 2016 at 11:37 pm

#1911331
RE: Finding Duplicates Across Columns

dec_obrien (11/8/2016)
Hi,
Yes, that works thanks. I think I need to find out why though: I haven't used CROSS APPLY before.
It's basically the same thing as a correlated subquery in 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)

November 8, 2016 at 11:30 pm

#1911330
RE: Does the SQL Import wizard imports data in sequence?

ZZartin (11/8/2016)
Yes it will process text files in line order, that is no guarantee however that they'll come out of a database table in that order. The line counter...
--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)

November 8, 2016 at 11:25 pm

#1911327
RE: is it possible to determine the max length of a field in a csv file?

halifaxdal (11/8/2016)
This has been discussed before but I couldn't find a case/answer that might apply to my situation:
From time to time I have raw data in text to be imported...
--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)

November 8, 2016 at 11:22 pm

#1911326
RE: is it possible to determine the max length of a field in a csv file?

Alan.B (11/8/2016)
You can accomplish this using NGrams2B which can be downloaded from here[/url] at the end of the article.).
I must be tired and I'm not seeing what you're talking...
--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)

November 8, 2016 at 11:10 pm

#1911324
RE: Random 64 Characters alphanumeric String

I know this is a really old thread but, to avoid building a random foul word generator, there's an easy method to do this.
SELECT REPLACE(CONVERT(CHAR(36),NEWID())+CONVERT(CHAR(36),NEWID()),'-','')
p.s. This does sound like...
--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)

November 8, 2016 at 11:01 pm

#1911323
RE: how to pick the first file first from specific folder using for each in SSIS

drew.allen (11/8/2016)
The files are processed in alphabetical order. If you follow the naming convention of having a fixed filename prefix with a timestamp suffix in YYYYMMDDHHMMSS order they will...
--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)

November 8, 2016 at 2:04 pm

#1911293
RE: Big data: transfer x-number of rows per batch?

Sergiy (11/7/2016)
Jeff Moden (11/7/2016)
Sergiy (11/2/2016)
The fastest data transferring channel is a truck loaded with DVD's
:hehe:
Or an overnight care package with a monster hard disk in it. 😀 Did 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)

November 8, 2016 at 6:40 am

#1911173
RE: Bring Solutions

Marcia J (2/21/2013)
Keith Langmead (2/21/2013)
...The only issue I have with this idea is that it assumes you're capable of providing a solution, and it's quite possible that won't be 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)

November 8, 2016 at 6:23 am

#1911170
RE: Drill down values...

PiMané (11/8/2016)
Jeff Moden (11/8/2016)
Either will work but the latter stands a good chance of performing better due to "pre-aggregation".
I used the 2nd option.... A CTE with the rollup data and...
--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)

November 8, 2016 at 6:13 am

#1911169
RE: A Better sp_Spaceused

Eirikur Eiriksson (11/7/2016)
Jeff Moden (11/7/2016)
Eirikur Eiriksson (11/7/2016)
Jeff Moden (11/6/2016)
Geez... it would have been SOOOOOOOO simple for them to make the "improvement" so much more worthwhile. I don't know why...
--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)

November 8, 2016 at 5:42 am

#1911157
RE: Drill down values...

PiMané (11/8/2016)
Hi,
Is there a way to "tell" ROLLUP that 2 fields are to be "joined"?
For example, if supplier has a name can I join with the suppliers table and get...
--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)

November 8, 2016 at 5:24 am

#1911152

Viewing 15 posts - 16,336 through 16,350 (of 59,067 total)