A-K

A-K has asked 34 questions and find answers to 86 problems.

Stats

About

Developer

A-K questions

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?
How to run NUnit test fixtures serially?

A-K answers

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?
SQL problem - high volume trans and PK violation
Disable constraints during transaction
Minimum transaction isolation level to avoid "Lost Updates"
Is there a reason for a Primary Key column that would never be used?
Redundant Sorting for Aggregate Grouped-By Monotonic Function