18,370 reputation
453102
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 4 months
seen 3 hours ago

Jun
5
revised TRANSACTION ISOLATION LEVEL SNAPSHOT vs. TRUNCATE?
added 60 characters in body
Jun
5
revised Find Rows with the Minimum Date per Group
added 63 characters in body
Jun
5
revised Find Rows with the Minimum Date per Group
added 808 characters in body; edited tags; edited title
Jun
5
revised CONTAINS does not work with ROW_NUMBER
deleted 29 characters in body; edited title
Jun
5
revised Queries for unique names from a site table using multiple criteria
Formatting, title, tags
Jun
3
revised Search, filter and group across all columns in a tall and wide dataset quickly
added 46 characters in body
Jun
3
revised Search, filter and group across all columns in a tall and wide dataset quickly
added 41 characters in body
Jun
3
revised Search, filter and group across all columns in a tall and wide dataset quickly
Improved title and tags
Jun
3
revised Running MongoDB and SQL Server on the same host- memory pressure
added 263 characters in body
Jun
2
revised Deadlock on Delete Statement
Added blog post link
Jun
2
revised SQL Server Database Mail Log is flooded with errors (20-30 per second) when mail server goes down
edited tags
Jun
2
revised Error while taking backup in SQL Server
edited tags
Jun
2
revised Possible schema corruption. Run DBCC CHECKCATALOG
edited tags
Jun
2
revised Why is the ORDER BY clause in a view ignored as soon as it's called with a WHERE claue?
edited tags
May
31
revised Is there a good way to link tables and sequences?
Improved SQL Server information and terminology
May
30
revised query to update status column with 1 to 0 and 0 to 1.?
deleted 4 characters in body
May
29
revised Splitting a deck of cards, and returning the results as if they were shuffled once
deleted 30 characters in body
May
29
revised How can I count different types in a column in sql?
edited tags
May
29
revised Splitting a deck of cards, and returning the results as if they were shuffled once
edited body
May
29
revised Splitting a deck of cards, and returning the results as if they were shuffled once
Improved title and tags