Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,716 through 14,730 (of 59,101 total)

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
RE: How to SELECT * INTO [temp table] FROM [Stored Procedure]?

Also, sp_who2 returns 2 columns named "SPID" and that will cause an error during the SELECT INTO.
--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:44 am

#1952086
RE: Installing SSIS alongside Current SQL Instance

The real question is, why do you think you need SSIS? What will you actually be using it for? It may be that you don't actually need SSIS to do...
--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 5:39 am

#1952042
RE: Time difference

I'll also ask the question of, is there any guarantee that for every "I", there will be a related "O" and vice versa?
--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 5:35 am

#1952041
RE: Concatenate rows into string

Alan.B - Thursday, July 20, 2017 7:30 AM
DesNorton - Thursday, July 20, 2017 5:29 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)

July 21, 2017 at 5:28 am

#1952040
RE: Are the posted questions getting worse?

Brandie Tarvin - Friday, July 21, 2017 4:23 AM
Two things...
1) Y'all are WEIRD.
2) Thank goodness that y'all are weird. It makes me...
--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 5:21 am

#1952035
RE: SSMS is Free

I hate the fact that neither SSMS or Books Online comes with SQL Server anymore.
--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 20, 2017 at 8:15 pm

#1951994
RE: Microsoft SQL Server Utilities and Tools

robert.sterbal 56890 - Thursday, July 20, 2017 7:54 AM
I've decided to try to put up a wiki on Github. I may move...
--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 20, 2017 at 12:16 pm

#1951941
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, July 20, 2017 9:34 AM
Jason A. Long - Thursday,...
--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 20, 2017 at 12:09 pm

#1951937
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, July 19, 2017 12:32 PM
Ed Wagner - Wednesday, July 19, 2017 10:43 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)

July 20, 2017 at 8:55 am

#1951867
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, July 19, 2017 1:51 PM
Lynn Pettis - Wednesday, July 19, 2017 1:33 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 20, 2017 at 8:42 am

#1951864
RE: Are the posted questions getting worse?

Lynn Pettis - Wednesday, July 19, 2017 1:33 PM
Jeff Moden - Wednesday, July 19, 2017 1:27 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 20, 2017 at 8:39 am

#1951862

Viewing 15 posts - 14,716 through 14,730 (of 59,101 total)