Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,066 through 10,080 (of 59,102 total)

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
RE: SQL getting locked up - Important please help!

sizal0234 - Thursday, January 10, 2019 2:24 PM
Hi,
In the past week, we had to reboot sql server to make it come 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)

January 11, 2019 at 1:51 pm

#2018731
RE: Recommendations for "phasing out" of local SQL backups for NetApp SNAPS

Toddmonster85 - Thursday, January 10, 2019 10:44 AM
We're having a debate regarding administration of SQL server backups.
Recently we've started using NetApp SnapCenter...
--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:30 pm

#2018729
RE: Evolving Our Tools

Heh... you learn all those wonderful tools and begin to rely on them. Then, something happens and you end up at a new company and you're dead because 1) they...
--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:15 pm

#2018724
RE: Badly Trained AI

robert.sterbal 56890 - Friday, January 11, 2019 7:53 AM
Jeff Moden - Thursday, January 10, 2019 9:54 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 8:05 am

#2018702
RE: Files with larger disk consumption

Junior GalvÃ£o - MVP - Friday, January 11, 2019 6:49 AM
Jeff Moden - Thursday, January 10, 2019...
--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 8:00 am

#2018700
RE: New SQL Saturday presentation ideas?

Grant Fritchey - Friday, January 11, 2019 6:37 AM
It doesn't matter that you're not an MVP or whatever. You can teach beginners...
--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 7:46 am

#2018697

Viewing 15 posts - 10,066 through 10,080 (of 59,102 total)