Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,691 through 9,705 (of 59,099 total)

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
RE: Dealing with Technical Debt

RonKyle - Wednesday, March 13, 2019 2:21 PM
Why do so many people think that "doing it right" is at odds with...
--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 13, 2019 at 5:57 pm

#2024393
RE: Dealing with Technical Debt

David.Poole - Wednesday, March 13, 2019 9:56 AM
RonKyle - Wednesday, March 13, 2019 7:30 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 13, 2019 at 2:16 pm

#2024372
RE: trimming SSNs

Another damnable company that has SSNs in clear text. :crazy:
--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 13, 2019 at 2:03 pm

#2024370
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Tuesday, March 12, 2019 3:04 PM
If any of you are interested, we'd love some new articles...
--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 12, 2019 at 10:00 pm

#2024286
RE: Sql Query to find invalid SSN Numbers

glenn.rollins3 - Tuesday, March 12, 2019 11:36 AM
Jeff Moden - Tuesday, March 12, 2019 11:11 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 12, 2019 at 12:00 pm

#2024255
RE: Dealing with Technical Debt

From the article:
Just like financial debt, not all technical debt is bad.

Actually, it's bad on both counts. You always end up paying much more...
--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 12, 2019 at 11:54 am

#2024254
RE: Performance Issue

DBA_007 - Tuesday, March 12, 2019 9:08 AM
Grant Fritchey - Tuesday, March 12, 2019 8:53 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 12, 2019 at 11:19 am

#2024247

Viewing 15 posts - 9,691 through 9,705 (of 59,099 total)