Loan Chargeoff Prediction Solution Templates are Live in Cortana Intelligence Solutions Gallery

A charged off loan is a loan that is declared by a creditor (usually a lending institution) that an amount of debt is unlikely to be collected, usually when the loan repayment is severely delinquent by the debtor. Chargeoff loan has huge financial implication on lending institutions’ financial statement.  No banks or credit unions like…

0

Indirect Checkpoint and tempdb – the good, the bad and the non-yielding scheduler

Indirect checkpoint was first introduced in SQL Server 2012 to provide predictable database recovery governed by target_recovery_time option set at the database level. In SQL Server 2016, indirect checkpoint is ON by default with target_recovery_time set to 60 seconds for model database. The conventional or automatic checkpoint algorithm assumes fixed time interval to recover each…


SQL Server Diagnostics (Preview)

EDIT (1/10/2018): As of yesterday, this preview service was shutdown. SQL Server customers encountering product issues that generate dumps should contact Microsoft CSS for support and guidance. Today, Microsoft is releasing the SQL Server Diagnostics (Preview) extension within SQL Server Management Studio and Developer APIs to empower SQL Server customers to achieve more through a variety…