Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,656 through 14,670 (of 59,097 total)

RE: Who's Smarter? Humans or AI Systems?

Steve Jones - SSC Editor - Tuesday, August 1, 2017 9:54 AM
Jeff Moden - Monday, July 31,...
--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)

August 1, 2017 at 11:53 am

#1953646
RE: Who's Smarter? Humans or AI Systems?

David.Poole - Tuesday, August 1, 2017 12:23 AM
Of course, it failed that basic "Turing Test" by asking me why I wanted to...
--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)

August 1, 2017 at 9:45 am

#1953617
RE: Who's Smarter? Humans or AI Systems?

patrickmcginnis59 10839 - Monday, July 31, 2017 7:21 AM
Jeff Moden - Friday, July 28, 2017 3:57 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)

July 31, 2017 at 7:14 pm

#1953501
RE: Who's Smarter? Humans or AI Systems?

According to the Merriam-Webster dictionary, my personal definition of AI is incorrect and you are correct. Apparently, a machine doesn't actually have to have any form of even simple self-learning...
--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)

July 31, 2017 at 6:06 pm

#1953496
RE: Who's Smarter? Humans or AI Systems?

Steve Jones - SSC Editor - Monday, July 31, 2017 12:30 PM
Jeff Moden - Monday, July 31,...
--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)

July 31, 2017 at 5:08 pm

#1953490
RE: Changing type from INT to BIGINT why so slow?

leehbi - Monday, July 31, 2017 9:00 AM
Right. So to avoid the 1 row value overwriting the next the data has to...
--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)

July 31, 2017 at 11:33 am

#1953439
RE: Who's Smarter? Humans or AI Systems?

Steve Jones - SSC Editor - Monday, July 31, 2017 8:52 AM
Jeff Moden - Friday, July 28,...
--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)

July 31, 2017 at 11:01 am

#1953432
RE: Notification if any plan changes against any specific table/procedure

SQL-DBA-01 - Saturday, July 29, 2017 1:42 PM
Hello,
Is there anyway I can get notified if there is any new plan in place...
--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)

July 30, 2017 at 2:12 pm

#1953307
RE: Backup DB as a bak file type?

The "File of Type: Selected option: (*bak,*tm)" option isn't an "option". It simply controls what to display. If you want your file to have a ".bak" extension, YOU have to...
--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)

July 30, 2017 at 2:02 pm

#1953306
RE: Are the posted questions getting worse?

Brandie Tarvin - Thursday, July 27, 2017 9:08 AM
WHOO HOO! Go women in TECH!
We had a resume that reminded me of mine...
--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)

July 29, 2017 at 2:49 pm

#1953290
RE: Cursor Performance

burfos - Wednesday, July 26, 2017 6:46 PM
I don't disagree but... vendor app. If I could rewrite their tables\queries and get rid...
--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)

July 29, 2017 at 12:07 pm

#1953289
RE: SQLCMD and Batch File magic

As a bit of a sidebar, I'd never use a user name and password to connect to the server because they leave your stuff in a batch file in clear...
--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)

July 29, 2017 at 11:53 am

#1953288
RE: SQLCMD and Batch File magic

schleep - Thursday, November 19, 2015 6:03 AM
Try this in Powershell: this basic functionality is relatively simple to learn.You'll never go back...
--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)

July 29, 2017 at 11:43 am

#1953287
RE: Synonyms causing performance issue - database on same server

Heh... it's always the code. 😉 Thanks for the feedback. I just couldn't imagine it being the simple use of synonyms that was 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)

July 29, 2017 at 10:27 am

#1953285
RE: Powershell script transfers entire directory?

Brandie Tarvin - Thursday, July 27, 2017 5:33 AM
Jeff Moden - Monday, July 24, 2017 7:23 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)

July 29, 2017 at 10:24 am

#1953284

Viewing 15 posts - 14,656 through 14,670 (of 59,097 total)