Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,266 through 11,280 (of 59,095 total)

RE: Allowing developers ability to administer SQL Agent jobs in production

ZZartin - Friday, September 7, 2018 8:07 AM
Jeff Moden - Friday, September 7, 2018 7:46 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)

September 7, 2018 at 10:44 am

#2004919
RE: Export and Import 214 tables

jbecker 27503 - Friday, September 7, 2018 9:55 AM
Hi guys I inherited a process in which extracts changes from 214 tables 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)

September 7, 2018 at 10:38 am

#2004917
RE: Are the posted questions getting worse?

Grant Fritchey - Friday, September 7, 2018 8:50 AM
There are two tiers to the certs. Those who have them because they...
--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)

September 7, 2018 at 10:18 am

#2004914
RE: Allowing developers ability to administer SQL Agent jobs in production

ZZartin - Friday, September 7, 2018 7:39 AM
It really depends on your organization and just how often these kind of situations arise,...
--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)

September 7, 2018 at 7:46 am

#2004864
RE: Allowing developers ability to administer SQL Agent jobs in production

doodlingdba - Friday, September 7, 2018 3:39 AM
Hi all
Trying to get an idea of what people are doing out in the industry...
--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)

September 7, 2018 at 7:34 am

#2004859
RE: Are the posted questions getting worse?

Brandie Tarvin - Friday, September 7, 2018 5:07 AM
xsevensinzx - Friday, September 7, 2018 4:59 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)

September 7, 2018 at 6:35 am

#2004840
RE: script to set all user database to simple recovery model

It would appear that the purpose of all this scripts is to shrink the log file for any database not in the SIMPLE recovery model. I see several shortcomings 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)

September 7, 2018 at 6:22 am

#2004837
RE: Are the posted questions getting worse?

TomThomson - Thursday, September 6, 2018 3:32 PM
What set me off, Sean, was blaming the academics and not pointing out...
--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)

September 6, 2018 at 5:32 pm

#2004782
RE: Index on a computed column

Sean Lange - Thursday, September 6, 2018 1:41 PM
Jeff Moden - Thursday, September 6, 2018 1:07 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)

September 6, 2018 at 5:17 pm

#2004779
RE: Index on a computed column

Sean Lange - Thursday, September 6, 2018 10:35 AM
Jeff Moden - Thursday, September 6, 2018 9:22 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)

September 6, 2018 at 1:07 pm

#2004762
RE: SQL jobs interfering with eachother

TJDBA - Thursday, September 6, 2018 3:59 AM
mark.humphreys - Thursday, September 6, 2018 3:38 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)

September 6, 2018 at 9:29 am

#2004733
RE: Profiling spikes in query duration

Long shot but are the stats up to date for what the loop uses? Also, it is possible that you're suffering from a bit of bad parameter sniffing for certain...
--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)

September 6, 2018 at 9:26 am

#2004732
RE: Index on a computed column

Kind of a bad "correct" answer. The reason why it can't be used in an index is because it's indeterminate and whatever reason you chose, the end of it all...
--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)

September 6, 2018 at 9:22 am

#2004730
RE: Creating Subtotals and Totals in Aggregated Queries

You shouldn't rely on NULLs for the detection of totals and subtotals because some of the groups can be based on an aggregate of things that have NULL "labels". You...
--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)

September 6, 2018 at 9:16 am

#2004729
RE: Automate date to always show current Tuesday

Sergiy - Thursday, September 6, 2018 8:02 AM
Zero date is Monday.
To get Tuesday we need to add 1 day to zero date:
--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)

September 6, 2018 at 8:48 am

#2004719

Viewing 15 posts - 11,266 through 11,280 (of 59,095 total)