Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,061 through 15,075 (of 59,097 total)

RE: IoT Pros and Cons

Eric M Russell - Friday, May 5, 2017 10:40 AM
Also, your concerns about swarms of militarized flesh eating robots are well founded;...
--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)

May 5, 2017 at 11:30 pm

#1941412
RE: Are the posted questions getting worse?

jonathan.crawford - Friday, May 5, 2017 7:41 AM
question that I'd appreciate everyone's input on, but particularly Mr. Moden's, since it's his fault,...
--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)

May 5, 2017 at 9:47 pm

#1941411
RE: Drop/Create objects versus Alter

John Mitchell-245523 - Friday, May 5, 2017 7:47 AM
One thing that combines the best of both worlds is to test for existence,...
--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)

May 5, 2017 at 9:29 pm

#1941410
RE: Are the posted questions getting worse?

drew.allen - Friday, May 5, 2017 3:57 PM
Had an interview this morning that went so well, they decided to skip the in-person...
--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)

May 5, 2017 at 9:02 pm

#1941409
RE: Are the posted questions getting worse?

Chad Crawford - Friday, May 5, 2017 12:56 PM
ThomasRushton - Thursday, May 4, 2017 7:23 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)

May 5, 2017 at 8:03 pm

#1941406
RE: How to build a field name in a select statement

GilaMonster - Friday, May 5, 2017 3:26 AM
anthony.green - Friday, May 5, 2017 2:52 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)

May 5, 2017 at 7:13 am

#1941280
RE: No PKs on fact tables

RonKyle - Friday, May 5, 2017 6:09 AM
I DO understand your point of view
That makes you smarter than me because...
--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)

May 5, 2017 at 7:11 am

#1941279
RE: Copy data from flat file with multiple headers

Eirikur Eiriksson - Friday, May 5, 2017 5:15 AM
pwalter83 - Friday, May 5, 2017 5:04 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)

May 5, 2017 at 6:54 am

#1941266
RE: Copy data from flat file with multiple headers

pwalter83 - Friday, May 5, 2017 5:04 AM
Hi,
I am trying to copy data from a flat file (CSV) which has multiple headers...
--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)

May 5, 2017 at 6:53 am

#1941264
RE: Are the posted questions getting worse?

Brandie Tarvin - Friday, May 5, 2017 4:37 AM
The coworker and I were talking this a.m. about how annoyed we are that...
--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)

May 5, 2017 at 6:50 am

#1941263
RE: IoT Pros and Cons

I was reading some articles and viewing some YouTubes on "Killer Robots" that many militaries already have in place. It's making war quite "sanitary" instead of the dirty, ugly, 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)

May 5, 2017 at 6:39 am

#1941255
RE: There is insufficient system memory to run this query.

drew.allen - Thursday, May 4, 2017 12:26 PM
Jeff Moden - Thursday, May 4, 2017 11:54 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)

May 5, 2017 at 6:12 am

#1941247
RE: No PKs on fact tables

xsevensinzx - Thursday, May 4, 2017 1:12 PM
The goalkeeper is still the code and the SQL Server as no one has...
--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)

May 5, 2017 at 6:02 am

#1941244
RE: Calculating age

ELSSON - Thursday, May 4, 2017 2:46 PM
Is most simple:
DECLARE @Birthday date = '1994/12/10'
SELECT (CAST(CONVERT(VARCHAR(8), GETDATE(), 112) AS INT) - CAST(CONVERT(VARCHAR(8), @Birthday,...
--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)

May 5, 2017 at 5:53 am

#1941243
RE: COMPUTED COLUMN needing to retain value

John Mitchell-245523 - Friday, May 5, 2017 2:01 AM
Jeff Moden - Thursday, May 4, 2017 12:08 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)

May 5, 2017 at 5:25 am

#1941238

Viewing 15 posts - 15,061 through 15,075 (of 59,097 total)