Viewing 15 posts - 2,071 through 2,085 (of 6,676 total)
Is this a direct DELETE statement - or are they calling a stored procedure to perform the delete? If calling a procedure - and they have execute permissions on 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 18, 2019 at 7:23 pm
The best way is to contact the vendor and request that information - hopefully they are able to provide it for you, even if it is just a subset for...
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, 2019 at 7:14 pm
Based on my quick review - HA is available through windows clustering for the Scale-Out Master service and AlwaysOn for the SSISDB catalog.
The service will be installed on each node...
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 13, 2019 at 7:29 pm
So - you have a bunch of SSIS packages stored in the file system and SQL Server Agent jobs are setup to execute those SSIS packages?
If that is the case,...
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 11, 2019 at 6:54 pm
Also - be careful with referencing columns without using the table alias.
Select po_num
From poitem_all
Where poitem_all.po_num Not In (Select po_num From preqitem)
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 10, 2019 at 11:00 pm
It sounds like you have an integration services server - which would have SQL Server Integration Services installed. For the ETL processes - review how they are configured...are they referencing...
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 10, 2019 at 10:38 pm
I would recommend reviewing this article: https://www.sqlskills.com/blogs/paul/important-change-vlf-creation-algorithm-sql-server-2014/
I don't think it will apply - as long as you are not using an very small fixed size for growth of the 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 5, 2019 at 7:33 pm
How are you getting to the parent report? If you are linking to that report from another source - then that link can be configured to disable the navigation buttons. ...
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 4, 2019 at 8:32 pm

The last button is the back button - which will return you to the parent report without refreshing the data.
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 3, 2019 at 11:19 pm
I believe the stored procedure implicitly returns the double quotes to capture the field as there are some addresses with commas. What is the best practice in SSIS to...
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 3, 2019 at 7:06 pm
That's actually a plus. 🙂 True names, and all that. Is the lack of resets also true for the TRUNCATE verb?
No - truncate will reset the identity value to...
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 3, 2019 at 6:58 pm
CheckDB when running primarily effects IO for the TempDB database and not so much on the database you are running it on. Try running your query against TempDB while...
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 3, 2019 at 6:46 pm
Would that transfer the passwords for sql account?
Yes - it creates the new login with the same password and the same SID. Because the SID is the same -...
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 3, 2019 at 6:39 pm
Lookup SEQUENCE - instead of using IDENTITY for the detail table. It will require code changes to support - but it can do what you are requesting.
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
November 30, 2019 at 5:34 pm
I have never utilized this task - so I am not sure, but could this be a case where there isn't any output from the task so nothing to be...
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
November 28, 2019 at 5:13 pm
Viewing 15 posts - 2,071 through 2,085 (of 6,676 total)