222 reputation
27
bio website cridion.com
location Atlanta, GA
age 29
visits member for 2 years, 5 months
seen Nov 24 at 20:06

Programmer, scientist, thinker.


Sep
15
awarded  Nice Question
Aug
13
awarded  Yearling
Aug
13
accepted Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
Aug
13
comment Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
Thanks @RemusRusanu. While this example is partially contrived to demonstrate the changed behavior, your tip is one we'll keep in mind as we design our services and queues.
Aug
13
comment Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
@MaxVernon we're running 12.00.2370
Aug
13
revised Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
minor clarification
Aug
13
asked Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
Aug
13
accepted Efficiently Filter Large Set With Disjunctions
Aug
4
awarded  Notable Question
Apr
4
awarded  Popular Question
Aug
29
awarded  Scholar
Aug
29
accepted Quickly change NULL column to NOT NULL
Aug
29
comment Quickly change NULL column to NOT NULL
@MartinSmith I clarified what I mean by forever. I'm testing this in a dev environment with no other sessions hitting the database. It does eventually complete. But the answer that you linked explains why it takes so long. If you can reword your comment as an answer, then I'll accept it.
Aug
29
awarded  Editor
Aug
29
revised Quickly change NULL column to NOT NULL
edited for clarity
Aug
28
asked Quickly change NULL column to NOT NULL
May
16
comment Efficiently Filter Large Set With Disjunctions
@JonSeigel it depends on how much... but I want to see any suggestions
Feb
6
comment Efficiently Filter Large Set With Disjunctions
@Valkyrie that seems incredibly inefficient. Also consider that variants of this query (different parameters and different optional where clauses) will likely be executing several times a second all day long and need to return results on average in less than 100ms. We already do this, and it performs okay for now. I'm just looking for ideas on how to continue to improve performance for scalability.
Feb
5
awarded  Student
Feb
5
asked Efficiently Filter Large Set With Disjunctions