A-K

A-K has asked 35 questions and find answers to 91 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

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?
How can I enforce uniqueness on a NVARCHAR(MAX) column in SQL Server?
primary key duplicate record bypass to next insert
How can I avoid a deadlock between these two SQL statements?