meta user
network profile
| bio | website | sqlblog.com/blogs/paul_white/… |
|---|---|---|
| location | New Zealand | |
| age | 43 | |
| visits | member for | 2 years, 2 months |
| seen | May 14 at 21:59 | |
| stats | profile views | 1,334 |
Blog: SQLblog.com Twitter: @SQL_Kiwi
|
Nov 30 |
revised |
How to Convert Horizontal to Vertical Array? edited body; edited tags |
|
Nov 30 |
comment |
Could not continue scan with NOLOCK due to data movement @RemusRusanu That's interesting to know, thanks. I assume from your wording that there are still cases in 2012 where 601 will still occur? |
|
Nov 30 |
reviewed | Reviewed Enabling “log_queries_not_using_indexes” disables “long_query_time”? |
|
Nov 30 |
comment |
How to Convert Horizontal to Vertical Array? Could you edit your question to include the expected output for the sample data please? |
|
Nov 30 |
reviewed | Approve suggested edit on Replication master binlog rotation when network is unavailable |
|
Nov 30 |
revised |
How to Convert Horizontal to Vertical Array? added 259 characters in body; edited tags; edited title |
|
Nov 30 |
comment |
SQL 2008 RTM Temp Tables The tempdb objects are likely cached temporary tables and table variables. Not something I would be concerned about. |
|
Nov 30 |
reviewed | Reviewed Replication master binlog rotation when network is unavailable |
|
Nov 30 |
revised |
Replication master binlog rotation when network is unavailable deleted 125 characters in body; edited title |
|
Nov 30 |
reviewed | Reviewed Could not continue scan with NOLOCK due to data movement |
|
Nov 30 |
comment |
Could not continue scan with NOLOCK due to data movement The possibility of error 601 is unavoidable when performing scans at READ UNCOMMITTED isolation level in any version of SQL Server. The 'solution' is either to use a different isolation level or handle the error gracefully (as you might do for a deadlock). |
|
Nov 30 |
answered | Why SQL Server doesn't support foreign key constraints on views? |
|
Nov 30 |
comment |
Why does ALTER COLUMN to NOT NULL cause massive log file growth? SQL Server 2012 Enterprise adds the ability to add a NOT NULL column with a default as a metadata operation. Also see "Adding NOT NULL Columns as an Online Operation" in the documentation. |
|
Nov 30 |
comment |
Can this SQL be made more efficient and combined into one select? +1 and I also strongly agree with your comments elsewhere that the original temporary table solution was probably 'better' in the sense that it is more optimizer-friendly and particularly more likely to produce more efficient/stable execution plans as things change over time. |
|
Nov 30 |
answered | How to force the use of row locks? |
|
Nov 30 |
reviewed | Reviewed How do I list all databases and tables using psql? |
|
Nov 30 |
reviewed | Looks Good innodb changing row format doesn't decrease table size? |
|
Nov 30 |
comment |
innodb changing row format doesn't decrease table size? It is perfectly OK to ask and answer you own question but it would be even better if you could explain a little more about why this solution worked for you, to help future readers with a similar problem. |
|
Nov 30 |
reviewed | Approve suggested edit on Take individual MySQL database offline |
|
Nov 30 |
reviewed | Edit suggested edit on Is SET INTEGRITY of any use after IMPORT statements, or just after LOAD statements? |
