19,083 reputation
456107
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 5 months
seen 58 mins ago

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
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