15,345 reputation
44591
bio website sqlblog.com/blogs/paul_white/…
location New Zealand
age 44
visits member for 3 years, 1 month
seen 25 mins ago

Apr
11
revised Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
added 85 characters in body
Apr
11
comment Deadlock when update different rows with non-clustered index
@Bood I updated my answer to include your question about viewing lock sequences. Analyzing deadlocks in detail can be time-consuming and highly-skilled work. A certain level of deadlocking is often unavoidable; the application should be coded to cope with deadlocks anyway (e.g. recheck conditions and resubmit the transaction).
Apr
11
revised Deadlock when update different rows with non-clustered index
added 346 characters in body
Apr
11
comment Deadlock when update different rows with non-clustered index
@Bood The two references I provided at the bottom of my answer describe the common deadlock patterns well. You clearly have lots of questions about locking behaviour; if you still have questions after reading that information, please ask a new question for each, providing a clear explanation and preferable a complete reproduction script for us to use. Broad questions that require a lot of clarification comments do not fit the Q & A model well. We like discussion in the chat rooms, but not on the main site. Thanks.
Apr
11
comment Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
Note to close-voters: this is a SQLCLR question with a SQL Server-specific answer. Seems on-topic here.
Apr
11
answered Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
Apr
11
reviewed Leave Open Is PostgreSQL or ElasticSearch/Solr the right tool for this kind of query?
Apr
11
reviewed Leave Open Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
Apr
11
reviewed Close MySQL indexing types?
Apr
11
reviewed Looks Good How long will it take to import 28 millions rows in a MyISAM table?
Apr
11
reviewed Looks Good SQL query filled Temdb complete Harddisk
Apr
11
reviewed Close How long will it take to import 28 millions rows in a MyISAM table?
Apr
11
reviewed Close How does InnoDB store tables in ibdata file?
Apr
11
reviewed Approve suggested edit on What's the best way to get data for sampling points within a timeframe
Apr
11
reviewed Leave Open Should I create a new instance of amazon rds or just a new schema inside of it?
Apr
11
reviewed Leave Open Best suited combination of Oracle, JDK & OJDBC
Apr
11
reviewed Reviewed MySQL: Create index If not exists
Apr
11
answered Deadlock when update different rows with non-clustered index
Apr
10
revised Grouping Row Values Query
added 28 characters in body; edited tags; edited title
Apr
10
reviewed Looks Good Consecutive Rows to fetch from SQL server table