Jeff Moden

Forum Replies Created

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

RE: Programatically change the time of a schedule

Guy Bloch - Friday, July 6, 2018 2:17 PM
Hello All,
We are using ssrs 2016..
We have approx 20 different schedules.
The Daily one for...
--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:09 pm

#1996641
RE: Can I run a VBS script in a scheduled SQL Job?

Alejandro Santana - Friday, July 6, 2018 11:49 AM
I think using the SQL Server Agent to run stuff that don't belong...
--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 1:20 pm

#1996622
RE: Ola Hallengren's Maintenance question

sqlfriends - Friday, July 6, 2018 9:54 AM
She is working to setup a content manage system with a vendor off hour. 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 6, 2018 at 12:08 pm

#1996600
RE: Dilemma between Microsoft BI developer or Application Developer

j1devop - Wednesday, July 4, 2018 8:57 PM
I find myself literally the same situation - wondering which direction was taken.
Like Yogi Berra said, "When...
--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:39 am

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

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