meta user
network profile
| bio | website | sqlblog.com/blogs/… |
|---|---|---|
| location | Chicago, IL | |
| age | ||
| visits | member for | 1 year, 6 months |
| seen | 15 hours ago | |
| stats | profile views | 240 |
Developer
|
Jun 14 |
comment |
How do these snapshot isolation level configurations interact on a SQL Server 2005 instance? There two different isolation levels, SNAPSHOT and READ_COMMITTED_SHAPSHOT. |
|
Jun 12 |
comment |
Postgres books for a Sql Server DBA I think this is a great question. I would love to see it answered here. I disagree with the votes to close. |
|
Jun 9 |
comment |
Running a DELETE stored procedure but finding degradation in performance in WHILE loop as iterations increase It may be much faster to copy the rows you want to keep into a new table, drop the old one, rename the new one. |
|
Jun 7 |
comment |
Importing data with a lot of SELECTS during transaction agreed, you right. |
|
Jun 6 |
comment |
select top x works, but x+1 runs endlessly Use snapshot isolation, and you will not have such problems. |
|
Jun 5 |
revised |
Relational database primary key requirements edited tags |
|
Jun 5 |
comment |
Can I add a unique constraint that ignores existing violations? @ypercube thank you! |
|
Jun 4 |
revised |
Can I add a unique constraint that ignores existing violations? edited tags |
|
Jun 4 |
answered | Can I add a unique constraint that ignores existing violations? |
|
Jun 4 |
awarded | Necromancer |
|
May 28 |
awarded | Constituent |
|
May 16 |
awarded | Self-Learner |
|
May 13 |
awarded | Caucus |
|
May 13 |
comment |
Gaps and islands: client solution vs T-SQL query @MarkStorey-Smith I apologize for the delay: I needed to complete a project. |
|
May 2 |
awarded | Popular Question |
|
Apr 18 |
comment |
Only allow one checked row in a Column in SQL Server Remus, this is a common requirement. For example, I have a large to-do list, but there is at most one thing I am working on right now. |
|
Apr 18 |
comment |
Only allow one checked row in a Column in SQL Server +1 I would do the same thing. In fact, this is a common requirement. For example, I have a large to-do list, but there is at most one thing I am working on right now. |
|
Apr 17 |
comment |
Unique Constraint with multiple null columns I cannot figure out what your problem is. Can you post your CREATE TABLE statemnts? |
|
Apr 12 |
comment |
Would using timestamps solve consistency issues with snapshot isolation? I would not ever suggest turning on READ_COMMITTED_SNAPSHOT at the database level, at least not without very serious code review, because it can introduce lots of subtle bugs. |
|
Apr 9 |
comment |
Hash in SQL query What is your RDBMS? |
