User A-K

32 votes

Accepted

Unit testing of stored procedures

best-practices unit-test

answered Jul 18, 2012 at 13:48

25 votes

Can I add a unique constraint that ignores existing violations?

answered Jun 4, 2013 at 21:06

17 votes

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

sql-server sql-server-2008 database-design aggregate materialized-view

answered Jun 16, 2012 at 19:42

15 votes

Accepted

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

sql-server deadlock

answered Mar 15, 2013 at 20:37

14 votes

Passing array parameters to a stored procedure

sql-server sql-server-2008

answered Feb 7, 2012 at 14:33

14 votes

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

sql-server sql-server-2008 sql-server-2008-r2 sql-server-2012

answered Mar 12, 2012 at 18:18

13 votes

How do you test for race conditions in a database?

concurrency testing

answered Mar 28, 2012 at 20:03

12 votes

Why are numbers tables "invaluable"?

sql-server

answered Jan 25, 2012 at 20:28

12 votes

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

sql-server oracle

answered Jan 3, 2012 at 3:21

11 votes

Is NOLOCK always bad?

sql-server locking nolock

answered Jan 14, 2012 at 3:01

11 votes

Accepted

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

sql-server t-sql functions

answered Feb 9, 2012 at 20:26

11 votes

Managing concurrency when using SELECT-UPDATE pattern

sql-server locking concurrency isolation-level

answered Feb 12, 2012 at 1:54

11 votes

ALTER TABLE CHECK CONSTRAINT

sql-server-2008 check-constraints

answered Sep 13, 2012 at 20:20

10 votes

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

sql-server terminology row record

answered Jan 17, 2013 at 3:29

9 votes

Accepted

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

t-sql functions

answered Nov 6, 2012 at 3:00

9 votes

Accepted

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

database-design foreign-key referential-integrity

answered May 15, 2012 at 16:08

8 votes

Merge statement deadlocking itself

sql-server sql-server-2008-r2 deadlock merge

answered Sep 3, 2012 at 17:19

8 votes

Are these two queries logically equivalent?

sql-server query performance query-refactor query-performance

answered Oct 17, 2012 at 15:33

8 votes

Accepted

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

sql-server-2008 profiler

answered Mar 21, 2012 at 21:10

8 votes

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

database-design sql-server-2008-r2

answered Jan 24, 2013 at 3:24

7 votes

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

database-design rdbms

answered Jan 29, 2013 at 14:26

7 votes

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

identity naming-convention

answered Apr 17, 2012 at 14:23

7 votes

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

database-design

answered Feb 23, 2012 at 3:48

7 votes

Easily show rows that are different between two tables or queries

sql-server sql-server-2008 except

answered Feb 9, 2012 at 20:32

7 votes

Most Efficient Way to Retrieve Date Ranges

sql-server performance query-performance

answered Jan 4, 2012 at 3:32

7 votes

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

sql-server trigger

answered Jan 5, 2012 at 1:27

7 votes

Alter table on live production databases

mysql postgresql alter-table

answered Oct 18, 2012 at 13:58

7 votes

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

sql-server t-sql style

answered May 24, 2012 at 1:48

6 votes

Anybody using HierarchyId in production? Is it reliable?

sql-server sql-server-2008 hierarchy

answered May 10, 2012 at 17:57

6 votes

When should you denormalize?

database-design

answered Mar 29, 2012 at 14:22

Stack Exchange Network

current community

your communities

more stack exchange communities

96 Answers

Unit testing of stored procedures

Can I add a unique constraint that ignores existing violations?

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

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

Passing array parameters to a stored procedure

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

How do you test for race conditions in a database?

Why are numbers tables "invaluable"?

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

Is NOLOCK always bad?

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

Managing concurrency when using SELECT-UPDATE pattern

ALTER TABLE CHECK CONSTRAINT

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

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

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

Merge statement deadlocking itself

Are these two queries logically equivalent?

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

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

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

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

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

Easily show rows that are different between two tables or queries

Most Efficient Way to Retrieve Date Ranges

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

Alter table on live production databases

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

Anybody using HierarchyId in production? Is it reliable?

When should you denormalize?