Reputation
810
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 16
Newest
 Constituent
Impact
~13k people reached

1d
comment How is an idle SQL Server connection causing blocking?
Thanks, I'm looking into this now!
1d
comment How is an idle SQL Server connection causing blocking?
Thanks @JamesLupolt, I've set this up and will see what it turns up.
2d
asked How is an idle SQL Server connection causing blocking?
Aug
4
awarded  Constituent
Jul
29
awarded  Caucus
May
29
answered Initials separated by periods (e.g. J.E.F. Smith)
May
28
comment Can connect successfully to SQL Server Express but not SQL Server
Have you checked SQL Server Configuration Manager? It sounds like it could be a problem with one or more Client Protocols being disabled.
May
28
revised InnoDB Index Doesn't Fit in Memory
Moved additional info posted as answer into question.
May
28
suggested approved edit on InnoDB Index Doesn't Fit in Memory
May
28
comment Optimizing a query that performs worse on a smaller dataset
I understand but I'd encourage you to question if this is right; there are not many instances where the results of this query would provide valid information so it seems fairly likely that this was an error and should be fixed. In terms of optimization the difficulty will be that the size of the results set can vary dramatically based on the join, not just the number of rows/size of data.
May
28
revised Optimizing a query that performs worse on a smaller dataset
deleted 7 characters in body
May
28
answered Optimizing a query that performs worse on a smaller dataset
May
28
reviewed Reviewed Optimizing a query that performs worse on a smaller dataset
May
27
awarded  Organizer
May
27
revised Troubleshooting high disk read - buffer cache query
Tagged with SQL Server 2008 R2 (from comments)
May
27
suggested approved edit on Troubleshooting high disk read - buffer cache query
May
27
revised GROUP BY very slow when returning many rows
Formatted code-block as a code-block.
May
27
suggested approved edit on GROUP BY very slow when returning many rows
May
27
answered Is Primary Key Non Clustered recommended?
May
27
answered Find all tables that are related to a view recursively sql server