Tag: todayilearned · Just Some Code

© 2022. All rights reserved.

#todayilearned

2022

2022-04-04 TIL: T-SQL doesn't have constants and variables aren't a good idea
2022-03-21 SQL Server Index recommendations: Just listen to them
2022-03-07 TIL: How to optimize Group by queries in SQL Server
2022-02-21 TIL: How to do a case-sensitive search in SQL Server

2021

2021-12-06 It's not what you read, it's what you ignore
2021-10-25 TIL: Dictionary keys are converted to lowercase too on serialization
2021-02-24 TIL: How to convert 2-digit year to 4-digit year in C#
2021-01-25 TIL: Livable Code. Living with your mess
2021-01-04 TIL: Three differences between TRUNCATE and DELETE

2020

2020-12-04 TIL: Always Use a Culture When Parsing Numeric Strings in C#
2020-12-03 TIL: Three Tricks to Debug Your Dynamic SQL Queries
2020-11-17 TIL: LINQ DefaultIfEmpty method in C#
2020-11-13 TIL: SQL Server uses all available memory
2020-10-20 TIL: NULL isn't LIKE anything else in SQL Server
2020-10-08 TIL: EXISTS SELECT 1 vs EXISTS SELECT * in SQL Server
2020-10-05 TIL: How to compare DateTime without the time part in SQL Server
2020-10-01 TIL: How to add gzip compression to ASP.NET Core API responses