So now you verified...

I dont think it would be a problem but not sure. It might be safe to just uninstall VS as well just to be safe as long as you dont...

once the plan is created, that plan will always be used until it is bumped out of cache or invalidated (recompiling proc invalidates plan). recompile your proc then run it...

This is most likely a parameter sniffing issue. The "bad plan" has a compiled value of 40 for marketID and the "good plan" has a compiled value of 17. I...

Once you do have that uninstalled you might be better off getting the SSDT installer here(http://msdn.microsoft.com/en-ca/data/tools.aspx). It is the most up to date one. you would probably want the SSDT-BI...

I would suggest just uninstall sql server data tools via programs and features. then once uninstalled. try to install it again with the sql server installer selecting only sql server...

SpeedSkaterFan (8/6/2014)

---

If I start data tools (or start visual studio 2010, which is I believe the same), start a new project, choosing integration services / integration services project and then...

Integration services does not come with express so you would only have one SSIS. even so SSIS is a shared feature so even if you installed multiple enterprise instances only...

It was added in SQL Server 2012

Check for a duplicate SPN for that server registered to a different account.

If you can have server B delayed then log shipping with a stand-by...

Always On AGs or replication. You could also do log shipping but this be delayed.

These two collations are effectively the same. They are both Case-insensitive, accent-sensitive, and have the same codepage, 1252.

select collationproperty('SQL_Latin1_General_CP1_CI_AS','CodePage')

select COLLATIONPROPERTY('Latin1_General_CI_AS','CodePage')

One is windows collation and one is SQL collation but I...

Specifies the total number of I/O buffers to be used for the restore operation. You can specify any positive integer; however, large numbers of buffers might cause "out of memory"...

My guess is that when you installed the service pack on the secondary, the databases involved in AG were not updated as the message said. If they were then the...