Jeff Moden

Forum Replies Created

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

Reply To: Converting Substring to DateTime - extra eyes please

Thanks, ZZ. What you wrote have been my findings, as well. I'm amazed the MS hasn't made PowerShell easier to use from SQL Server. I'm also amazed that they 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 10, 2019 at 12:22 pm

#3639812
Reply To: Tasks of Senior SQL Server Experts/Data Scientists
The four biggees (there are certainly more) that I can think of are...
1. Practice doing restores and setup something to do restores "under the gun" for when something goes wrong. ...
--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 pm

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

Thom A wrote:
Jeff Moden wrote:
I'm hoping that's not actually a bad thing. 😉
Being able to turn the software off that's trying to keep your work device "safe" doesn't seem "safe". ;)...
--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:19 pm

#3639023
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

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