Reputation
37,121
Next tag badge:
542/400 score
74/80 answers
Badges
8 97 156
Newest
 Enlightened
Impact
~1.4m people reached

Dec
30
revised How can I find a table in the whole instance?
deleted 18 characters in body
Dec
30
awarded  Nice Answer
Dec
30
comment SQL Server 2012 - Deadlock happening daily
It doesn't seem to be anything to do with DBCC or Ola's scripts. The select query in SP_GRPVIEW_LOAD is deadlocking with an Update query in sp_regvisit_save - UPDATE appointment SET ap_is_current = 0 WHERE ap_id = @vlngCurApId
Dec
30
revised How can I find a table in the whole instance?
added 86 characters in body
Dec
30
comment How can I find a table in the whole instance?
@AA.SC - It doesn't. It just tests for the existence of a specific object. [dbname].[dbo].[costomersHR] for each online database by substituting in the database name. The OBJECT_ID function returns NULL if it doesn't exist.
Dec
30
revised How can I find a table in the whole instance?
added 33 characters in body
Dec
30
answered How can I find a table in the whole instance?
Dec
28
awarded  Enlightened
Dec
28
awarded  Nice Answer
Dec
28
revised Are unfixable spatial index corruptions considered normal?
added 180 characters in body
Dec
28
revised Are unfixable spatial index corruptions considered normal?
added 577 characters in body
Dec
28
answered Are unfixable spatial index corruptions considered normal?
Dec
27
comment Cannot access a temporary table?
Temp tables are scoped to a connection. Presumably it ends up opening a second connection.
Dec
27
comment What is most efficient way to compare two large record sets in SQL Server 2012
@WillHealey #temp tables have a lot of advantages over table variables (statistics, parallelism, more flexible indexing) so if you aren't using this in a context where you are restricted to Table variables you could try those too.
Dec
27
revised NonClustered Index Scan Problem
Moved info from comment to question
Dec
27
answered What is most efficient way to compare two large record sets in SQL Server 2012
Dec
26
revised Can't search for non-ascii characters
edited tags
Dec
26
comment Is the eager spool operator useful for this delete from a clustered columnstore?
@JamesLupolt No I couldn't come up with anything particularly convincing to me. Maybe the Acc is Accumulate or Access?
Dec
25
revised Procedure Cache Dropping
added 1178 characters in body
Dec
24
comment Is the eager spool operator useful for this delete from a clustered columnstore?
If I try OPTION (QUERYRULEOFF EnforceHPandAccCard) the spool disappears. I assume HP might be "Halloween Protection". However then trying to use that plan with a USE PLAN hint fails (as does trying to use the plan from the OPTIMIZE FOR workaround too)