Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,431 through 11,445 (of 59,095 total)

RE: Is it possible to retrieve name(s) of SSIS package(s) that have an Exec SQL task that executes a specific SP?

VoldemarG - Thursday, August 23, 2018 3:03 PM
True. but there are 1100 packages on 3 prod servers... 🙂
Heh... Phil wasn't suggesting 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)

August 23, 2018 at 3:29 pm

#2003117
RE: Count the Number of Weekend Days between Two Dates

carsten.saastamoinen - Thursday, August 23, 2018 9:54 AM
"Every bit helps avoid the "Death by 1,000 cuts" that so many systems experience. ...
--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)

August 23, 2018 at 11:02 am

#2003084
RE: Count the Number of Weekend Days between Two Dates

csj - Thursday, August 23, 2018 7:55 AM
But use of memory for the recursive solution is not a problem until someone uses that...
--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)

August 23, 2018 at 8:11 am

#2003058
RE: Count the Number of Weekend Days between Two Dates

csj - Thursday, August 23, 2018 7:31 AM
One of the big problems when we are writing SELECT statement is, that there is...
--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)

August 23, 2018 at 7:48 am

#2003051
RE: File sizes in system tables

elea.grig - Thursday, August 23, 2018 6:48 AM
I am querying select * from sys.master_files in order to know the file sizes...
--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)

August 23, 2018 at 7:34 am

#2003047
RE: Sanity check

HappyGeek - Wednesday, August 22, 2018 11:59 AM
Even if you had a tried and proven method of managing file growth, would 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)

August 23, 2018 at 7:30 am

#2003045
RE: Count the Number of Weekend Days between Two Dates

While I don't necessarily agree with the way things were done in the article, I have to tell you that I never agree with any form of recursion even 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)

August 23, 2018 at 7:10 am

#2003040
RE: Count the Number of Weekend Days between Two Dates

csj - Thursday, August 23, 2018 1:29 AM
Why do it in such a complex way. Use recursion, which also is faster 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)

August 23, 2018 at 6:50 am

#2003036
RE: Huge number of tables

JackCarrington - Thursday, August 23, 2018 1:00 AM
Jeff Moden - Friday, August 17, 2018 6: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)

August 23, 2018 at 6:45 am

#2003035
RE: Insert new records from one database to another using SSIS

Why not "just" use replication or log shipping for this?
--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)

August 22, 2018 at 4:57 pm

#2002961
RE: Checking my knowledge

Grant Fritchey - Wednesday, August 22, 2018 11:57 AM
john_laspada - Wednesday, August 22, 2018 10: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)

August 22, 2018 at 12:21 pm

#2002903
RE: Data Has a Dollar Value

Steve Jones - SSC Editor - Tuesday, August 21, 2018 9:11 AM
Absolutely, which is where the advanced researchers are working 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)

August 22, 2018 at 11:26 am

#2002884
RE: Checking my knowledge

Why not just buy another drive so that you have some headroom to archive/delete a lot of the junk you know you don't need and maybe rebuild some indexes that...
--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)

August 22, 2018 at 11:14 am

#2002881
RE: Rebuilding Indexes

yoyodynedata - Tuesday, August 21, 2018 11:38 AM
How do you determine how often you need to rebuild your indexes?
You'll end up getting...
--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)

August 22, 2018 at 8:27 am

#2002843
RE: How much RAM required to server

Vinayak15580 - Wednesday, August 22, 2018 4:48 AM
Dear All Thank you for your inputs. Its really helpful to me.
I have set 8...
--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)

August 22, 2018 at 7:29 am

#2002833

Viewing 15 posts - 11,431 through 11,445 (of 59,095 total)