Viewing 15 posts - 331 through 345 (of 6,676 total)
The problem here is how SQL Server generates the execution plan for the query using the view.
If SQL determines that filtering earlier in the plan is the better option then...
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
January 4, 2023 at 4:39 am
Just curious - but how and why would you archive 'Quality History' if there is no Quality_Date associated with that row? I would assume that not having a quality date...
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
December 30, 2022 at 7:31 pm
You can, and definitely should, get rid of the other ISNULLs in your WHERE:
AND ISNULL(d.value_2,'') NOT IN ('Clay','Volusia') --replace with --> AND d.value_2 NOT IN ('Clay','Volusia')
AND ISNULL(rc.referral_category_ud,'') <> 'FFS_NO_TAKE_BAC'...
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
December 30, 2022 at 7:22 pm
BWAAA-HAAA-HAAA. Posting on this thread must cause disturbances in the "force". I looked again right after I posted and I finally found one.
https://gertjans.home.xs4all.nl/sql/fragmentation-hurts-performance.html
He also was only testing...
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
December 28, 2022 at 5:20 pm
Is there a reason NOT to use the more concise $cmd.Parameters.AddWithValue('@StartProductID',749) instead of
$p1 = $cmd.Parameters.Add('@StartProductID',[int]) $p1.ParameterDirection.Input $p1.Value = 749
Using .AddWithValue will end up costing you a lot more than...
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
December 26, 2022 at 4:32 pm
Instead of enabling both successful and failed logins - you can configure an audit instead. The audit can also send the data to the application event log -...
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
December 23, 2022 at 5:24 pm
Instead of enabling both successful and failed logins - you can configure an audit instead. The audit can also send the data to the application event log - but 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
December 22, 2022 at 10:57 pm
It seems this thread has gotten off-track. The original question was why does NOT IN behave the way it does - and that is easily explained when you consider the...
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
December 19, 2022 at 9:52 pm
Maybe I am off-base here, but this really isn't about how Microsoft handles NULLs, rather it is more simply a logic problem.
When using IN - match on ANY item in...
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
December 18, 2022 at 4:37 pm
Add a new volume - either as a mount point or a separate drive. Add a new file to the PRIMARY filegroup at the same size as the exiting file(s)...
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
December 16, 2022 at 7:10 pm
@AntGreen - the process you outline isn't supported. That process allows for one version up on the OS and/or SQL Server only - which won't allow for upgrading to SQL...
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
December 16, 2022 at 7:05 pm
In the left pane - select Expressions. Find the one for Files - and setup the expression.
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
December 16, 2022 at 7:02 pm
Thanks, I do believe we are.
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
December 16, 2022 at 5:40 am
Correct, you convert the local time to UTC then perform the conversion to Unix timestamp.
In fact, the numeric timestamp is only UTC by convention. There is nothing inherent in 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
December 16, 2022 at 5:02 am
I understand that, but converting to or from a Unix timestamp doesn't need to know anything about UTC. The conversion is strictly based on the number of seconds or milliseconds...
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
December 16, 2022 at 4:20 am
Viewing 15 posts - 331 through 345 (of 6,676 total)