Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,941 through 5,955 (of 59,072 total)

Reply To: Index Column Order – Be Happy!

Sergiy wrote:
A covering index with Status column first followed by OrderDate is inevitably a subject of severe page splits on every ongoing INSERT's.
I can definitely vouch for that... 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)

December 6, 2020 at 4:55 am

#3817425
Reply To: Index Column Order – Be Happy!

Jeff Moden wrote:
The link for Jonathan's script, once you find it on SQLSkills, is broken. Do you have another source for the script that makes the two sales tables larger?
And, I...
--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)

December 6, 2020 at 4:52 am

#3817424
Reply To: Inflow / outflow report per day

Ok. First of all, we need to get rid of the incremental rCTE (recursive CTE) that you're using to come up with the missing dates. Please see the following article...
--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)

December 6, 2020 at 3:27 am

#3817412
Reply To: Inflow / outflow report per day

That, good sir, is an excellent post. Thank you for taking the time to post it. I'll be back. 😀

--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)

December 6, 2020 at 1:02 am

#3817396
Reply To: SQL agent job failed

In that case, I don't have any good guesses. The error message is pretty clear about it not being able to find the file. I'm still thinking it's a privs...
--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)

December 5, 2020 at 5:50 pm

#3817328
Reply To: SQL agent job failed

I'm thinking that the services accounts for the new server have no privs on the target directory. Fix that and you should be golden.
--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)

December 5, 2020 at 4:43 pm

#3817317
Reply To: Catching Minor Issues

"Minor Issues"??? A multi-million dollar rocket crashing is NOT a "Minor Issue"! 😀 Neither is using a space vehicle for a planetary drill because of a difference in measuring systems...
--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)

December 5, 2020 at 3:57 pm

#3817307
Reply To: Inflow / outflow report per day

milo1981 wrote:
By the way, I'm using SQL Server 2005.
For the love of Pete... why on Earth would you post your problem in a 2014 forum then? Any other caveats you'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)

December 5, 2020 at 3:41 pm

#3817306
Reply To: Inflow / outflow report per day

This problem is an interesting problem and so I built two tables each containing more than 102 Million rows spread across 5 years (60 months) with each month containing more...
--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)

December 5, 2020 at 3:30 pm

#3817293
Reply To: Inflow / outflow report per day

milo1981 wrote:
I don't have the column 'Cashflow' in may tables, is what I want to calculate. As ScottPletcher said, I need a running total.
So tell me where in pietlinden's script...
--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)

December 4, 2020 at 4:56 pm

#3817002
Reply To: conversion of excel formula to case statement in tsql

Abhas wrote:
Hi all,
need your help on conversion of excel formula into case statement. i tried but missing only one case. below is excel formula:
=IF(AND(Q141="EndOfDay", AD141="EndOfDay",V141=""),8, MIN(8, IF(OR(Q141="EndOfDay"), 0, IF( 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)

December 4, 2020 at 4:51 pm

#3817001
Reply To: Index Column Order – Be Happy!

The link for Jonathan's script, once you find it on SQLSkills, is broken. Do you have another source for the script that makes the two sales tables larger?
--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)

December 4, 2020 at 4:44 am

#3816797
Reply To: Configure Replication Between an On-premises SQL Server and AWS RDS

Jonathan1453 wrote:
Yeah, I later resolved it using the hosts file following a tutorial I found on another website.
Thanks for the concern.
Can you post the link, please?
--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)

December 4, 2020 at 12:30 am

#3816760
Reply To: Ordering with NULL

jcelko212 32090 wrote:
The ANSI/ISO standards specify an extra clause that goes after the order of the sort (ASC | DESC) which will let you decide the order of the nulls within...
--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)

December 4, 2020 at 12:17 am

#3816759
Reply To: Error

ramyours2003 wrote:
we are not sure the query as it is getting my tool , may i know what are the reasons of getting this error and any idea to resolve...
--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)

December 3, 2020 at 6:39 pm

#3816651

Viewing 15 posts - 5,941 through 5,955 (of 59,072 total)