Jeff Moden

Forum Replies Created

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

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
Reply To: Are the posted questions getting worse?

Robert Sterbal wrote:
I don't see an upcoming SQLSaturday in Pittsburgh... for Sept, I only see events in Boston and Memphis in the US. Has it been announced yet? No, we always...
--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 7, 2019 at 11:30 pm

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

IIRC, the file paths and the fact that they're "COPY ONLY" are stored in the MSDB database. I think it would be a simple, very quick, and very accurate method...
--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 7, 2019 at 3:56 pm

#3637227
Reply To: Transfer missing table data from one database to another.

Erland Sommarskog wrote:
In addition to the other posts: Perform the operation in a transaction at first do it with ROLLBACK, so that you can verify that you got the correct results...
--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 7, 2019 at 3:51 pm

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

No... they haven't announced it yet. IIRC, they normally announce it sometime in June.
--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 7, 2019 at 3:47 pm

#3637223
Reply To: Report on the entire SQL Server environment for a newcomer

Search for Brent Ozar's sp_Blitz. I consider it to be a gold standard along with many of his other "Blitz" scripts. The cool part is you can dump the output...
--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 7, 2019 at 3:46 pm

#3637222
Reply To: Dos and Don'ts of Dynamic SQL

Yep... I know why it's there. I just think the implementation leaves a bit to be desired.
--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 7, 2019 at 3:43 pm

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

I wonder why it's not working for me. It times out for IE (yeah, I know but had to try) and FireFox on my personal laptop and it times out...
--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 7, 2019 at 3:41 pm

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

To add to that problem, when you're creating a post and need to lookup a BBCode and click on the "BBCode tags reference" (which points to https://www.bbcode.org/reference.php ), it takes...
--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 7, 2019 at 2:25 pm

#3637162

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