Hi,

Could you check if this article suits you?

How to use DISM to install a hotfix from within Windows

http://blogs.technet.com/b/askcore/archive/2011/02/15/how-to-use-dism-to-install-a-hotfix-from-within-windows.aspx

Hi,

Are this wait increase going in parallel with any network related waits increase?

Hi,

Could it be possible that the errors you are getting should be related to some WMI configuration issue rather than a compatibility issue? The links I posted before are explicit...

Hi

Sorry but I do have a test environment with me now but I think that you could try creating temporary linked servers on a master instance and then replace the...

Hi Ashish,

Could you post the URL of the MSDN article that explains the procedure?

Additionally. Do you need to change the database location for the primary and the secondary replicas all...

Hi,

I am not an expert so sorry if I mislead you. Did you check the reference on the BOL for this version?

Microsoft.SqlServer.Management.Smo.Wmi.ServerInstance

https://technet.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.wmi.serverinstance(v=sql.110).aspx

Managing Services and Network Settings by Using WMI Provider

https://technet.microsoft.com/en-us/library/ms162567(v=sql.110).aspx

I...

It is also possible that you have administrative access to the machine where you are installing SQL Server but you do not have permissions for reading the Active Directory or...

SPID -1 is quite odd. It seems an orphaned transaction lock or something similar. Can you try to use the same workaround like SPID -2 issues?

http://www.mytechmantra.com/LearnSQLServer/Kill-Negative-SPID-in-SQL-Server/[/url]

Hi,

Did you perform a DBCC CHECK CATALOG or CHECKTABLE on the affected databases? Did those command return any other details?

https://msdn.microsoft.com/en-us/library/ms186720.aspx

I hope this helps.

Hi,

You can show a lab with the total size used by a table with or without space optimization. Use sys catalogue to get the size of both tables. You can...

Yeah, an experienced DBA could at least obfuscate his track. At least, leaving the logs on an unreachable location and monitoring any configuration change or service restart would help on...

Any chance that the executable got deleted or corrupted?

The only reference about this error after google it is this:

https://support.software.dell.com/litespeed-for-sql-server/kb/77883

You can also create a maintenance plan with two subplans executing at the same time to run as a parallel task. The side effect would be that you need to...

Hi,

One of the reasons I usually put on the table is, although there are maybe few differences between 2012 and 2012 R2, the support lifecycle on the R2 is obviously...

Hi,

One option could be enabling security audit (if the SQL Server edition allows it) and set the log file to a protected folder with no write permissions for sysadmin accounts.

To...