2014s

Sgen to precompile classes for XmlSerializer

During my investigation of our ASP.NET application performance issue, I've found out that XmlSerializer may require a long warm-up. The first time, when it's used for a specific class (de-)serialization, can take up to 500 ms om my machine!

Read more...

SQL: produce resultset with N rows

Sometimes you need to produce a result set, which would contain N rows with numbers 1...N in each row. For example, I needed to calculate some statistics per week for N weeks starting from today and going back to the past.

Read more...

Nice way to kill your SQL Server

The short story about how to crash your complete system by missing one line of code in SQL Server stored procedure.

Read more...