Jeff Moden

Forum Replies Created

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

RE: how to deploy 10 T-SQL scripts across 200 databases

premkumardr - Tuesday, August 1, 2017 5:26 PM
sqlguy80 - Tuesday, July 25, 2017 12:37 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)

August 2, 2017 at 8:42 am

#1953785
RE: Help me hate PowerShell a little less, please.

Jeff Moden - Wednesday, August 2, 2017 8:31 AM
Thom A - Wednesday, August 2, 2017 2: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)

August 2, 2017 at 8:38 am

#1953784
RE: Help me hate PowerShell a little less, please.

Thom A - Wednesday, August 2, 2017 2:19 AM
ActiveDirectory is NOT part of of the standard install of PowerShell, instead...
--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 2, 2017 at 8:31 am

#1953781
RE: High level performance report aimed at senior management

lassell - Friday, July 21, 2017 3:47 PM
Hi all,
I've been in the SQL space for a number of years now and recently...
--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 1:56 pm

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

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