Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,831 through 4,845 (of 59,098 total)

Reply To: Performance tuning

sqlfriend wrote:
unfortunately it is not something simple that T-SQL can handle. There are complicated logic to calculate stop corners according to time and direction of the bus etc, that 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 18, 2021 at 4:48 am

#3921128
Reply To: Performance tuning

sqlfriend wrote:
SSIS only has one execute task that calls the web service. I run today, there are 2000 routes to process, it runs about 8 hours on dev, and 10...
--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 18, 2021 at 12:03 am

#3921077
Reply To: YTD Date calculation
Ok... assuming the following requirements...
1. Given any DATETIME value, calculate the starting date of the Fiscal Year the value falls into.
2. The Fiscal year starts on the 1st of April.
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 17, 2021 at 11:28 pm

#3921067
Reply To: Suppress Backup Messages In Logs

RonMexico wrote:
Yes, 3226. My bad on the typo.
It is a third party backup which I've looked at their documentation to see if there is a setting to prevent writing to...
--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 17, 2021 at 9:11 pm

#3921021
Reply To: How to get the detailed record and summary value at the same time

892717952 wrote:
there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for each item and want to the totalqty shown as below picture,...
--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 17, 2021 at 9:02 pm

#3921015
Reply To: YTD Date calculation
Jeffrey Williams wrote:
Jeff Moden wrote:
Phil Parkin wrote:
DECLARE @FRDate DATE = '20210228';
DECLARE @newFRDate DATE = DATEFROMPARTS(YEAR(@FRDate) - 1, 4, 1);

SELECT @FRDate
,@newFRDate;
+1000
Would agree - except 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)
August 17, 2021 at 8:49 pm

#3921011
Reply To: Performance tuning

sqlfriend wrote:
however dev and test have exactly same databases and application
That never turns out to be the truth. At the very least, they live on different hardware, they have different...
--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 17, 2021 at 8:11 pm

#3920991
Reply To: Create a delta from downloaded info

Bruin wrote:
With the same Line,subline?
Look at the PK you've chosen. IMHO, only the first 3 columns of InvoiceNbr, Line, and SubLine should make up the PK.
--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 17, 2021 at 7:59 pm

#3920939
Reply To: Is that a reason DBA should Install SQL Server

The windows teams have a nasty habit of installing SQL Server on the "C:" drive. They have the same nasty habit for the page file, which really needs to have...
--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 17, 2021 at 7:52 pm

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

Jeffrey Williams wrote:
I have found that just putting that together will often lead to a solution or helps identify the actual issue.
Heh... PREACH IT BROTHER! 😀
--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 17, 2021 at 5:46 pm

#3920880
Reply To: Create a delta from downloaded info

Bruin wrote:
Answering Post by Jeff
"Two tables (one of existing data, one for new data) would be great."
Are you absolutely sure that you want to include the invoice date and 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)

August 17, 2021 at 4:06 pm

#3920842
Reply To: YTD Date calculation
Phil Parkin wrote:
DECLARE @FRDate DATE = '20210228';
DECLARE @newFRDate DATE = DATEFROMPARTS(YEAR(@FRDate) - 1, 4, 1);

SELECT @FRDate
,@newFRDate;
+1000
--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 17, 2021 at 3:49 pm

#3920828
Reply To: Function for converting hh:mm:ss time to decimal equivalent

First of all, the function you wrote is converting the final output to DECIMAL(10,2) because that's exactly what you told it to do in the RETURN clause of the function.
Second,...
--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 17, 2021 at 3:04 pm

#3920819
Reply To: SP causing blocking

Grant Fritchey wrote:
... maybe. Testing is your buddy in these circumstances.
Preach it Brother! One good test result is worth a thousand expert opinions.

--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 17, 2021 at 12:21 pm

#3920729
Reply To: SP causing blocking

John Deupree wrote:
I have a simple proc that I suspect is causing intermittent blocking. It takes a customer ID (int) as a param and returns an output param FeatureFlag (bit) indicating...
--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 17, 2021 at 12:19 pm

#3920728

Viewing 15 posts - 4,831 through 4,845 (of 59,098 total)