Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,926 through 11,940 (of 59,095 total)

RE: Ola Hallengren's Maintenance question

sqlfriends - Monday, June 25, 2018 2:21 PM
Thanks, I checked in the job we do set up to log into the table.
And...
--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 6, 2018 at 8:21 am

#1996548
RE: How do I have dbo?

james.smith3 - Wednesday, July 4, 2018 2:32 AM
I've been trying to work out for hours how I have permission to use 'dbo'.
-...
--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 6, 2018 at 8:12 am

#1996543
RE: Script out EXISTING database mail profile's settings

Subhash Chandra - Friday, July 6, 2018 12:54 AM
Hi Jeff,
Thanks for your comments, I think its Individual choice and way of...
--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 6, 2018 at 7:46 am

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

ScottPletcher - Thursday, July 5, 2018 9:07 AM
Jeff Moden - Thursday, July 5, 2018 8:51 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 5, 2018 at 11:18 pm

#1996483
RE: Efficient way to count distinct

ScottPletcher - Thursday, July 5, 2018 9:09 AM
Jeff Moden - Thursday, July 5, 2018 8:48 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 5, 2018 at 11:15 pm

#1996482
RE: Who Likes NULL?

I like NULLs for a lot of things and you can do some great tricks with them in calculations and selection of alternate data. However, and as with all else...
--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 10:38 pm

#1996481
RE: Importing Tricky CSV Files with PowerShell

Bruin - Thursday, July 5, 2018 7:46 PM
Is there a way to force a value(N/A) to a SQL field defined for 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)

July 5, 2018 at 9:58 pm

#1996480
RE: Importing Tricky CSV Files with PowerShell

David Rueter - Thursday, July 5, 2018 11:23 AM
Jeff Moden - Thursday, July 5, 2018 7:34 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 5, 2018 at 9:55 pm

#1996479
RE: Difference between minimum and maximum value

jcelko212 32090 - Thursday, July 5, 2018 7:29 PM
The first thing we need to do is correct your DDL. #Temp is 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)

July 5, 2018 at 9:44 pm

#1996478
RE: Pivot dynamic column names

tshad - Thursday, July 5, 2018 5:03 PM
I was wondering if there was a way to do this without dynamic sql?
[code...
--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 9:36 pm

#1996476
RE: Are the posted questions getting worse?

jasona.work - Thursday, July 5, 2018 1:32 PM
Well, today is the first of two days off before the weekend, then next week...
--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 9:33 pm

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

Viewing 15 posts - 11,926 through 11,940 (of 59,095 total)