Matthew

Matthew has asked 43 questions and find answers to 40 problems.

Stats

About

I love creating elegant software solutions to novel problems.

Data is the future. Optimization is not our enemy.

Matthew questions

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?
How can I generate email threads for outlook programmatically?
Column type and size for international country subdivisions (states, provinces, territories etc)
How to check files against TFS without getting latest?

Matthew answers

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?
select TOP (all)