Database Administrators
A-K
Meta user
Network profile
Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

97 Answers

Newest Activity Votes
32
Unit testing of stored procedures
Jul 18 '12 at 13:48
23
Can I add a unique constraint that ignores existing violations?
Jun 4 '13 at 21:06
15
Writing a simple bank schema: How should I keep my balances in sync with their transaction history?
Jun 16 '12 at 19:42
15
Handling concurrent access to a key table without deadlocks in SQL Server
Mar 15 '13 at 20:37
14
What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?
Mar 12 '12 at 18:18
14
Passing array parameters to a stored procedure
Feb 7 '12 at 14:33
12
Why are numbers tables “invaluable”?
Jan 25 '12 at 20:28
11
Managing concurrency when using SELECT-UPDATE pattern
Feb 12 '12 at 1:54
11
Is NOLOCK always bad?
Jan 14 '12 at 3:01
10
How do you test for race conditions in a database?
Mar 28 '12 at 20:03
10
Invalid use of a side-effecting operator 'INSERT' within a function - Multiple Inserts in Function
Feb 9 '12 at 20:26
10
How to make a transition from SQL Server DBA to Oracle?
Jan 3 '12 at 3:21
9
What is the difference between a “record” and a “row” in SQL Server?
Jan 17 '13 at 3:29
9
T SQL Table Valued Function to Split varbinary(max) into 16byte GUIDs
Nov 6 '12 at 3:00
9
Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?
May 15 '12 at 16:08
8
Best way to index a table with two datetime columns that are equally queried
Jan 24 '13 at 3:24
8
Are these two queries logically equivalent?
Oct 17 '12 at 15:33
8
Merge statement deadlocking itself
Sep 3 '12 at 17:19
8
SQL Server: How can I read server-side traces with limited permission?
Mar 21 '12 at 21:10
7
Is it OK to keep a value which updates in a table?
Jan 29 '13 at 14:26
7
ALTER TABLE CHECK CONSTRAINT
Sep 13 '12 at 20:20
7
Why do people recommend not using the name “Id” for an identity column?
Apr 17 '12 at 14:23
7
Should you design the database before the application code is written?
Feb 23 '12 at 3:48
6
Alter table on live production databases
Oct 18 '12 at 13:58
6
Commercial database systems versus open source database systems
Mar 29 '12 at 16:04
6
Storing date as integer (numeric), what are the advantages
Mar 27 '12 at 14:37
6
Tables with hierarchy: create a constraint to prevent circularity through foreign keys
Mar 5 '12 at 17:10
6
Easily show rows that are different between two tables or queries
Feb 9 '12 at 20:32
5
MySQL unique constraint across two columns
Nov 27 '12 at 21:04
5
Is there a way to ensure that a SQL Server trigger will be executed?
Jan 5 '12 at 1:27
1 2 3 4