Reputation
24,052
Next tag badge:
174/100 score
19/20 answers
Badges
8 74 144
Newest
 Necromancer
Impact
~393k people reached

Apr
5
answered Restoring database between different version of SQL Server (SoftwareVersionBuild)
Apr
5
answered How does SQL Server's optimizer estimate the number of rows in a joined table?
Mar
20
answered MAXDOP not working?
Feb
27
answered Subselect of MAX(Version) takes many minutes, though there are only ~20K records
Feb
27
answered Optimizing queries for 25+ million rows
Feb
15
answered Select a range of values
Jan
30
answered Execution Plans Differ for the Same SQL Statement
Jan
26
answered Same query sometimes uses a Table Spool
Jan
22
answered How do I update and insert specific set of rows to an existing table using Merge in SQL Server 2008 R2?
Jan
16
answered Deadlock due to concurrent updates (with SIU lock)
Jan
15
answered Would it be better for query plans to be split by statement for re-usability?
Jan
14
answered MERGE a UNION query results down to one row per KEY value
Jan
14
answered Error when using views on a linked server
Jan
13
answered Is there a (non-binary) MySQL collation that doesn't treat different mathematical symbols as the same character?
Jan
10
answered Why Model database in SQL Server is in FULL recovery mode
Jan
10
answered How to repair database consistency errors
Jan
10
answered Identity value jumps when restarting SQL Server
Jan
8
answered How can I make this query sargable?
Jan
8
answered SQL Server Index Update Deadlock
Jan
6
answered How to get average according to last update time?