Matthew

Matthew has asked 46 questions and find answers to 41 problems.

Stats

About

I love creating elegant software solutions to novel problems.

Data is the future. Optimization is not our enemy.

Matthew questions

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?
How can I select multiple copies of the same row?
Can I use events to signal between applications?
Can I use Ninject to instantiate singleton services that nothing depends on?

Matthew answers

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]
Explode range of integers out for joining in SQL
Join Date and Time to DateTime in VB.NET
What's the best way to lookup the US county a US city resides in?