Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,761 through 11,775 (of 59,102 total)

RE: Flat File csv with double quotes

@ gothaimviii ,
In my curious mind, I'd like to know if you've solved this problem and, if so, what the issue...
--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)

July 22, 2018 at 6:16 am

#1998515
RE: Flat File csv with double quotes

Chrissy321 - Wednesday, July 18, 2018 4:13 PM
See this http://sqlblog.com/blogs/jamie_thomson/archive/2010/11/25/sql-server-2008-sp1-cu-6-includes-small-changes-to-dtsx-files.aspx
I distantly recall running into this. I think if you view the properties...
--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)

July 22, 2018 at 6:14 am

#1998514
RE: Flat File csv with double quotes

andycadley - Sunday, July 22, 2018 3:33 AM
Powershell can be quite handy for this kind of thing, it can be as simple...
--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)

July 22, 2018 at 6:06 am

#1998513
RE: Creating XML Indexes

Eirikur Eiriksson - Saturday, July 21, 2018 7:01 AM
Thanks for the question Steve.
😎
The XML indices are very "interesting" when it comes...
--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)

July 21, 2018 at 8:02 am

#1998496
RE: Update to trim certain values

One of the most important and advantageous things that you can do with any computer language is to know what all the different intrinsic functions actually can do and how...
--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)

July 21, 2018 at 7:49 am

#1998495
RE: Are the posted questions getting worse?

Thom A - Friday, July 20, 2018 1:44 AM
I think it's more telling that for someone who has been working with...
--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)

July 20, 2018 at 5:32 pm

#1998486
RE: dm_db_index_usage_stats not accurately reflecting index usage

doodlingdba - Friday, July 20, 2018 8:58 AM
Sorry for the delay in getting back to you guys, i had a couple days...
--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)

July 20, 2018 at 9:02 am

#1998429
RE: Throttling the CPU / Disk IO for SQL Restore Option

Thanks for the correction, there. I meant to type AWS but it came out as Azure. Not a good reason but that's the reason. 😀
--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)

July 20, 2018 at 9:01 am

#1998428
RE: How to Split the Sting in SQl Server

Thom A - Friday, July 20, 2018 8:02 AM
Lynn Pettis - Friday, July 20, 2018 7:56 AM
--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)

July 20, 2018 at 8:59 am

#1998426
RE: Need Help to convert DATETIME result into DATE on SQL Server

Lynn Pettis - Friday, July 20, 2018 8:20 AM
Jeff Moden - Friday, July 20, 2018 8:10 AM
--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)

July 20, 2018 at 8:26 am

#1998415
RE: Storage that Expires

David.Poole - Friday, July 20, 2018 12:16 AM
Tough cases make bad laws.
This is why laws are so complicated and verbose. 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)

July 20, 2018 at 8:23 am

#1998413
RE: Creating a PDF from a Stored Procedure

For those longing for additional information on this article and code, the author hasn't even logged into SQLServerCentral.com in the last 11 years and has never made a reply 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)

July 20, 2018 at 8:17 am

#1998409
RE: Need Help to convert DATETIME result into DATE on SQL Server

Jeff Moden - Thursday, July 19, 2018 5:42 PM
Jeff Moden - Wednesday, July 18, 2018 8:10 PM
--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)

July 20, 2018 at 8:10 am

#1998405
RE: Throttling the CPU / Disk IO for SQL Restore Option

Sridhar-137443 - Friday, July 20, 2018 7:23 AM
Thank you for your input. I understand that upgrading the server is the way 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)

July 20, 2018 at 8:07 am

#1998403
RE: Came Across this vaugly Amusing

SimonH - Friday, July 20, 2018 4:43 AM
https://twitter.com/internetrebecca/status/1020021808764981249
I'll bite... What do you find amusing 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)

July 20, 2018 at 7:40 am

#1998388

Viewing 15 posts - 11,761 through 11,775 (of 59,102 total)