Reputation
573
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 16
Impact
~65k people reached

10h
awarded  Popular Question
Jun
1
awarded  Notable Question
Apr
30
awarded  Popular Question
Mar
26
revised Is it possible to get seek based parallel plan for distinct/group by?
answer from ypercube
Mar
26
comment Is it possible to get seek based parallel plan for distinct/group by?
Looks like that works! Posting it.
Mar
26
revised Is it possible to get seek based parallel plan for distinct/group by?
forgot a max() in cross apply
Mar
26
revised Is it possible to get seek based parallel plan for distinct/group by?
forgot a max() in cross apply
Mar
26
asked Is it possible to get seek based parallel plan for distinct/group by?
Mar
16
comment SQL Server Cannot drop database <dbname> because it is currently in use… but no sessions displayed
The link is currently broken.
Jan
23
comment Query taking non-consistent time to execute
Please also check the BIOS Settings and Windows Power Management settings on both the server and client. For benchmarking they are probably best set at max performance to avoid CPU Throttling.
Dec
16
awarded  Self-Learner
Nov
22
awarded  Popular Question
Nov
13
comment How to clear an Error 15404 after a DB restart (besides rebooting)
Possibly related, we also have an intermittent (weekly) cannot generate SSPI problem on two different servers.
Nov
12
awarded  Popular Question
Nov
7
awarded  Excavator
Nov
7
revised How can I help SQL Server recognize my indexed view column is NOT NULL-able?
Clarify the question headline to "indexed" view to match his example. (Non-indexed view would have a solution.)
Nov
7
comment How can I help SQL Server recognize my indexed view column is NOT NULL-able?
This also appears to be an issue in a recursive cte when recursing on a non-nullable field (no aggregate) although an IsNull(..., 0) at the end can cure.
Nov
7
suggested approved edit on How can I help SQL Server recognize my indexed view column is NOT NULL-able?
Oct
4
comment When should I use a unique constraint instead of a unique index?
Good to see the where clause benefit mentioned.
Aug
23
asked What are recommended (working) permissions for a user to view all SQL Agent jobs