Counting rows forces full scans.
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Most Viewed Posts
- Get the User Name and Domain Name from an Email Address in SQL (973)
- How to make theater mode the default for Youtube (953)
- How to add default value for Entity Framework migrations for DateTime and Bool (939)
- Get the First and Last Word from a String or Sentence in SQL (847)
- How to select distinct rows in a datatable in C# (837)
Recent Posts
- CSS: Fix a prefers-color-scheme Media Query That Gets Silently Overridden by a Browser Extension’s Forced Dark Mode
- Git: Fix a Merge Commit That Silently Drops a File Because Both Branches Deleted It Differently
- HTML5: Fix a Native Lazy-Loading Image That Never Loads Because It Sits Inside a Hidden Tab Until the User Clicks It
- The AI Prompt That Traces a Null Reference Exception Back to the Exact Line That First Produced the Null
- The AI Prompt That Turns a Gym Membership Contract’s Fine Print Into a Plain-English List of Cancellation Steps