Hello richlion2,

I did not think of the case where disabling the index wasn't an option. I suppose for old SQL versions, that does make more sense then.

With respect to...

richlion2 (12/8/2016)

---

I keep having these conversations with people who don't know how the SQL server engine works that SQL is looking after itself. I recently asked one of my analyst...

Not a problem. Everybody has days like that.

Plus it is much nicer to find out you missed something simple than to find out that your query really needs to...

Possibly a dumb question but are you using the database as the schema?

That is, in the UPDATE command it should be:

UPDATE <database>.<schema>.<table>

SET dest.[project_id] = stage.[project_id]

...

If I understand your question correctly, you are wondering why you would want to specify a listener IP.

Lets say for example, your SQL instance had 2 network cards; one inside...

As a thought, could you ask your domain controller manager to check their logs if the account got locked at the time the job failed?

Is it always the "backup" job...

Is the backup happening to local disk or network attached storage?

If it is network attached storage, you could bug your network admin to see if there are any network issues...

Did a quick google of that and found this link: http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/error-the-application-has-failed-to-start-because/df019c0d-746e-42d0-ad68-465e18e3f3ef

which had the following answer:

Error message: "Side-by-side configuration is incorrect"

The machine is missing the correct C++ runtime components for your...

Now, I am no SQL expert, but if I had to guess, I would say it is part of how SQL Server handles ACID.

If you do an update and something...

Should also be noted that this is for SQL version greater than SQL Server 2005 which according to the microsoft documentation at https://msdn.microsoft.com/en-us/library/ms174335(v=sql.90).aspx states:

expression

Is a constant, a variable, or an...

OH, so you are using SSIS.

why not use a data flow task to copy the data over instead of a script?

Eirikur Eiriksson (10/12/2016)

---

This looks entirely wrong to me, two instances of a parameter object with the same name in the same scope, using parameters in non-parameterized code, no command is...

you could do it as a stored procedure instead of a hard coded SQL command, but if you don't like that solution how about:

public static SqlDataAdapter InsertSQL()

{

SqlDataAdapter adapter = new...

The reason it is failing is that the variable doesn't exist on the MYSQL side. When you do the execute AT command, you are telling it to run that...

I agree with you Andrew.

It also doesn't help that every time I think I partially understand most of the features they add in something new or I find a feature...