Sample script that compares single use plans to re-used plans. This script requires Microsoft SQL Server 2005.
declare @single int, @reused int, @total int
when 1 then 1
when 1 then 0
'Single use plans (usecounts=1)'= @single,
'Re-used plans (usecounts>1)'= @reused,
're-use %'=cast(100.0*@reused / @total as dec(5,2)),
select 'single use plan size'=sum(cast(size_in_bytes as bigint))
where usecounts = 1
Things borrower must know about Pre Closing Home loan - Most people tend to take a home loan for 15 to 20 years as this usually offers the lowest home loan interest rates. Now to prepay the loan, you have to pa...