Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,676 through 9,690 (of 59,091 total)

RE: Building Better Stored Procedures

astruthers 75845 - Thursday, March 14, 2019 9:26 PM
Jeff,
Just tested, and stand by what I said.
-- Comments before Create\Alter statement
CREATE PROCEDURE sp_Bletch
@BrandID...
--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)

March 14, 2019 at 10:35 pm

#2024528
RE: DBA Job interview question thoughts

peter_parker - Tuesday, March 12, 2019 3:50 PM
Just out of curiosity how big a whiff would you consider not knowing the difference...
--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)

March 14, 2019 at 10:18 pm

#2024527
RE: The Soft Skill of Respect

What your great article ultimately describes (IMHO) is a properly implemented DevOps culture, which has been mistaken by most and demoted to mean a set of tools. I take 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)

March 14, 2019 at 9:50 pm

#2024526
RE: Sql Query to find invalid SSN Numbers

Sean Lange - Tuesday, March 12, 2019 1:03 PM
Jeff Moden - Tuesday, March 12, 2019 12:00 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)

March 14, 2019 at 9:34 pm

#2024525
RE: Sql Query to find invalid SSN Numbers

roger.plowman - Wednesday, March 13, 2019 6:49 AM
Of course, you could always take the brute force approach. 🙂
Create a table with all...
--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)

March 14, 2019 at 9:29 pm

#2024524
RE: Dealing with Technical Debt

Steve Jones - SSC Editor - Thursday, March 14, 2019 11:39 AM
There are definitely issues with management, but there is also 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)

March 14, 2019 at 9:26 pm

#2024522
RE: Building Better Stored Procedures

astruthers 75845 - Thursday, March 14, 2019 2:24 PM
In your example, those notes that come BEFORE the ALTER\CREATE statement are lost.
That's not...
--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)

March 14, 2019 at 9:08 pm

#2024521
RE: Query produces incorrect results

meryemkurs072 - Thursday, March 14, 2019 3:06 PM
Hello
I am working on a complex problem
There is a problem with the query
DECLARE...
--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)

March 14, 2019 at 9:02 pm

#2024519
RE: trimming SSNs

jcelko212 32090 - Thursday, March 14, 2019 8:19 PM
ScottPletcher - Thursday, March 14, 2019 3:01 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)

March 14, 2019 at 8:37 pm

#2024518
RE: trimming SSNs

jcelko212 32090 - Thursday, March 14, 2019 1:44 PM
briancampbellmcad - Wednesday, March 13, 2019 9:50 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)

March 14, 2019 at 8:31 pm

#2024517
RE: Dealing with Technical Debt

Steve Jones - SSC Editor - Thursday, March 14, 2019 8:35 AM
Matt Miller (4) - Wednesday, March...
--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)

March 14, 2019 at 9:33 am

#2024466
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Wednesday, March 13, 2019 8:33 AM
Not sure what happened, but I don't see a draft in...
--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)

March 14, 2019 at 9:09 am

#2024459
RE: Loading CSV file into Multiple tables

poratips - Wednesday, March 13, 2019 8:24 PM
Hi,
I have to load the data from .csv file into few sql server tables which...
--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)

March 14, 2019 at 9:07 am

#2024458
RE: Building Better Stored Procedures

@steve-2 Jones...
Real nice article, Steve, especially on the importance of properly commenting code and the inference that it should also be properly structured (first letter of SQL, right? :D) ...
--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)

March 14, 2019 at 8:12 am

#2024450
RE: Building Better Stored Procedures

jonathan.crawford - Thursday, March 14, 2019 7:20 AM
Andy Warren - Thursday, March 14, 2019 6:49 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)

March 14, 2019 at 7:49 am

#2024446

Viewing 15 posts - 9,676 through 9,690 (of 59,091 total)