Viewing 15 posts - 811 through 825 (of 6,676 total)
Yes that is correct.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2021 at 6:54 pm
If you look at the original post, he checks for month less than 4.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2021 at 6:47 pm
good discussion here: https://stackoverflow.com/questions/15138593/nvarchar-concatenation-index-nvarcharmax-inexplicable-behavior
relevant section to this application:
Even without ORDER BY, we do not guarantee that @var = @var + will produce the concatenated value for any statement that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2021 at 6:39 pm
If the installation process is well documented - then anyone can perform the install, especially where the required components for installation have been identified. I have found that most system...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2021 at 6:34 pm
Phil Parkin wrote:DECLARE @FRDate DATE = '20210228';
DECLARE @newFRDate DATE = DATEFROMPARTS(YEAR(@FRDate) - 1, 4, 1);
SELECT @FRDate
,@newFRDate;+1000
Would agree - except the solution...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2021 at 6:27 pm
How do you determine that 2021-01-04 (January 4th, 2021) is the first day of the year? Is that valid for every year - or do other years start on a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2021 at 6:17 pm
Rubber ducky effect is strong for me this morning. Was baffled for the past couple of days as to why the "exact same code" would work in a query...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2021 at 1:50 pm
I never change min memory - only set max memory. On a dedicated host for a single instance - SQL Server will grab all memory up to the max memory...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2021 at 4:03 pm
Not confusing for me. You have existing data and you have new data. He want's a way to compare the data that changed.
I do absolutely agree that he needs...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2021 at 2:32 pm
ZZartin wrote:So ORDER BY CONVERT(datetime, last_activity_date, 3) desc
Now shows error
Invalid column name 'last_activity_date'.
This is because you are trying to convert the 'alias' name - you would need to either:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2021 at 2:25 pm
This is confusing - it really isn't clear what you want to accomplish. I am thinking you might want a temporal table - but since you haven't provided the requested...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2021 at 4:12 pm
My table as a PK(unique) of:
[InvoiceNbr] ASC, [Line] ASC, [SubLine] ASC, [InvoiceDate] ASC, [ShipDate] ASC
The process that creates the file to load to SQL does a FULL refresh of...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2021 at 6:48 pm
thanks for the Response Sean. attaching sample data
No offense mate but not going to pull down an excel document to load up some sample data. Post it as...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 11, 2021 at 2:05 pm
It’s funny nobody suggested the most obvious choice in such situation - RIGHT JOIN:
Select s.Shipment_No
, p.pkg_no
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 6, 2021 at 3:58 pm
Have you enabled 'Optimize for Adhoc Workloads' at the server level?
As for which database - I would identify one or more databases where you can evaluate the application after making...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 6, 2021 at 2:10 pm
Viewing 15 posts - 811 through 825 (of 6,676 total)