AlexKuznetsov

less info
meta site favicon meta user | stack exchange network profile network profile
3,617 reputation
1820
bio website sqlblog.com/blogs/…
location Chicago, IL
age
visits member for 1 year, 5 months
seen 7 hours ago
stats profile views 233

Developer


91 Answers

newest activity votes
16
Unit testing of stored procedures
12
Passing array parameters to a stored procedure
9
What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?
9
Managing concurrency when using SELECT-UPDATE pattern
9
Is NOLOCK always bad?
8
T SQL Table Valued Function to Split varbinary(max) into 16byte GUIDs
8
Are these two queries logically equivalent?
7
Is it OK to keep a value which updates in a table?
7
Best way to index a table with two datetime columns that are equally queried
6
What is the difference between a “record” and a “row” in SQL Server?
6
Commercial database systems versus open source database systems
6
SQL Server: How can I read server-side traces with limited permission?
6
Tables with hierarchy: create a constraint to prevent circularity through foreign keys
6
Should you design the database before the application code is written?
6
Why are numbers tables “invaluable”?
5
GROUP BY on a dependent field
5
Does it make sense to use SQL Server's bracket notation in hand written code?
5
Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?
5
Storing date as integer (numeric), what are the advantages
5
How to make a transition from SQL Server DBA to Oracle?
4
Handling concurrent access to a key table without deadlocks in SQL Server
4
Symmetric self-referential many-to-many
4
With the advent of integrated source control, do stored procedure changes still need comments?
4
Finding violations of the symmetry constraint
4
Unique foreign key constraint between three tables
4
Total of orders open on a given date for each date in a date range
4
CROSS JOIN with temp table and CASE statement
4
UDF in check constraint — downside?
4
Why do people recommend not using the name “Id” for an identity column?
4
How do you test for race conditions in a database?
1 2 3 4