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

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
May
28
revised Deadlock on Delete Statement
added 482 characters in body
May
23
revised Drawbacks of storing files in a database
added 50 characters in body; edited tags; edited title
May
22
revised Trigger to audit table changes
markup code examples, formatting, tags
May
19
revised Does MySQL guarantee atomic upgrade from read lock to write lock?
Corrected language tag
May
17
revised Reference implementation of a scalable storage system with strong consistency?
added 255 characters in body
May
15
revised Giving server-role to login breaks stored procedures
added 237 characters in body