Viewing 15 posts - 2,536 through 2,550 (of 6,676 total)
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
April 13, 2018 at 12:26 pm
Good Morning Experts,
We have configured read-only routing in Availability Groups , SQL Server 2014....
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
April 11, 2018 at 12:36 pm
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
April 11, 2018 at 12:34 pm
Did you back up the encryption key from the old server and restore it on the new server?
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
April 7, 2018 at 1:25 pm
Modify the ON to
On t.id = s.id
And t.startdate = s.startdate
then add a check for
When not matched by source
Then
Update
Set enddate =...
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
April 7, 2018 at 1:23 pm
Hardik Turakhia - Thursday, April 5, 2018 6:19 AMAny suggestion on how to achieve the same without using cmdshell command?
I prefer using...
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
April 5, 2018 at 8:21 am
I have multiple file groups, primary, data, index, and lob. I am trying to balance...
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
April 5, 2018 at 8:15 am
=Today.AddDays(0 - Today.Day)
=DateSerial(Year(Today), Month(Today), 1).AddDays(-1)
Alternative methods:
=Today.AddDays(1 - Today.Day).AddMonths(-1) \\First of last month
=Today.AddDays(0 - Today.Day).AddMonths(0) \\Last day of last month
=Today.AddDays(1 - Today.Day).AddMonths(-2) \\First 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
April 1, 2018 at 10:41 am
How is the linked server configured 'to use a specified login'?
If you are adding a login named 'myuser' to MyLinkedServer - and then adding that as a user 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
March 29, 2018 at 3:38 pm
I would recommend adjusting the configuration for the catalog first - instead of removing the logging. Also - if you are running into space issues with SSISDB then you should...
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
March 27, 2018 at 1:36 pm
Does the secondary have enough space available for the transaction log to grow? I have run into issue where the secondary had 400GB drive - primary also had a 400GB...
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
March 27, 2018 at 1:08 pm
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
March 23, 2018 at 7:43 pm
Review the following articles:
https://www.brentozar.com/archive/2016/01/cheat-sheet-how-to-configure-tempdb-for-microsoft-sql-server/
https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/
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
March 23, 2018 at 7:24 pm
As stated earlier - you need to create the login on each secondary with the same SID that was created on the primary. When you create the user in 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
March 23, 2018 at 12:14 pm
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
March 22, 2018 at 12:11 pm
Viewing 15 posts - 2,536 through 2,550 (of 6,676 total)