Reputation
31,059
Next tag badge:
478/400 score
71/80 answers
Badges
8 78 131
Newest
 Nice Answer
Impact
~883k people reached

Oct
21
revised Why does DELETE leave a lingering effect on performance?
added 139 characters in body
Oct
21
comment Disabling logging on certain tables
Related Connect Item Request
Oct
21
comment Why does DELETE leave a lingering effect on performance?
Well my theory is that it is the allocation of the 10,000+ pages which happens in a much more optimized way and seems to avoid some per page overhead. For smaller inserts I would expect any such difference to be less significant.
Oct
21
comment Why does DELETE leave a lingering effect on performance?
@RichardTheKiwi - The benefit of TRUNCATE over DELETE on its own would also argue for that. I would also rarely consider table variables for large numbers of rows.
Oct
21
revised Why does DELETE leave a lingering effect on performance?
added 1129 characters in body
Oct
21
answered Why does DELETE leave a lingering effect on performance?
Oct
20
reviewed Approve Partition guides and possible solutions?
Oct
20
reviewed Approve Storing application settings with different datatypes
Oct
20
comment Altering nullability of column in SQL Server
@a1ex07 the second example changes the length.
Oct
20
comment Fast XML, slow XML
@JonSeigel - You can also use Trace Flag 4130 if it is the same issue as per the Connect item. I am beginnining to doubt it though as in the issue there the plans are not the same. The slow one gets an unnecessary eager spool to the plan.
Oct
20
awarded  Enlightened
Oct
20
awarded  Nice Answer
Oct
20
answered Altering nullability of column in SQL Server
Oct
19
reviewed Approve Slow-running query on a new VM
Oct
19
reviewed Approve Preserving whitespace in MongoDB values
Oct
18
comment Where are Statistics physically stored in SQL Server?
When you create a statistics only copy of the database it shows a binary STATS_STREAM I've never looked into whether this is something findable in the file itself.
Oct
18
reviewed Approve Optimisation of complex query - 100% cost index seek?
Oct
18
comment Update Database Fields Based On Date
And one important point I forgot to mention is that you can't create a trigger that fires at a specific time anyway.
Oct
18
reviewed Approve Update Database Fields Based On Date
Oct
18
revised Are these two queries logically equivalent?
added 32 characters in body