Reputation
609
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 17
Newest
 Yearling
Impact
~71k people reached

Aug
21
awarded  Yearling
Aug
3
comment Handling concurrent access to a key table without deadlocks in SQL Server
Is IDName unique? Then reccommend "create unique nonclustered index". However if you need null values then the index would also need to be filtered.
Aug
3
awarded  Constituent
Aug
3
awarded  Caucus
Aug
1
answered Effiiency of multiple OR predicates versus a single range
Jul
6
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?
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.)