The inner exception is An existing connection was forcibly closed by the host. Inspect the target SQL Server's errorlog for a concurrent EXCEPTIONs or ASSERTIONs. If nothing is found,...

See http://www.sqlservercentral.com/articles/Advanced+Querying/generatingpermutationsintsql/2076/

Assuming @job is declared a sysname, it's a string which can be concatenated:

declare @msg nvarchar(4000)

set @msg = @job + ' is already running.'

And assign @body @msg.

https://support.microsoft.com/en-us/kb/3009974 requires trace flag 1800 to be enabled. 18 hundred-level trace flags are likely to impact the storage engine (http://www.sqlservercentral.com/articles/trace+flags/70131/). I doubt tracestatus(1800,-1) will work (I...

Lots of work:) Easy to show partitioning is far more popular for DW systems than OLTP systems (literature search reveals this). Easy to highlight the pitfalls sprinkled within

Best to follow https://support.microsoft.com/en-us/kb/942861 and http://blogs.msdn.com/b/mssqlisv/archive/2008/05/27/sql-server-intermittent-connectivity-issue.aspx

Communication link failures have a variety causes, see https://support.microsoft.com/en-us/search?query=communication%20link%20failure. A pair of network sniffs can be required, and no...

Welsh Corgi (11/25/2015)

---

The following example baffles me about Indexes Where it uses a date file in the indexes and it talks about aligned indexes.

It does not work but it is...

Did you turn on trace flag 1800?

WRT the missing index DMVs, they are a good start, but they are not always the sharpest tool in the shed. For example, you will probably see indexes being suggested...

For the same [start]?

ebooklub (11/23/2015)

---

From past experience I remember that some times installation of instance or SP would not start because of "reboot pending" ,

is any flag/options could be...

There is a bug fix - see https://support.microsoft.com/en-us/kb/3009974. What does SELECT @@version return? SP2 CU3 is 2011.110.5556.0. Workaround would be to ensure sector sizes match

Use a non-production system (running the same SQL Server version and build as the "production" system) to backup its current msdb and restore production's msdb from its backup. Script out...

If the vendor failed to present the evidence described in http://blogs.msdn.com/b/sqlmeditation/archive/2012/12/12/meditation-on-sql-trace-performance-impact.aspx, the vendor is spreading FUD. Because tracing is being replaced by extended events, MS is unlikely to...

If you wish a question to be focused on Integration Services, please post your question within the Integration Services forum (http://www.sqlservercentral.com/Forums/Forum364-1.aspx).

However, a quick search led me to...