Reputation
33,097
Next tag badge:
503/400 score
72/80 answers
Badges
8 86 145
Newest
 Constituent
Impact
~1.1m people reached

Jul
10
comment Multiple indices on a table
So an index on InstanceId, Created, UserId would be equally good for query 1 and also satisfy query 2.
Jul
10
comment Multiple indices on a table
What is the query that misses index 1? Does it do an equality predicate on all three columns?
Jul
10
comment Can CLR execution continue after 'THROW' is encountered in T-SQL?
What happens if you read the stream to the end?
Jul
5
comment Cannot create a row of size XXXX which is greater than the allowable maximum row size of 8060
Please script out the CREATE TABLE and add it to your question.
Jul
4
awarded  Nice Answer
Jul
3
awarded  sql
Jul
3
answered Information about a column and the data it holds?
Jul
3
comment My SQL Server table identity is incrementing way too fast
@Kin - That isn't a bug. Just a change in behaviour. Seems unlikely though - would need 2 million service restarts to overflow an int.
Jul
3
comment My SQL Server table identity is incrementing way too fast
How many rows are inserted and deleted daily? Or attempted to insert?
Jul
2
comment SQL Server: UPDATE permission for table variable
Does the subquery itself work?
Jul
2
revised List of all missing order numbers that are not in the table
added 63 characters in body
Jul
2
comment List of all missing order numbers that are not in the table
@Jack - Yes - you need to add the column alias to the top of the except. See edited answer.
Jul
2
answered List of all missing order numbers that are not in the table
Jul
1
revised Suppressing the SSMS prompt to save changes
added 497 characters in body
Jul
1
revised Subquery magic in PostgreSQL
added 295 characters in body
Jul
1
comment What's the difference between “expression <=1.” and “expression <= 1”?
The lack of any 0 after the decimal point and the fact that decimal has higher datatype precedence than int so the constant would be implicitly cast anyway if needed would make me think that it is likely a typing error rather than deliberate.
Jul
1
revised What's the difference between “expression <=1.” and “expression <= 1”?
edited title
Jun
30
answered Subquery magic in PostgreSQL
Jun
30
answered Index performance on ON versus WHERE
Jun
30
revised Benefits of making a sql server database as read-only?
added 198 characters in body