Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,081 through 10,095 (of 59,099 total)

RE: Badly Trained AI

Rod at work - Thursday, January 10, 2019 2:56 PM
Eric M Russell - 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 10, 2019 at 9:54 pm

#2018659
RE: Month T-1

girl_bj - Thursday, January 10, 2019 7:14 PM
pietlinden - Thursday, January 10, 2019 7: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 10, 2019 at 9:50 pm

#2018658
RE: Month T-1

girl_bj - Thursday, January 10, 2019 9:01 AM
Jeff Moden - Thursday, January 10, 2019 8:57 AM
--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 10, 2019 at 9:41 am

#2018569
RE: New SQL Saturday presentation ideas?

How about one on strategic and tactical persuasion? Like how to persuade Ray K to learn more about T-SQL and SQL Server so he has more subject matter to choose...
--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 10, 2019 at 9:38 am

#2018568
RE: Badly Trained AI

xsevensinzx - Thursday, January 10, 2019 8:35 AM
Jeff Moden - Thursday, January 10, 2019 8:19 AM
--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 10, 2019 at 9:31 am

#2018564
RE: SQL Quiz

Heh... Changing times, indeed. It's seems that cheating on assignments/interviews has become the norm.
--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 10, 2019 at 9:24 am

#2018559
RE: Select convert to 2 decimal places, comma, right aligned

chad 62627 - Wednesday, January 9, 2019 10:01 AM
Jeff Moden - Tuesday, January 8, 2019 6:45 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 10, 2019 at 9:19 am

#2018558
RE: Files with larger disk consumption

So.... how do you find out what's causing the problem?
--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 10, 2019 at 9:11 am

#2018556
RE: Synonyms

t.franz - Thursday, January 10, 2019 12:55 AM
I think a problem with synonymes (as with several other "solutions") is SourceControl. When 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 10, 2019 at 9:02 am

#2018554
RE: Month T-1

girl_bj - Thursday, January 10, 2019 1:05 AM
Jeff Moden - Friday, December 21, 2018 6:24 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 10, 2019 at 8:57 am

#2018552
RE: The Basics of iTVFs

Great article on the Basics of iTVFs, Steve.
For those wondering about the performance of iTVFs that Steve mentioned, here's an article that discusses and demonstrates the performance advantage...
--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 10, 2019 at 8:37 am

#2018548
RE: The Basics of iTVFs

n.dreyer - Thursday, January 10, 2019 7:19 AM
Good article Steve
What would the benefit then be using an iTVFs instead of a View?...
--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 10, 2019 at 8:32 am

#2018546
RE: The Basics of iTVFs

From the article...
This was a major advance for T-SQL, but it didn't quite work out as well as Microsoft would have hoped.
I'll beg to differ... 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)

January 10, 2019 at 8:25 am

#2018540
RE: Badly Trained AI

Heh... AI... machine learning... When it comes to advertising on the net, someone is hitting the crack pipe pretty hard. I leased a new truck a year ago and immediately...
--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 10, 2019 at 8:19 am

#2018535
RE: Comparing tables names and structure

itmasterw 60042 - Wednesday, January 9, 2019 1:21 PM
Hi,
I have two tables which are very similar, and they would like to make...
--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 10, 2019 at 8:09 am

#2018530

Viewing 15 posts - 10,081 through 10,095 (of 59,099 total)