23,647 reputation
872143
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 4 years
seen 4 hours ago

Jan
5
comment How to avoid Forced reboots using unattended upgrades to SQL Server 2014
The KB link is as much for future visitors as anything. If I were more expert on the topic, I'd add an answer. Perhaps I will anyway :)
Jan
5
comment Zero rows updated while archiving rows
PRINT ERROR_MESSAGE() in the CATCH block should help you debug the issue.
Jan
5
comment How to avoid Forced reboots using unattended upgrades to SQL Server 2014
That advice was an early, and risky, workaround for a SQL Server 2008 issue. The supported solution is here: support.microsoft.com/kb/2008982
Jan
5
reviewed Edit Chunk Size is shown as 1 KB in mongo db logs even it is set to 300 MB
Jan
5
revised Chunk Size is shown as 1 KB in mongo db logs even it is set to 300 MB
In-lined link, minor formatting
Jan
5
reviewed Reject How do I list all columns for a specified table
Jan
5
reviewed No Action Needed MySQL cluster error: “Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock”
Jan
5
reviewed No Action Needed Which design to choose
Jan
5
reviewed Reviewed Find difference between two database and output them in a script sql
Jan
5
reviewed Reviewed What is the difference between Primary key and Super key in DBMS
Jan
5
revised What is the difference between Primary key and Super key in DBMS
Formatting
Jan
5
reviewed No Action Needed Error when trying to deploy SSIS package
Jan
5
reviewed Reviewed Server version (5.5.40-MariaDB) does not match with the version of the server (10.0.15-MariaDB) with which this program was built/distributed
Jan
5
reviewed Reviewed Specified key was too long; max key length is 1000 bytes in mysql 5.6
Jan
4
reviewed Leave Closed Powershell Output Help
Jan
4
comment At What Point Should I Split or Partition a Very Large but Simple Table
I highly recommend the MCM training video on partitioning by Kimberly Tripp.
Jan
4
revised Listing expired SQL logins
Copy edit
Jan
4
reviewed Leave Open 4 tables, find department with the highest average salary
Jan
4
reviewed Close Writing Conditions in Left join sql
Jan
4
reviewed Reviewed Drop database owned by specific user in PostgreSQL