Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,331 through 9,345 (of 59,091 total)

Reply To: General SQL Development Question.

It's known as an "Upsert" or a "Merge".

What IS the final destination here?
--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 1:10 pm

#3639847
Reply To: how to find which persion have all colorcodes using color table in sql server

John Mitchell-245523 wrote:
What indexes do you have on the tables? Please post an actual execution plan for the query (the .sqlplan file, not just a picture, please). John
Great suggestion that worked very...
--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 1:07 pm

#3639846
Reply To: NOT IN with OpenRowSet

TJ_T wrote:
Hi, I am trying to use a text file to exclude a list of things.

WHY a text file? Without additional information here, I don't see the merit 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)

May 10, 2019 at 1:04 pm

#3639845
Reply To: about T-SQL Scripts tuning

892717952 wrote:
1. when I create an index in a table or views, is there any good way to konw (or evaluate) the index is necessary and correct?
Yes. It...
--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:44 pm

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

Viewing 15 posts - 9,331 through 9,345 (of 59,091 total)