Skip to content

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

Asp.Net Core
C#
SQL
JavaScript
CSS
About
ErcanOPAK.com
No Access

Tag: database-tips

SQL

Avoid SELECT * in Production

- 28.01.26 - ErcanOPAK comment on Avoid SELECT * in Production

Why it mattersSchema changes won’t silently break performance.

Search for:

February 2026
M	T	W	T	F	S	S
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28

« Jan

Most Viewed Posts

Get the User Name and Domain Name from an Email Address in SQL (934)
How to add default value for Entity Framework migrations for DateTime and Bool (830)
Get the First and Last Word from a String or Sentence in SQL (822)
How to select distinct rows in a datatable in C# (799)
How to make theater mode the default for Youtube (708)
Add Constraint to SQL Table to ensure email contains @ (572)
How to enable, disable and check if Service Broker is enabled on a database in SQL Server (552)
Average of all values in a column that are not zero in SQL (517)
How to use Map Mode for Vertical Scroll Mode in Visual Studio (473)
Find numbers with more than two decimal places in SQL (436)

Recent Posts

C#: Use init Accessor to Create Immutable Objects Without Constructor Boilerplate
C#: Use Index and Range Operators for Cleaner Array Slicing
C#: Use Null-Coalescing Assignment to Simplify Lazy Initialization
SQL: Use CHAR Instead of VARCHAR for Fixed-Length Columns to Save Space
SQL: Use CROSS APPLY Instead of Subqueries for Better Performance
.NET Core: Use Required Modifier to Force Property Initialization
.NET Core: Use Global Using Directives to Avoid Repeating Imports
Git: Use git restore to Unstage Files Without Losing Changes
Git: Use git bisect to Find Which Commit Introduced a Bug
AJAX: Use Fetch with Signal to Cancel Requests When User Navigates Away

Most Viewed Posts

Get the User Name and Domain Name from an Email Address in SQL (934)
How to add default value for Entity Framework migrations for DateTime and Bool (830)
Get the First and Last Word from a String or Sentence in SQL (822)
How to select distinct rows in a datatable in C# (799)
How to make theater mode the default for Youtube (708)

Recent Posts

C#: Use init Accessor to Create Immutable Objects Without Constructor Boilerplate
C#: Use Index and Range Operators for Cleaner Array Slicing
C#: Use Null-Coalescing Assignment to Simplify Lazy Initialization
SQL: Use CHAR Instead of VARCHAR for Fixed-Length Columns to Save Space
SQL: Use CROSS APPLY Instead of Subqueries for Better Performance

Social

ErcanOPAK.com
GoodReads
LetterBoxD
Linkedin
The Blog
Twitter

© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com