user avatar
user avatar
user avatar
A-K
  • Member for 10 years, 7 months
  • Last seen more than 7 years ago
  • Chicago, IL
32 votes
Accepted

Unit testing of stored procedures

25 votes

Can I add a unique constraint that ignores existing violations?

17 votes

Writing a simple bank schema: How should I keep my balances in sync with their transaction history?

15 votes
Accepted

Handling concurrent access to a key table without deadlocks in SQL Server

14 votes

Passing array parameters to a stored procedure

14 votes

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

13 votes

How do you test for race conditions in a database?

12 votes

Why are numbers tables "invaluable"?

12 votes

How to make a transition from SQL Server DBA to Oracle?

11 votes

Is NOLOCK always bad?

11 votes
Accepted

Invalid use of a side-effecting operator 'INSERT' within a function - Multiple Inserts in Function

11 votes

Managing concurrency when using SELECT-UPDATE pattern

11 votes

ALTER TABLE CHECK CONSTRAINT

10 votes

What is the difference between a "record" and a "row" in SQL Server?

9 votes
Accepted

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

9 votes
Accepted

Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?

8 votes

Merge statement deadlocking itself

8 votes

Are these two queries logically equivalent?

8 votes
Accepted

SQL Server: How can I read server-side traces with limited permission?

8 votes

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

7 votes

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

7 votes

Why do people recommend not using the name "Id" for an identity column?

7 votes

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

7 votes

Easily show rows that are different between two tables or queries

7 votes

Most Efficient Way to Retrieve Date Ranges

7 votes

Is there a way to ensure that a SQL Server trigger will be executed?

7 votes

Alter table on live production databases

7 votes

Does it make sense to use SQL Server's bracket notation in hand written code?

6 votes

Anybody using HierarchyId in production? Is it reliable?

6 votes

When should you denormalize?