James

Age: 37

DBA/developer. Mostly SQL Server. Ex-sysadmin.

Apr
10
awarded Supporter
Mar
25
awarded Autobiographer
Mar
20
awarded Supporter
Mar
13
comment How to reproduce "Could not continue scan with NOLOCK due to data movement"
The answers and comments address the underlying problem well, but are you still interested in finding a way to reproduce this as an intellectual exercise?
Mar
3
awarded Yearling
Mar
3
awarded Yearling
Feb
25
accepted "Access is denied" when connecting SSMS to Integration Services
Feb
13
awarded Famous Question
Dec
27
awarded Autobiographer
Dec
27
accepted Is the eager spool operator useful for this delete from a clustered columnstore?
Dec
26
comment Is the eager spool operator useful for this delete from a clustered columnstore?
Thanks @MartinSmith. Any idea what AccCard would be? Ascending column cardinality cardinality perhaps?
Dec
21
revised Is the eager spool operator useful for this delete from a clustered columnstore?
added 55 characters in body
Dec
21
awarded Nice Question
Dec
20
revised Is the eager spool operator useful for this delete from a clustered columnstore?
added 748 characters in body
Dec
18
revised Is the eager spool operator useful for this delete from a clustered columnstore?
added 258 characters in body
Dec
18
revised Is the eager spool operator useful for this delete from a clustered columnstore?
added 258 characters in body
Dec
17
asked Is the eager spool operator useful for this delete from a clustered columnstore?
Nov
18
awarded Good Question
Nov
18
accepted Is sys.stats_columns incorrect?
Nov
16
awarded Autobiographer
1 2 3 4 5