Forum Replies Created
Viewing 15 posts - 2,071 through 2,085 (of 6,676 total)
-
Reply To: Prevent Record Deletion
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 -
Reply To: query a new vendor database
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 -
Reply To: Any redundancy on SSIS Worker Server
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 -
Reply To: SQL Server Agent replacement
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 -
Reply To: weird sql problem.
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 -
Reply To: SQL Server Agent replacement
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 -
Reply To: Database file size question
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 -
Reply To: Drillthrough Reports
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 -
Reply To: Drillthrough Reports
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 -
Reply To: Flat File connection configuration
Brad Allison wrote: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 -
Reply To: Identity column as Primary Key - good or bad?
roger.plowman wrote: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 -
Reply To: Issues using sys.dm_io_virtual_file_stats dmv to check CheckDB Reads
rvsc48 wrote: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 -
Reply To: User accounts
Admingod wrote: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 -
Reply To: Master and Detail Table
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 -
Reply To: SSIS not continuing to next step
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
Viewing 15 posts - 2,071 through 2,085 (of 6,676 total)