Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,516 through 4,530 (of 59,069 total)

Reply To: Moving SSISDB Catalog from 2012 to 2014

Kunal Rathi wrote:
You could try SSIS Catalog Migration Wizard on Visual Studio Marketplace.
That link is broken.
--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)

October 4, 2021 at 3:52 am

#3936112
Reply To: How to calculate Monthly aggregates from daily data

asita wrote:
Can you please assist with some way.
Thank you
Heh... DUDE! Look at the latest post I have code posted in! ;D
--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)

October 4, 2021 at 3:48 am

#3936111
Reply To: View or Stored Procedure?

I'll try to get back to this tomorrow. I ran out of time today.
--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)

October 4, 2021 at 3:47 am

#3936110
Reply To: How to start an Index Review Project

ScottPletcher wrote:
Database and index reviews cannot be automated. No software now does even a reasonably decent job of doing that. It must be done by a person.
Just to be sure,...
--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)

October 3, 2021 at 10:27 pm

#3936067
Reply To: How to start an Index Review Project

Editing of this post in process. Will repost in a couple of minutes.
--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)

October 3, 2021 at 10:14 pm

#3936066
Reply To: Implicit conversion from datetime to datetime2

david.edwards 76768 wrote:
From my previous life as a production engineer (making stuff) I'd call it an improvement in resolution, rather than accuracy. Along the same lines as someone hamfisted using 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)

October 2, 2021 at 7:59 pm

#3935911
Reply To: View or Stored Procedure?

yrstruly wrote:
Can you show me please what that code will look like?
Sure but the is no clear definition that I can see of what the desired output is in 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)

October 2, 2021 at 7:54 pm

#3935910
Reply To: How to calculate Monthly aggregates from daily data

If you look at the previous code, 90% of the answer is in the first CTE. All you have to do to that is add some of the original columns...
--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)

October 2, 2021 at 7:49 pm

#3935909
Reply To: Are the posted questions getting worse?

Paul White wrote:
Jeff, I'm not about points (I give most of mine away) or "3 pointing stripes", whatever that means. Somewhat like yous here, I donate my time to help people...
--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)

October 2, 2021 at 6:44 pm

#3935904
Reply To: View or Stored Procedure?

A possible alternative to all that is maybe it should be in an iTVF (inline Table Valued Function) so that it can be called by multiple procs and still be...
--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)

October 2, 2021 at 6:30 pm

#3935899
Reply To: How to start an Index Review Project

Lou wrote:
Current index inventory
Current index usage
New indexes recommendations
What do you think should I add ?
NOTE: Edited to clarify what can be automated and what requires "human judgement".
And I give up...
--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)

October 2, 2021 at 6:16 pm

#3935897
Reply To: What Do You Want to Know Before Negotiating Salary?

I think that a couple of better questions to ask your self is do you like your current job and are you happy with how much you're making?
I've also seen...
--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)

October 2, 2021 at 5:22 am

#3935771
Reply To: Are the posted questions getting worse?

ZZartin wrote:
I had someone ask me how many a couple was this morning, it was just one of those weird moments where I assumed that was just standard knowledge but...
--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)

October 1, 2021 at 4:36 am

#3935326
Reply To: Implicit conversion from datetime to datetime2

Alessandro Mortola wrote:
I agree with you Jeff and with your "ERROR in ACCURACY" definition 🙂
I have to thank you for the question! It's also ironic that I actually had to 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)

October 1, 2021 at 4:34 am

#3935325
Reply To: Using CONVERT(...)

To Grant's point, we can only guess about such a thing on a totally out-of-context snippet of code.
That, notwithstanding, I have the following comments on this...
First, since (in most cases...
--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 30, 2021 at 5:10 pm

#3935167

Viewing 15 posts - 4,516 through 4,530 (of 59,069 total)