Timothy A Wiseman is a Database Administrator for SAIC with a focus on efficiency and readability of the database and its surrounding ecosystem. In addition to administering the core SQL Server system, he has experience working with Python and Microsoft Access in conjunction with SQL Server. He holds a Bachelor's of Science in Mathematics as well as an MCDBA and MCITP.
I have seen people build procedures that rely on a result set being returned in a certain order. This is fine if an order by clause is used, but SQL Server will not guarantee the order of the results without … Continue reading