Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,051 through 10,065 (of 59,099 total)

RE: Cross Apply Executing Too Many Times

Jonathan AC Roberts - Monday, January 14, 2019 7:36 PM
Jeff Moden - Monday, January 14, 2019 5:54...
--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)

January 14, 2019 at 7:50 pm

#2018894
RE: Cross Apply Executing Too Many Times

Jonathan AC Roberts - Monday, January 14, 2019 10:35 AM
CROSS APPLY is a row level operator. So your table_valued_function will be run once...
--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)

January 14, 2019 at 5:54 pm

#2018891
RE: Badly Trained AI

patrickmcginnis59 10839 - Monday, January 14, 2019 6:25 AM
I have a different opinion on that one. I don't doubt his luck...
--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)

January 14, 2019 at 3:44 pm

#2018888
RE: Run New PowerShell Process As A Different User

$UserName = 'DOMAIN\DifferentUser'
$PlainPassword = 'StrongPassword'
The snippet of code above is from the code you posted. I'm no ninja at PowerShell but that code seems...
--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)

January 13, 2019 at 1:33 pm

#2018797
RE: Database refresh from Production DB to Test DB in Sql server 2014

GilaMonster - Sunday, January 13, 2019 12:56 PM
You do step 2 once. Not every time.
And you generate the login script from...
--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)

January 13, 2019 at 1:00 pm

#2018795
RE: Slow stored procedures after migration 2008 to 2016 SQL server

alexandermkd - Sunday, January 13, 2019 5:35 AM
Dear friends i want to say big tnx for all effort and help about my...
--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)

January 13, 2019 at 12:53 pm

#2018793
RE: Slow stored procedures after migration 2008 to 2016 SQL server

frederico_fonseca - Sunday, January 13, 2019 3:17 AM
Jeff Moden - Saturday, January 12, 2019 11:07 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)

January 13, 2019 at 12:50 pm

#2018792
RE: Badly Trained AI

skeleton567 - Saturday, January 12, 2019 7:20 AM
Well, if companies had depended on AI when I was starting out, I'd 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)

January 13, 2019 at 12:45 am

#2018778
RE: Slow stored procedures after migration 2008 to 2016 SQL server

Actually, the code is pretty good. If we look at one of the variable solutions and add some comments...

SET @ONNET_STAR_AFT =
(
--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)

January 12, 2019 at 11:57 pm

#2018777
RE: Slow stored procedures after migration 2008 to 2016 SQL server

frederico_fonseca - Thursday, January 10, 2019 10:59 AM
@jeff - the OP has already tried the some trace flags and also had the...
--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)

January 12, 2019 at 11:07 pm

#2018775
RE: Can NULLs Exist in the Columns of a Non-Clustered Index?

Gail Wanabee - Saturday, January 12, 2019 4:54 PM
It wasn't an article, Jeff.
I copied the text excerpt from a Help function write-up...
--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)

January 12, 2019 at 10:02 pm

#2018773
RE: Can NULLs Exist in the Columns of a Non-Clustered Index?

Gail Wanabee - Wednesday, January 9, 2019 2:42 PM
A fairly credible source (SolarWinds, DPA help function) had this advice for determining the...
--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)

January 12, 2019 at 1:08 pm

#2018771
RE: Where's that Snippet?

A very timely article, indeed, Phil. I, unfortunately, have to have a whole lot of stuff open on my screen all at the same time because not only do I...
--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)

January 12, 2019 at 8:22 am

#2018757
RE: View Query Taking more time

The presence of the keyword DISTINCT normally means that the code has failed to work with 1:1 relationships and so creates 1:many or many:many relationships. Another name for those relationships...
--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)

January 12, 2019 at 8:00 am

#2018754
RE: The Basics of iTVFs

The Dixie Flatline - Friday, January 11, 2019 8:31 PM
Jeff, you can write an ITVF that reads from a view, including...
--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)

January 12, 2019 at 7:13 am

#2018750

Viewing 15 posts - 10,051 through 10,065 (of 59,099 total)