Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,941 through 11,955 (of 59,095 total)

RE: Phone Number Validation

Ah... what the heck. I kind of take things for granted including some of the goofy stuff NANPA did with the data in that download. It's been that way forever...
--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 4, 2018 at 6:23 pm

#1996345
RE: Phone Number Validation

N.B. - Wednesday, July 4, 2018 2:46 PM
Jeff Moden - Wednesday, July 4, 2018 7:10 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 4, 2018 at 3:14 pm

#1996339
RE: TSQL Showing improvement in values on different rows

dave 92282 - Wednesday, July 4, 2018 7:34 AM
I have been asked to write a report to show the improvements based on...
--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 4, 2018 at 1:45 pm

#1996326
RE: Data compression

river1 - Wednesday, July 4, 2018 12:42 PM
Thank you for your reply. We have a bi application that takes information from views...
--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 4, 2018 at 1:34 pm

#1996325
RE: stop delete trigger firing when i'm doing an "admin delete"

snomadj - Wednesday, July 4, 2018 10:17 AM
Because it's not just me that's going to be doing it.
Standard user group need to...
--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 4, 2018 at 1:31 pm

#1996324
RE: DevOps is Really Helpful

funbi - Tuesday, July 3, 2018 6:22 AM
Jeff Moden - Tuesday, July 3, 2018 6:08 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 4, 2018 at 1:07 pm

#1996321
RE: Efficient way to count distinct

ollyjolly - Wednesday, July 4, 2018 11:51 AM
As in a select of the 60 million rows without any DISTINCT or group by...
--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 4, 2018 at 12:58 pm

#1996320
RE: Efficient way to count distinct

The trouble is that you're grouping by 10 other columns. You also have no filter criteria and so you will be scanning either the entire table or a covering index...
--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 4, 2018 at 11:09 am

#1996316
RE: Efficient way to count distinct

ollyjolly - Tuesday, July 3, 2018 9:15 PM
As I was afraid....it looks like I am limited to SELECT permission. Attempted to create 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)

July 4, 2018 at 7:12 am

#1996301
RE: Phone Number Validation

Jeff Moden - Tuesday, July 3, 2018 11:49 AM
N.B. - Friday, June 29, 2018 12:51 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 4, 2018 at 7:10 am

#1996300
RE: Efficient way to count distinct

ollyjolly - Tuesday, July 3, 2018 6:50 PM
I am trying to come up with a more efficient method to count distinct values for two...
--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 3, 2018 at 8:36 pm

#1996241
RE: Phone Number Validation

N.B. - Friday, June 29, 2018 12:51 PM
Greetings,
I'm working on a project where we have to take a list of unique phone...
--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 3, 2018 at 11:49 am

#1996206
RE: Importing Tricky CSV Files with PowerShell

Stewart "Arturius" Campbell - Monday, July 2, 2018 11:04 PM
Comments posted to this topic are about the item Importing Tricky CSV...
--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 3, 2018 at 8:59 am

#1996168
RE: Importing Tricky CSV Files with PowerShell

Jerry Kelk - Tuesday, July 3, 2018 2:43 AM
This has been a personal annoyance for years.
Surely, the import engine should properly respect...
--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 3, 2018 at 8:25 am

#1996160
RE: After Insert trigger

Arsh - Tuesday, July 3, 2018 2:19 AM
Arsh - Sunday, July 1, 2018 12:01 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 3, 2018 at 6:22 am

#1996121

Viewing 15 posts - 11,941 through 11,955 (of 59,095 total)