20,819 reputation
459113
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 8 months
seen 3 hours ago

Nov
18
revised Parallel Plan Selection
Improved title & tags
Nov
18
revised The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values
added 26190 characters in body
Nov
18
revised The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values
added 449 characters in body
Nov
17
revised TSQL substitute for MAX() string ranking
deleted 1 character in body
Nov
17
revised SQL Server Standard Edition Memory Limit
Removed shouting, paraphrased
Nov
17
revised Performance Order By large table with Join
edited tags
Oct
30
revised SQL Server Backup Job failed multiple times
Fixed code language
Oct
30
revised SQL server 2014 locks up on insert query, while SQL server 2000 runs fine
added 1983 characters in body; edited tags
Oct
30
revised Cancel Query in remote ssms from ssms in my pc
Added documentation link
Oct
30
revised How to List out all the tables on the SQL server which do not have a Clustered index?
Fixed reserved keyword
Oct
30
revised How to List out all the tables on the SQL server which do not have a Clustered index?
added 149 characters in body
Oct
30
revised SQL Server Backup Job failed multiple times
Formatting, tags, title
Oct
29
revised Paging in SQL Server: Is an order by clause required? (currently, rows are being missed)
edited tags
Oct
29
revised Physical Server or a Virtual Machine SQL Server?
Formatting
Oct
29
revised Query optimizer recommends adding index instead of using existing index
Added BOL documentation link
Oct
25
revised Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
deleted 10 characters in body
Oct
19
revised Auditing the View Server State permissions on Server
tagged version
Oct
17
revised SQL Profiler - Insert values?
Formatting, light copy edit, removed chat
Oct
16
revised Lost connection to MySQL server during query issue
Changed tag from sql server to mysql, formatted code
Oct
16
revised Can WAITFOR increase CXPACKET waits?
formatting and tags