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

Dec
9
revised Skip sections that have GO
deleted 20 characters in body; edited tags
Dec
9
revised Create relationship between two tables with composite primary key
deleted 36 characters in body
Dec
8
revised Query to convert the count to million or thousands
Moved tag in title to tag
Dec
8
revised Deleting rows from a table with a very small amount of expansion space
added 41 characters in body
Dec
8
revised Deleting rows from a table with a very small amount of expansion space
deleted 4 characters in body; edited tags; edited title
Dec
8
revised Creating a Linked Server that Points to Itself
Removed tag in title, standardized tags, minor body edits
Dec
8
revised How to allow to execute stored procedures but not writes?
added 114 characters in body
Dec
8
revised How to allow to execute stored procedures but not writes?
added 479 characters in body
Dec
8
revised How to allow to execute stored procedures but not writes?
Tags; added comments to question
Dec
8
revised Estimated rows very wrong when using declared variables
added 166 characters in body
Dec
8
revised Clustered columnstore indexes and foreign keys
added 84 characters in body; edited tags; edited title
Dec
8
revised Materialized View
added 20 characters in body; edited tags; edited title
Dec
8
revised update multiple column from multiple tables
added 69 characters in body; edited tags
Dec
8
revised update multiple columns from multiple join tables with selected data from multiple tables in where condition
added 162 characters in body; edited tags
Dec
8
revised View designer strange join syntax
added 14 characters in body
Dec
8
revised Complex query for AVG and Sport values
added 65 characters in body
Dec
8
revised Full outer joins, coalescing, indexes and views
added 679 characters in body
Dec
8
revised A way to clear/restart virtual memory creep automatically?
deleted 2 characters in body; edited tags; edited title
Dec
7
revised Index and rows placement within database files
deleted 105 characters in body; edited title
Dec
7
revised Reuse a complex non-deterministic expression in SELECT and WHERE clauses
added 5 characters in body; edited tags; edited title