Jeff Moden

Forum Replies Created

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

RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, January 15, 2019 9:54 PM
Okay, I only had two shots of Fireball Whiskey.
You should grab a couple...
--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 15, 2019 at 10:19 pm

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

Coozie - Tuesday, January 15, 2019 11:19 AM
Thanks for the reply, Jeff. This is just a simulation where I'm using a dummy...
--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 15, 2019 at 2:45 pm

#2019010
RE: Which index will perform better

Eliyahu - Tuesday, January 15, 2019 4:13 AM
I have a table with about 12M records. Between the columns, there is a datetime...
--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 15, 2019 at 7:27 am

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

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