What we did was deploy all jobs on all instances from TFS in a disabled state. Then a "controller job" was implemented on both instances that would run once a...

When you say all is fine after starting the primary what do you mean? What state is each database immediately after that point and which ends up primary?

vsamantha35 (1/26/2016)

---

Hi Orlando,

Thanks for the response. I am basically looking for 2 clarifications here.

In AG, does Primary replica will be sending log records constantly to secondary and applied on...

Thanks for posting back. I wanted to rule out a local connection attempt because that will always use NTLM.

There are specialized tools to debug Kerberos issues and sometimes it's...

Sounds like you have a job that is trying to access a database participating in an AlwaysOn AG while that database is a secondary replica and not otherwise available. You...

wisl (1/26/2016)

---

I have 56 Gb of Memory and I had assigned 50 to SQL Server, leaving 6 GB (ish) for OS and everything else.

Now that I've read this post I...

How much free memory does Windows have right now? How high or low does that go during the course of a normal business cycle?

This likely won't be an explanation that completely satisfies your technical curiosity but I will make an attempt. If we could drag an SSIS Team developer and an ACE Driver...

In your scenario is SERVERNAME a remote machine from where you are running SqlCmd or are you testing this by running SqlCmd on the same server where the database instance...

In SQL 2008 it means 12GB is allocated to the Buffer Pool of that instance but the setting does not cover any non-Buffer Pool memory the instance (i.e. SQL Server...

From Integration Services (SSIS) in a Cluster- SQL Server 2014:

Clustering Integration Services is not recommended because the Integration Services service is not a clustered or cluster-aware service, and does not...

genuiforex (1/25/2016)

---

Hi Experts,

Can't send dbmail with attachment as per below script.

if exists (select distinct 1 from xxxx.dbo.owtr where U_STN_Ref = 'POSNegINVCorr' and convert(varchar(10),docdate,112) = convert(varchar(10),getdate() - 1,112))

begin

declare @EmailList nvarchar(max)

declare @html...

Tallboy (1/25/2016)

---

Hi,

I have to call a stored procedure from within another procedure.

I have to pass the proc 2 parameters

@ClientID int,

@StartDate date

But I dont know which is the correct syntax for...

Because...

Would it benefit you to improve in the 43 minutes? 5 million rows is more than your average data load but it is possible to process that many rows a...