.net, C# and programming (Page 6)

Null or NotNull Read in English

This topic is related to this question on StackOverflow. Let's discover, what are CanBeNull or NotNull attributes? How do they work?

Read more...

IndexOf with IEquatable Read in English

This topic started from question on StackOverflow: different collections (Array and List) have different implementation of IList.IndexOf method.

Read more...

Неизвестный T-SQL Читать на русском

Несколько редко используемых, но вполне полезных функций MSSQL. Если вы никогда не слышали о функциях CHOOSE, ROW_NUMBER, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, LAG, LEAD, PERCENTILE_CONT и PERCENTILE_DISC, то ниже вы узнаете, какие полезные вещи можно сделать их помощью. Так же, я покажу несколько примеров использования выражений OVER и PARTITION BY в оконных функциях.

Read more...

Useful Constraints Read in English

Usually we use constraints to specify the allowable values for the columns in tables. And it works perfectly! But beyond that, constraints help query analyzer to generate more effective query plans. How does it work? Read below.

Read more...

Patterns: Retry vs Circuit Breaker Read in English

Today I want to tell you about two interesting patterns: Retry and Circuit Breaker. They look the same at first sight, but they are used for solving different problems.

Read more...