Jeff Moden

Forum Replies Created

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

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
RE: Badly Trained AI

Eric M Russell - Friday, January 11, 2019 3:03 PM
drew.allen - Friday, January 11, 2019 2:20 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 11, 2019 at 5:44 pm

#2018742
RE: The SQL Saturday Thread

I went to Pittsburgh with my "Black Arts" Index Maintenance sessions and had a great turnout. Thanks to all the hardworking folks that put that wonderful SQLSaturday together.
I've...
--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 11, 2019 at 5:29 pm

#2018741
RE: SQL getting locked up - Important please help!

sizal0234 - Friday, January 11, 2019 2:05 PM
I appreciate everyone's help as always. I ran couple of performance reports and found memory...
--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 11, 2019 at 2:48 pm

#2018738
RE: Rank Table Sales Setup with Sale

angelreynosog - Friday, January 11, 2019 1:21 PM
ScottPletcher - Thursday, January 10, 2019 3:05 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 11, 2019 at 2:11 pm

#2018735
RE: Badly Trained AI

What's really sickening is that some companies now require people with a Masters Degree in computer science to be even a Database Developer and think that's the right kind of filter and...
--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 11, 2019 at 2:07 pm

#2018734
RE: Badly Trained AI

Matt Miller (4) - Friday, January 11, 2019 1:37 PM
Most likely because Jeff measures "success" based on different criteria than 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 11, 2019 at 1:55 pm

#2018732

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