Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,076 through 12,090 (of 59,095 total)

RE: Computed columns best practices.

As always, "It Depends". What will the computed columns be doing?
--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)

June 18, 2018 at 2:09 pm

#1994365
RE: Duplicates

Since this is predominately an SQL Server platform but mixed with 3 others, it would be nice if such questions identified which platform or app is actually being used.
--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)

June 18, 2018 at 2:07 pm

#1994364
RE: Authentication

90% of the time, the answer is the 3rd one out of 4. 😀
--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)

June 18, 2018 at 2:02 pm

#1994363
RE: Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Eric M Russell - Monday, June 18, 2018 1:23 PM
Jeff Moden - Monday, June 18, 2018 8:51...
--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)

June 18, 2018 at 1:54 pm

#1994360
RE: Jobs You Wouldn't Expect To Be Threatened By Tech But Are

gendersense - Monday, June 18, 2018 6:27 AM
What skills other than becoming like a robot should an IT tech get?
Something that most...
--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)

June 18, 2018 at 1:00 pm

#1994349
RE: SSRS 2016 - HTML5 rendering issues

Julien Maillard - Monday, June 18, 2018 7:50 AM
Thom A - Sunday, June 17, 2018 3:55 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)

June 18, 2018 at 11:22 am

#1994333
RE: The Data Submarine

ganotedp - Monday, June 18, 2018 6:47 AM
Microsoft is "getting into hot water"? Learning to "boil the ocean"? 😛
Heh... yeah... it's a...
--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)

June 18, 2018 at 9:14 am

#1994309
RE: High CPU during specific timings

You have a stored procedure that runs 300 times per minute? Unless that stored procedure is responding to a GUI for individual customer requests, I'm thinking that's actually a serious...
--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)

June 18, 2018 at 9:11 am

#1994307
RE: Archiving database in SQL Server 2008 R2 Standard

Create one database for each month using an extension of _YYYYMM as a part of the database name. The "table" in each of these databases can be the same name...
--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)

June 18, 2018 at 9:08 am

#1994306
RE: Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Eric M Russell - Monday, June 18, 2018 8:25 AM
It's no surprise that, after manufacturing, customer service would be the next industry...
--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)

June 18, 2018 at 8:51 am

#1994302
RE: Providing Feedback to Speakers

"I don’t like the speaker’s choice of shirt"
My understanding is that Steve Jones get's that complaint a lot. 😀
Seriously... good article. Thanks for taking the time...
--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)

June 18, 2018 at 8:46 am

#1994300
RE: Help needed on TSQL query: update using a self join

This request just doesn't seem right. I don't know why anyone would actually need to do this but my initial impression is that it's on the edge of "data tampering".
--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)

June 18, 2018 at 8:30 am

#1994296
RE: Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Victor Kirkpatrick - Monday, June 18, 2018 4:40 AM
There has to be a balance here. I mean, if automation will put so...
--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)

June 18, 2018 at 8:24 am

#1994294
RE: Entering random data into a table

Junior GalvÃ£o - MVP - Sunday, June 17, 2018 6:46 PM
Hi Jeff,
I understand and accept your words,...
--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)

June 17, 2018 at 7:08 pm

#1994228
RE: Entering random data into a table

Junior GalvÃ£o - MVP - Sunday, June 17, 2018 5:11 PM
Junior GalvÃ£o - MVP - Sunday, June...
--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)

June 17, 2018 at 6:14 pm

#1994226

Viewing 15 posts - 12,076 through 12,090 (of 59,095 total)