18,447 reputation
453103
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 4 months
seen 5 mins ago

Apr
30
answered How can I eliminate this costly index seek operation from my query?
Apr
23
answered Synchronization using triggers
Apr
18
answered In SQL Server, should I force a LOOP JOIN in the following case?
Apr
18
answered Shared locks taken under Read Committed Snapshot Isolation (RCSI)
Apr
14
answered Location of #th iteration of a character or a word in a sql text field
Apr
14
answered Why do Indexed Views not permit non-unique clustered indexes?
Apr
14
answered Full text index search returns an unexpected result
Apr
14
answered Running query progress indication
Apr
13
answered Variable numbers of parameters in a SqlClr UDF or Stored Proc
Apr
12
answered SMS Suggesting covering all columns in an index?
Apr
11
answered Making a recursive CTE like query, but for many records
Apr
11
answered Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
Apr
11
answered Deadlock when update different rows with non-clustered index
Mar
14
answered Query tuning to meet timeout settings
Mar
10
answered Lock CREATE TABLE
Feb
27
answered Count Data on Third Table Through Link
Feb
21
answered Insert to SQL Azure through Linked Server very slow
Feb
13
answered Why does query error with empty result set in SQL Server 2012?
Feb
12
answered How, when and why does implicit changing of transaction isolation level happen?
Feb
7
answered SQL Calculated Field in both SELECT and GROUP BY clause