Before following this tip, review the bootstrap folder and strive to determine why the upgrade failed. If you cannot determine why the upgrade failed, the advantage of reinstalling the operating...

Did a human kill CHECKDB or was CHECKDB unexpectedly killed by a high severity error that was raised to SQL Server's errorlog?

If the latter, you need to inspect...

Also see this fix

Agree that a restart of at least SSRS can be required after running a SP setup, as can be verified by inspecting the C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\<date>\Summary<machine_date>.txt file that...

Pass through authentication (already suggested by a few respondents) can solve this problem, if network control allows. But, I have to wonder what is the purpose of the current lack...

Implemented before I was hired. Hopefully buried before I retire.

My key lookups are due to a past propensity to add columns without considering normalization, a slavish reliance upon surrogate...

Run perfmon /sys and look at process private bytes for SSMS when it OOMs.

Is 'sync with backup' set and do you backup the distribution db?

What works best depends upon the IO demands of the applications. If the applications have been observed to demand sudden, rapid, and seemingly uncontrollable increases in tempdb data space or...

SAN replication is a hardware-based solution, which means you need to read your hardware's documentation, especially where it specifically mentions SQL Server. SQL Server uses write-ahead logging (search msdn for...

Temporarily increase the -outputverboselevel of the distribution job, and inspect results.

If you must use a cursor, you need to think about whether a static cursor or a dynamic cursor (etc) would more explicitly suit the needs of business/logic. Transact-SQL cursors...

Whether jobs are started asynchronously by sp_start_job or sqlagent's call to it, there is a per-sqlagent-subsystem max worker thread limit. Once that limit is reached, SQLAgent.out logs that stall. Best...

There is a way to suppress inserts, but it is not going to be supported by MS:

use msdb

create trigger NoJobHistory on dbo.sysjobhistory for insert as

rollback

I cannot predict what other...

Log files must be sequentially written. The spid that grows the log file by 10GB will have exclusive access, until 10GB is written. Other spids must wait. If SQL...