Reputation
1,645
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
3 12 30
Impact
~82k people reached

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
13
comment Perform Join After Filter
To get a decent answer, I think you will probably need to post the schema for the view and tables (including indexes), a sample query you are having trouble with, and possibly some sample data.
Nov
13
comment Perform Join After Filter
One thing to consider: How much more efficient would filtering by testName before or during the join be? For example, what percentage of the table matches your example filter testName = 'someTestName', and is there an index that supports this search?
Oct
25
comment Virtualized SQL Server Memory Oddity
Hi there, you should read this, which is also mentioned in Shanky's answer, to understand what's happening. Unfortunately your answer is misleading and wrong. I think your question is good, though.
Oct
20
comment Cannot register SPN, error 0x80090350, state 4
As an aside, I'd be really uncomfortable running SQL Server as a forest, schema, or domain admin, but that's unrelated to your concern with Kerberos AFAIK. Probably best to continue in chat if there are any further comments at this point...
Oct
20
comment Cannot register SPN, error 0x80090350, state 4
In that case your best bet might be to work through one of the guides to troubleshooting Kerberos errors like this one.
Oct
20
comment Cannot register SPN, error 0x80090350, state 4
I think local system doesn't have network access, which might cause some issues for you. How many groups are those 6 groups members of? Any chance the server is having trouble contacting a domain controller, or there's another machine on the network with the same name as the DC or the SQL Server? Any more details at all in the application, security, or system logs on the server?
Oct
20
comment Cannot run Sql Server Agent jobs with PowerShell script
@jma73 It might be worth verifying permissions, but an access violation should be related to invalid use of memory rather than permissions (access denied).
Oct
20
revised Cannot run Sql Server Agent jobs with PowerShell script
added 432 characters in body
Oct
20
answered Cannot register SPN, error 0x80090350, state 4
Oct
20
answered Cannot run Sql Server Agent jobs with PowerShell script