Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,921 through 7,935 (of 59,072 total)

Reply To: Validating meta data of xls file

Getting kind of back on topic, has anyone tried the demo I provided?

--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)

January 9, 2020 at 6:39 pm

#3714083
Reply To: Correlation of DTU and RAM in ( GB) allocated to DB

From what I understand, DTU is not based on RAM alone. Please see the following article.
https://sqlperformance.com/2017/03/azure/what-the-heck-is-a-dtu

--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)

January 8, 2020 at 10:00 pm

#3713808
Reply To: Clearing the data from all the tables

If you TRUNCATE all tables, you better have a script handy to repopulate ALL your necessary reference tables. 😉
--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)

January 8, 2020 at 9:50 pm

#3713805
Reply To: Validating meta data of xls file

Phil Parkin wrote:
Phil Parkin wrote:
Phil... where do you hail from? I ask because I'm giving the "Automating "Excel Hell"" presentation at the Cleveland SQL Saturday on the 1st of February 2020 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)

January 8, 2020 at 9:14 pm

#3713797
Reply To: Validating meta data of xls file

David Burrows wrote:
Phil Parkin wrote:
Unzipping files is natively available in .NET, so there should be no need to install additional software.
See here for more info.
I was thinking the same and there...
--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)

January 8, 2020 at 8:02 pm

#3713788
Reply To: Validating meta data of xls file

I know I don't have to check on the CLR thing... I don't use them. 😀
--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)

January 8, 2020 at 7:59 pm

#3713785
Reply To: Validating meta data of xls file

Phil Parkin wrote:
Unzipping files is natively available in .NET, so there should be no need to install additional software.
See here for more info.
Just to be sure, my solution didn't include...
--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)

January 8, 2020 at 5:06 pm

#3713699
Reply To: Validating meta data of xls file

Eirikur Eiriksson wrote:
David Burrows wrote:
Eirikur Eiriksson wrote:
David Burrows wrote:
Eirikur Eiriksson wrote:
Phil Parkin wrote:
David Burrows wrote:
This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column,...
--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)

January 8, 2020 at 5:02 pm

#3713693
Reply To: Validating meta data of xls file

Phil Parkin wrote:
Jeff, thank you for taking the time to write all of this stuff out.
Importing from Excel using SSIS is almost always a massive pain, so I am going 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)

January 8, 2020 at 4:56 pm

#3713686
Reply To: How to get highest bonus and second highest bnus paid freelancer for each group

Heh... can you put the Create Table statement back 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)

January 8, 2020 at 5:02 am

#3713489
Reply To: How to get highest bonus and second highest bnus paid freelancer for each group

Your test data only has one person per group.
--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)

January 8, 2020 at 4:52 am

#3713486
Reply To: Great Writers Get Hired

I have to tell you that if you work with the right recruiter, you don't have to worry about AI HR bots, HR people, or whatever. A lot of people...
--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)

January 8, 2020 at 4:40 am

#3713485
Reply To: Validating meta data of xls file

p.p.s. Almost forgot. Sheet names that are weird or begin with a numeric digit must be encapsulated in single quotes along with the normal square brackets. For example the sheet...
--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)

January 8, 2020 at 4:33 am

#3713481
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

corey lawson wrote:
Hey, Jeff, will you update this yet again to include the new split_string() function in SQL Server 2016+?
Probably not. The STRING_SPLIT function is relatively crippled for those that need...
--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)

January 8, 2020 at 3:33 am

#3713475
Reply To: Validating meta data of xls file

p.s. If the OP has a spreadsheet with just one header row, we'll need to do a little work but not much. We'll make it so it's self-healing just 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)

January 8, 2020 at 2:57 am

#3713467

Viewing 15 posts - 7,921 through 7,935 (of 59,072 total)