Reputation
1,742
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
2 14 30
Newest
 Nice Answer
Impact
~169k people reached

Apr
22
awarded  Nice Answer
Apr
20
awarded  Popular Question
Feb
9
comment Fast reads without paying the price on writes
For the async process consider cdc as it runs off the transaction log, so doesn't lock your staging table (you can then add indexes to the cdc table to optimise reads)
Feb
9
comment SQL Server Concurrency Issue
It sounds to me like you're trying to have multiple threads 'process' the same source data, this is solvable by creating a thread assignment/ownership pattern. But like the other comments more clarification is required.
Jan
20
comment SQL Server 2008 posibilities of having views from one database in another database?
This depends on the ownership chain (see: msdn.microsoft.com/en-us/library/ms188676.aspx), it is safest to grant connect permission to the both databases, and select permission against your view
Jan
17
awarded  Yearling
Jan
7
awarded  Informed
Dec
27
answered Key/Value table with limiters
Sep
28
awarded  Popular Question
Jul
28
awarded  Caucus
May
20
awarded  Good Question
Mar
31
revised Hindrance in TSQL SVF Call
added link to article with extra info
Mar
30
revised Hindrance in TSQL SVF Call
edited body
Mar
30
answered Hindrance in TSQL SVF Call
Mar
6
awarded  Famous Question
Feb
19
comment Why does SUM() return 0 when no rows in table?
@ypercube You're right, my mistake (I'd just deleted my comment because I was wrong)
Feb
19
revised Why does SUM() return 0 when no rows in table?
looked back on some emails I'd sent in the past and corrected my check, I've been saying If the value is still NULL handle it... (handles no rows as well as assigned NULL)
Feb
19
accepted Why does SUM() return 0 when no rows in table?
Feb
19
comment Why does SUM() return 0 when no rows in table?
My memory is that SQL Server 2005 and earlier used to not return any row if no GROUP BY was specified (a google and stackoverflow search indicates that other people had the same experience), do you know when/why it changed?
Feb
17
comment Why does SUM() return 0 when no rows in table?
Another related: dba.stackexchange.com/questions/25435/…