Jeff Moden

Forum Replies Created

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

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

ScottPletcher - Thursday, July 5, 2018 8:24 AM
To answer the original q, yes, there is a very easy way to "tell" the...
--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 5, 2018 at 8:51 am

#1996410
RE: Efficient way to count distinct

ScottPletcher - Thursday, July 5, 2018 8:30 AM
Before loading the #Paid table, cluster it on all the GROUP BY columns:
Yr
,YrMnth
...
--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 5, 2018 at 8:48 am

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

snomadj - Thursday, July 5, 2018 1:51 AM
Sue / Jeff, you're both quite right.
We have no test system & no chance...
--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 5, 2018 at 7:39 am

#1996389
RE: Importing Tricky CSV Files with PowerShell

Bruin - Thursday, July 5, 2018 4:05 AM
"Creating specific datatypes for the datatable's columns is another exercise altogether, though I would 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 5, 2018 at 7:34 am

#1996387
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

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