20,379 reputation
459112
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 7 months
seen 2 hours ago

Sep
18
revised Sum of two columns from pivot
deleted 25 characters in body; edited tags
Sep
18
revised Unable to SQL => Getting content of last 7 days
code formatting
Sep
17
revised Translate SQL Server update statement to MySQL
added 154 characters in body; edited tags; edited title
Sep
17
revised Can you use COUNT DISTINCT with an OVER clause?
added 35 characters in body
Sep
16
revised Can you use COUNT DISTINCT with an OVER clause?
added 296 characters in body
Sep
16
revised SQL Server 2012 Transparent Data Encryption and indexes
added 274 characters in body
Sep
16
revised Switching Data In Fails with “allows values that are not allowed by check constraints or partition function on target table”
edited tags
Sep
15
revised Is database record access sequential after retrieving the indexed page from disk?
added 265 characters in body; edited title
Sep
15
revised Turning off auto growth for particular file
Improved title, tags, removed "thanks"
Sep
15
revised Is database record access sequential after retrieving the indexed page from disk?
edited tags
Sep
15
revised Very Slow MySql Stored Procedure
code formatting and copy edit
Sep
15
revised Copy whole table to another database
added 21 characters in body; edited tags; edited title
Sep
14
revised Peer Review of Database Design
added 4049 characters in body; edited tags
Sep
10
revised Does the system process slow down my Database access?
Added 'answer' text to the question
Aug
23
revised Reduce space used on C drive
deleted 21 characters in body; edited tags; edited title
Aug
21
revised How to back out of mass update in SQL Replication
Formatting
Aug
19
revised Strange behaviours with SET options in SSMS
deleted 65 characters in body; edited tags; edited title
Aug
17
revised Searching a big table for a few results without scanning the whole table
added 25 characters in body; edited tags
Aug
16
revised What is a good way to copy data from one Cassandra ColumnFamily to another on the same Keyspace (like SQL's INSERT INTO)?
added 10 characters in body
Aug
15
revised Why is SQL Server's online indexing causing blocking?
added 830 characters in body