22,016 reputation
660119
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 9 months
seen 1 hour ago

Dec
5
revised Select rows with same id but null and some other value in another column for that id
Code formatting
Dec
5
revised Cascade primary key update to all referencing foreign keys
shortened title, removed tag in title, added tags
Dec
5
revised Unable to install
tags added
Dec
5
revised Select rows with same id but null and some other value in another column for that id
added 438 characters in body
Dec
5
revised Select rows with same id but null and some other value in another column for that id
added 526 characters in body
Dec
5
revised Select rows with same id but null and some other value in another column for that id
added 110 characters in body
Dec
4
revised optimizer wiki description
More details on what goes into optimizer decisions
Dec
2
revised How to recursively find gaps where 90 days passed, between rows
added 614 characters in body
Nov
24
revised Verify if user has read access to a table
Removed tag from title, completed tag hierarchy
Nov
18
revised Parallel Plan Selection
Improved title & tags
Nov
18
revised The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values
added 26190 characters in body
Nov
18
revised The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values
added 449 characters in body
Nov
17
revised TSQL substitute for MAX() string ranking
deleted 1 character in body
Nov
17
revised SQL Server Standard Edition Memory Limit
Removed shouting, paraphrased
Nov
17
revised Performance Order By large table with Join
edited tags
Oct
30
revised SQL Server Backup Job failed multiple times
Fixed code language
Oct
30
revised SQL server 2014 locks up on insert query, while SQL server 2000 runs fine
added 1983 characters in body; edited tags
Oct
30
revised Cancel Query in remote ssms from ssms in my pc
Added documentation link
Oct
30
revised How to List out all the tables on the SQL server which do not have a Clustered index?
Fixed reserved keyword
Oct
30
revised How to List out all the tables on the SQL server which do not have a Clustered index?
added 149 characters in body