| bio | website | sqlblog.com/blogs/paul_white/… |
|---|---|---|
| location | New Zealand | |
| age | 43 | |
| visits | member for | 2 years, 3 months |
| seen | 7 hours ago | |
| stats | profile views | 1,472 |

Blog: SQLblog.com Twitter: @SQL_Kiwi
|
Feb 18 |
revised |
What is a suitable index for this query? deleted 126 characters in body; edited tags; edited title |
|
Feb 18 |
revised |
Can someone explain why select with nolock will query a potion of updated data? edited tags |
|
Feb 18 |
revised |
Could not continue scan with NOLOCK due to data movement edited tags |
|
Feb 18 |
revised |
Justify NOT using (nolock) hint in every query edited tags |
|
Feb 18 |
revised |
repeatable read and nolock edited tags |
|
Feb 18 |
revised |
Is NOLOCK always bad? edited tags |
|
Feb 18 |
revised |
Execution of sequential delete and uncommitted read added 23 characters in body |
|
Feb 18 |
revised |
SQL Server Express in a shared hosting environment deleted 4830 characters in body; edited title |
|
Feb 18 |
revised |
Execution of sequential delete and uncommitted read deleted 24 characters in body; edited tags |
|
Feb 16 |
revised |
LIKE character length limitation added 194 characters in body; edited tags; edited title |
|
Feb 11 |
revised |
32-bit ODBC driver on 64-bit SQL Server added 93 characters in body |
|
Feb 11 |
revised |
32-bit ODBC driver on 64-bit SQL Server edited body; edited tags; edited title |
|
Feb 6 |
revised |
SQL Server Deadlock on two updates due to index lock order added 180 characters in body |
|
Jan 30 |
revised |
Slow query performance added 102 characters in body; edited tags; edited title |
|
Jan 29 |
revised |
SQL Server Indexing Performance in Unique/Duplicate column deleted 1 characters in body |
|
Jan 29 |
revised |
Returning rows where all non-NULL values are equal added 21 characters in body |
|
Jan 20 |
revised |
Can't create table with this script added 20 characters in body |
|
Jan 20 |
revised |
Run Unix command using PL/SQL Inlined links, minor formatting and language improvements |
|
Dec 24 |
revised |
Optimising plans with XML readers added 152 characters in body |
|
Dec 22 |
revised |
Optimising plans with XML readers edited tags; edited title |