White Paper

  • SQL image

How to Write a Good SQL Query

2020-08-03T19:15:27+00:00May 22nd, 2019|

You’ve been coding feverishly for ten minutes. You’ve got twenty table joins lined up, and you’re ready to execute your newest monster SQL query. A single bead of sweat rolls down your forehead as you timidly press the button to execute. You watch the SQL engine spin as it starts to process your query. One second ticks by. You think, “No syntax errors!” Three more seconds. Now you’re starting to get nervous. At the ten-second mark, nervousness gives way to panic. Now you think, “Where’s my data?” At twenty-two seconds, two records finally come back from your query. “That’s the data I’m looking for, but why did it take so long?” you ask yourself. Even the best query writers have been here. So, how do you write better SQL queries to improve your execution? Be Linear Map out a linear path from table to table to table – to get

  • people

Are You a Good Candidate for Outsourced Mortgage Fulfillment? These Five Questions Can Help You Decide.

2020-08-03T19:30:10+00:00July 18th, 2019|

“Should I stay or should I go?”—The Clash In today’s volatile mortgage environment, many community lenders are reexamining their commitment to mortgage operations or withdrawing from residential lending altogether. But, with the single-family mortgage often functioning as a cornerstone product for community lenders, many are asking themselves: Do we really want to send customers across the street for a product our communities expect us to offer? More and more lenders are turning to outsourced fulfillment to continue offering this core product. But, is outsourced fulfillment right for all local lenders? Is outsourcing an option you should be exploring? To help decide, ask yourself: Why are you in the mortgage business? Are you offering the digital customer experience large lenders and FinTechs are marketing? What is your current monthly loan volume? What is your residential lending growth strategy? What are your fully-loaded origination costs per loan? Why are you in the