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

Feb
1
answered Query the Differential Changed Maps in SQL Server
Feb
1
answered How is SQL Server returning both a new value and old value during an UPDATE?
Jan
12
answered 'Tempdb' is full warning message in SQL Server 2005
Dec
18
answered Moving primary key constraint from one index to another
Dec
16
answered SQL Server 2012 32 bit - will enabling locked pages allow it to use more memory?
Dec
15
answered In case of multiple updates of the same record in a single transaction, how many versions are being stored?
Dec
15
answered “When a connection is closed and returned to the pool, the isolation level from the last SET TRANSACTION ISOLATION LEVEL statement is retained”?
Dec
15
answered Why do row-versioning isolations use a linked list of versions of record?
Dec
15
answered TempDB Version Store cleanup
Dec
12
answered Enforce Schema-bound views
Dec
5
answered Why does SQL Server require the datatype length to be the same when using UNPIVOT?
Nov
26
answered difference in execution plans on UAT and PROD server
Nov
4
answered Minimal Logging Conditions in SQL
Nov
1
answered Large difference in disk space used by partitions
Oct
31
answered Index not making execution faster, and in some cases is slowing down the query. Why is it so?
Oct
30
answered DBCC show_statistics: density doesn't match what I calculate
Oct
30
answered Syntax of INNER JOIN nested inside OUTER JOIN vs. query results
Oct
29
answered GROUP BY with MAX versus just MAX
Oct
29
answered join syntax / style performance consideration
Oct
28
answered Index on Persisted Computed column needs key lookup to get columns in the computed expression