A-K

A-K has asked 36 questions and find answers to 94 problems.

Stats

About

Developer

A-K questions

How to efficiently left outer join two sorted lists
ADO.Net: reuse open SqlConnection or get a new one every time?
Is there a C++ unit testing library that is similar to NUnit?
Why is my CASE expression non-deterministic?
How to efficiently invoke table-valued parameters from Ado.Net
When inheriting from a class hurts you later?
How to specify ApplicationName in NpgSql connection string
Is this a bug in MERGE, failing to implement FOREIGN KEY properly?
Quickly load 350M numbers into a double[] array in C#
What do you do to make sure a new index does not slow down queries?

A-K answers

How to export SQL Server 2005 rows to excel? Everytime I do it I get errors
What problems have folks encountered sending DataTable / Collection to SQL Server using TVP [closed]
SQL Check Constraint for Multiple Columns
Make SQL Server use CHECK CONSTRAINT only on inserted or updated rows
SQL Server snapshot isolation level issue
"Catching" Errors from within a user defined function in SQL Server 2005
Cross Join followed by Left Join
return only the last select results from stored procedure
Does Indexing a View in Sql Server 2008 actually duplicate the original data?
Enforcing "zero-or-one to one" relationship on SQL database?