AlexKuznetsov

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

Developer


91 Answers

newest activity votes
2
Gaps and islands: client solution vs T-SQL query
1
Issue with ROW_NUMBER and DISTINCT
4
Handling concurrent access to a key table without deadlocks in SQL Server
0
Inserting and updating and selecting at thousands of times per second
1
Indexing strategy when using the between operator SQL Server 2008
4
Symmetric self-referential many-to-many
1
SQL Server 2008 and extended properties
1
SQL Server Select Count READ_COMMITTED_SNAPSHOT QUESTION
2
Relationship that are optionally more specific
7
Is it OK to keep a value which updates in a table?
1
Returning rows where all non-NULL values are equal
3
Importance of ER Diagrams
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?
4
With the advent of integrated source control, do stored procedure changes still need comments?
4
Finding violations of the symmetry constraint
3
MySQL unique constraint across two columns
8
T SQL Table Valued Function to Split varbinary(max) into 16byte GUIDs
2
Writing a database analysis document
1
Filtering data ordered by rowversion
0
How do I query based on percentages of a subset of values?
2
How does the T-SQL optimizer handle “and false”
2
Alter table on live production databases
1
Optimisation of complex query - 100% cost index seek?
3
Alternate ways to increase column size
8
Are these two queries logically equivalent?
5
GROUP BY on a dependent field
3
Schema blocking in READ_COMMITTED_SNAPSHOT
1
Create index view with self join
0
Using Row_Number to find consecutive row count
1 2 3 4