SQL SERVER – How to Find Row Count of Every Table in Database Efficiently?

How do you find the row count of every table in a database without a cursor? An interview question, answered with a fast query instead of a loop.