Viewing 15 posts - 226 through 240 (of 6,676 total)
I would bet it isn't the SQL command from variable that is causing the problem - it almost certainly is the query you have created that is causing the problem.
There...
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
June 22, 2023 at 8:57 pm
@AntGreen - using GETDATE() - N will subtract days not hours. So this needs a bit more:
WHERE ENTRY >= DATEADD(hour, CASE datepart(hour, GETDATE())
...
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
June 21, 2023 at 7:14 pm
Ah. That's annoying. But thanks.
Is there a way to redirect SSRS given that I don't want to uninstall it just yet.
Not that I am aware of - what you...
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
June 18, 2023 at 3:52 pm
Because it is installed, so http.sys has been modified
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
June 16, 2023 at 6:50 pm
Because SSRS does not use IIS - so any redirects in IIS have no effect on the SSRS service. You can use IIS to redirect to SSRS - but you...
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
June 16, 2023 at 6:29 pm
@jonathon-2 - I just tested your method and found that it is including 151 additional non-prime numbers in the results. I also tested both version on one of my systems,...
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
June 15, 2023 at 7:56 pm
I am wondering what is meant by 'refreshed' here. If by refreshed you mean a database restore - then the quickest method would be to restore to all replicas at...
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
June 15, 2023 at 7:12 pm
Although it probably won't make a difference - I would recommend moving filtering from the JOIN to a WHERE:
DELETE RAL
FROM c_repos_applied_lock RAL
INNER JOIN c_repos_table RT...
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
June 15, 2023 at 7:05 pm
This happens quite often when either SSMS or VS is updated. The solution is to repair 'Microsoft Visual Studio for Application' for your version. Start with the version for 2017...
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
June 12, 2023 at 8:02 pm
There should be a folder under one of the Visual Studio folders under you Documents folder. Example: C:\Users\{user}\Documents\Visual Studio 2017\Backup Files\Solution1
This should have a list of autorecover, recovered and original...
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
June 6, 2023 at 8:49 pm
Before dropping idx1 - verify that it is not being used to support a foreign key constraint or a unique constraint.
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
June 6, 2023 at 4:27 pm
You also need to review how you got into this situation - and put controls in place to avoid having to restore a database to get a previous version 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
June 6, 2023 at 4:19 pm
What is the purpose for partitioning the data? If the goal is to improve performance - then partitioning is not the way to go, rather - make sure you have...
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
June 3, 2023 at 9:47 pm
My question was something else, kindly help here.
I know about committing and rollback.
yours sincerley
Your code, as posted, will not commit the inner transactions. The outer transaction, as Grant...
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
June 1, 2023 at 9:43 pm
Jeffery, you are wasting your time. Dennis is always right, and he knows everything.
Yeah - I am getting that impression.
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
May 31, 2023 at 8:37 pm
Viewing 15 posts - 226 through 240 (of 6,676 total)