Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,701 through 14,715 (of 59,097 total)

RE: Reseed one table column

Lynn Pettis - Friday, July 21, 2017 2:09 PM
Jeff Moden - Friday, July 21, 2017 2:06 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 22, 2017 at 5:47 pm

#1952250
RE: Function vs Procedure

Luis Cazares - Friday, July 21, 2017 2:24 PM
Jeff Moden - Friday, July 21, 2017 1:59 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 22, 2017 at 5:34 pm

#1952249
RE: How to better join my queries and prevent usage of functions

ScottPletcher - Friday, July 21, 2017 7:14 AM
I'll give it a guess. Typically now you use OUTER APPLY to do the type...
--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 21, 2017 at 7:18 pm

#1952227
RE: update column based on max date for each employee

jcelko212 32090 - Thursday, July 20, 2017 9:50 AM
A table models a set of entities, so it's name should be...
--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 21, 2017 at 7:16 pm

#1952226
RE: Looking Back

ZZartin - Friday, July 21, 2017 8:42 AM
I've also never seen a case for case insensitive 😀
1. Lack of design standards...
--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 21, 2017 at 6:19 pm

#1952225
RE: Generating Non-uniform Random Numbers with SQL

Apparently, PhotoBucket changed something on their site. The missing graphics for Dwain's article may be found at the following link.
http://s1252.photobucket.com/user/dwaincamps/library/Random%20Numbers?sort=3&page=1
p.s. Miss ya, Buddy. You were...
--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 21, 2017 at 6:05 pm

#1952224
RE: Moving table with Encrypted column to different server

DougGifford - Friday, November 5, 2010 11:39 AM
This link helped solve my problem!http://www.eggheadcafe.com/software/aspnet/30238935/master-key-issue.aspx
This is what I hate about links... that link is...
--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 21, 2017 at 4:48 pm

#1952222
RE: Looking Back

Steve Jones - SSC Editor - Friday, July 21, 2017 12:12 PM
archie flockhart - Friday, July 21,...
--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 21, 2017 at 2:16 pm

#1952208
RE: Looking Back

Steve Jones - SSC Editor - Friday, July 21, 2017 12:16 PM
KGERBR - Friday, July 21, 2017...
--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 21, 2017 at 2:13 pm

#1952207
RE: Reseed one table column

Lynn Pettis - Friday, July 21, 2017 1:16 PM
Just going to ignore my question?
He did explain that his IDENTITY column was approaching...
--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 21, 2017 at 2:06 pm

#1952205
RE: Function vs Procedure

Luis Cazares - Friday, July 21, 2017 10:09 AM
This is one of the questions I ask while interviewing people for a SQL...
--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 21, 2017 at 1:59 pm

#1952203
RE: Function vs Procedure

SQL-DBA-01 - Friday, July 21, 2017 8:00 AM
Using a stored procedure will greatly reduce that traffic because the stored...
--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 21, 2017 at 10:02 am

#1952137
RE: Looking Back

From the article:
One of the things I do lament is the declining quality of documentation.
Not only documentation but I also lament the serious decline...
--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 21, 2017 at 8:23 am

#1952105
RE: SSMS is Free

Eric M Russell - Friday, July 21, 2017 7:23 AM
Jeff Moden - Thursday, July 20, 2017 8:15...
--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 21, 2017 at 7:56 am

#1952096
RE: Function vs Procedure

SQL-DBA-01 - Friday, July 21, 2017 7:38 AM
Hi All,
Happy Friday to All.
Is this a good practice to write functions with 1000+ lines....
--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 21, 2017 at 7:48 am

#1952091

Viewing 15 posts - 14,701 through 14,715 (of 59,097 total)