Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,346 through 9,360 (of 59,099 total)

Reply To: Converting Substring to DateTime - extra eyes please

ZZartin wrote:
I didn't mean to be flippant with my response it just seemed like there was a lot of work being put into what seemed like relatively simple folder clean...
--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)

May 9, 2019 at 1:01 pm

#3639017
Reply To: Cursors are not supported on a table which has a clustered columnstore index

irehman wrote:
2012
I know you didn't originally get the answer you wanted and we had a little fun with it but that's no reason to destroy your original post. That's also...
--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)

May 9, 2019 at 1:47 am

#3638756
Reply To: Cursors are not supported on a table which has a clustered columnstore index

Dally Horton wrote:
In case anyone else comes up against this problem, the solution for me was to make sure my destination was set to bulk load the table. In other words,...
--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)

May 9, 2019 at 1:45 am

#3638755
Reply To: Delimited Identifiers in code interpreted as BBCode

Thom A wrote:
Jeff Moden wrote:
It WAS working for me before on both places it is no longer working. I've not made any security level changes in FireFox or Chrome, either.
Maybe a...
--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)

May 9, 2019 at 1:42 am

#3638751
Reply To: Performance difference for stored proc in SSIS vs SSMS (and other questions)

Thanks, Sue. Thanks for confirming what I was seeing. As a bit of a sidebar, I don't even know how to do attachments on this site since the migration.
--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)

May 8, 2019 at 6:57 pm

#3638528
Reply To: Performance difference for stored proc in SSIS vs SSMS (and other questions)

Something is seriously wrong with my connections to SSC... I don't see any files attached.

@sue... are you seeing any? This might be associated with the same problem as me not...
--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)

May 8, 2019 at 6:45 pm

#3638519
Reply To: Converting Substring to DateTime - extra eyes please

David Burrows wrote:
Jeff Moden wrote:
Totally agree with the XP_CmdShell thing. Of course, if you do that, you don't need PowerShell to begin with. Just create the file deletion commands directly from MSDB...
--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)

May 8, 2019 at 6:39 pm

#3638514
Reply To: Can using a scalar UDF actually improve performance?

p.s. I'm not 100% sure but I don't believe they've disabled the ability to turn ANSI NULLs off yet in 2017. It has been an advisory for many years, though. ...
--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)

May 8, 2019 at 6:21 pm

#3638505
Reply To: Getting the time

Heh... and people wonder why I hate case sensitive code. 😉
--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)

May 8, 2019 at 6:14 pm

#3638501
Reply To: Can using a scalar UDF actually improve performance?

dbodell wrote:
I noticed in the article you linked to, SSC Guru, that SQL 2017 will not allow you to set ANSI NULLs off. If that is the case, how are...
--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)

May 8, 2019 at 6:10 pm

#3638498
Reply To: Performance difference for stored proc in SSIS vs SSMS (and other questions)

Why do "hundred of millions of rows" need to be updated? If we knew what the table was for, what the structure was, and the need to do the update,...
--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)

May 8, 2019 at 5:25 pm

#3638461
Reply To: Converting Substring to DateTime - extra eyes please

Totally agree with the XP_CmdShell thing. Of course, if you do that, you don't need PowerShell to begin with. Just create the file deletion commands directly from MSDB backup history...
--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)

May 8, 2019 at 12:42 pm

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

And that is no slight on the other SQL Saturdays. It takes a good bit of dedication and good planning to make an SQL Saturday and I've not seen a...
--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)

May 8, 2019 at 12:24 pm

#3638258
Reply To: Delimited Identifiers in code interpreted as BBCode

It WAS working for me before on both places it is no longer working. I've not made any security level changes in FireFox or Chrome, either.

I hope I don't have...
--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)

May 8, 2019 at 1:48 am

#3637907
Reply To: Converting Substring to DateTime - extra eyes please

ZZartin wrote:
Why are you trying to do this in SQL, this is something that's extremely trivial in powershell, as in 1 line of code. (Get-ChildItem -Path ("C:\Test\*.txt") | Sort-Object...
--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)

May 8, 2019 at 1:00 am

#3637862

Viewing 15 posts - 9,346 through 9,360 (of 59,099 total)