AlexKuznetsov

Chicago, IL

sqlblog.com/blogs/alexander_kuznetsov/default.aspx

Developer

top accounts reputation activity favorites subscriptions

How do you unit test your T-SQL

sql-server database sql-server-2005 unit-testing sql-server-2008 asked May 4 '10 at 12:29

stackoverflow.com

14 votes

What do you do to make sure a new index does not slow down queries?

sql-server sql-server-2008 query-optimization sql-server-2008-r2 asked Sep 16 '11 at 20:58

stackoverflow.com

13 votes

Quickly load 350M numbers into a double[] array in C#

c# parallel-processing asked Jul 14 '10 at 20:26

stackoverflow.com

11 votes

Anybody using HierarchyId in production? Is it reliable?

sql-server sql-server-2008 hierarchical asked May 1 '12 at 14:07

dba.stackexchange.com

10 votes

Is this a bug in MERGE, failing to implement FOREIGN KEY properly?

sql-server sql-server-2008 sql-server-2008-r2 asked Oct 14 '11 at 18:21

stackoverflow.com

9 votes

Is there a set based way to load/read a tree branch with HierarchyId

sql-server sql-server-2008 sql-server-2008-r2 hierarchical asked May 9 '12 at 21:58

dba.stackexchange.com

8 votes

How to run NUnit test fixtures serially?

c# sql-server unit-testing nunit resharper asked Jun 21 '11 at 14:40

stackoverflow.com

8 votes

What is the actual lowest possible positive REAL number

sql-server sql-server-2008 sql-server-2008-r2 data-integrity asked Jul 2 '12 at 16:49

dba.stackexchange.com

7 votes

When inheriting from a class hurts you later?

c# inheritance oop asked Sep 5 '10 at 15:55

stackoverflow.com

7 votes

How to efficiently invoke table-valued parameters from Ado.Net

sql-server sql-server-2008 ado.net bulkinsert sqlbulkcopy asked Jun 10 '11 at 21:31

stackoverflow.com

Top Answers

How to change identity column values programmatically?

stackoverflow.com

Transaction Isolation Level Scopes

stackoverflow.com

When should I use Cross Apply over Inner Join?

stackoverflow.com

Unit testing of stored procedures

dba.stackexchange.com

How do I limit the acceptable values in a database column to be 1 to 5?

stackoverflow.com

Should programmers use SSIS, and if so, why?

stackoverflow.com

TSQL - Use a Derived Select Column in the Where Clause

stackoverflow.com

Passing array parameters to a stored procedure

dba.stackexchange.com

What does TOP 1 mean in an sql query?

stackoverflow.com

Database constraints - keep or ignore?

stackoverflow.com

Is NOLOCK always bad?

dba.stackexchange.com

Managing concurrency when using SELECT-UPDATE pattern

dba.stackexchange.com

What's the best practice of naming stored procedure for t-sql?

stackoverflow.com

Why are composite primary keys still around?

stackoverflow.com

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

dba.stackexchange.com

Are these two queries logically equivalent?

dba.stackexchange.com

T SQL Table Valued Function to Split varbinary(max) into 16byte GUIDs

dba.stackexchange.com

What are the common responses to “как дела?”

russian.stackexchange.com

Execution plan oddity after re-enabling foreign key constraint

stackoverflow.com

How will SQL Server perform this query behind the scenes

stackoverflow.com

User Defined Function Best Practice

stackoverflow.com

Best way to index a table with two datetime columns that are equally queried

dba.stackexchange.com

Is it OK to keep a value which updates in a table?

dba.stackexchange.com

What are synonyms for “срач”?

russian.stackexchange.com

Find number of concurrent users in a SQL records

stackoverflow.com

Why does the order of join clauses affect the query plan in SQL Server?

stackoverflow.com

Why finally block is not given in SQL SERVER?

stackoverflow.com

Why are numbers tables “invaluable”?

dba.stackexchange.com

Should you design the database before the application code is written?

dba.stackexchange.com

Tables with hierarchy: create a constraint to prevent circularity through foreign keys

dba.stackexchange.com