Matthew

Matthew has asked 49 questions and find answers to 44 problems.

Stats

About

I love creating elegant software solutions to novel problems.

Data is the future. Optimization is not our enemy.

Matthew questions

Using Response.TransmitFile for physical file not working
What happens when I update SQL column to itself? -OR- simplified conditional updates?
Given an unzoned DateTime and a timezone, how can I construct an instant in NodaTime?
Does @@IDENTITY in an SP using triggers result in a race condition?
What should return if a client issues a DELETE to a web API resource which doesn't exist
How do I assign a delegate extension method in c#?
When is it more appropriate to assign a new list than to .Clear() an existing list?
How should I populate a MemoryCache without instantiating the object to be cached unneccesarily?
TSQL Parent > Child > Sub-Child duplication without cursor
Can I make SQL Server FORMAT deterministic?

Matthew answers

Using Response.TransmitFile for physical file not working
Sql Server Contains
Why does this MySQL query return 0 results
Is there a "proper" order for listing languages?
Quick search on huge mysql database
multiple threads in for each loop
Sorting null-data last in database query
TSQL Parent > Child > Sub-Child duplication without cursor
Getting the min() of a count(*) column
How to use List<int> as SQL parameter in C# [duplicate]