23,721 reputation
873144
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 4 years
seen 17 mins ago

Jan
2
awarded  Nice Answer
Jan
2
reviewed Close Having troubles creating table SQL
Jan
2
comment Are “out of the row” fields read when a clustered index is used?
@gotqn Yes. Off-row was the default for the old LOB types text, ntext and image. You could also store the large types in a separate table, of course.
Jan
2
comment Are “out of the row” fields read when a clustered index is used?
@gotqn Correct.
Jan
2
revised Are “out of the row” fields read when a clustered index is used?
added 81 characters in body
Jan
2
comment Are “out of the row” fields read when a clustered index is used?
@gotqn The original question was a little unclear, so I took my best guess at what you were asking. Obviously, if the query has to return off-row data, it has to access that data. In that case, as the in-row structure is scanned, the off-row data is looked up per row (the pointer is followed).
Jan
2
comment Are “out of the row” fields read when a clustered index is used?
The full text in the original MSDN thread (by Jacob Sebastian) is correct. The Stack Overflow "quote" loses quite a bit of that. The small fraction of that you quoted above omits all the important bits :)
Jan
2
revised Are “out of the row” fields read when a clustered index is used?
added 197 characters in body
Jan
2
comment Are “out of the row” fields read when a clustered index is used?
Where did that last quoted bit come from? It is not correct.
Jan
2
answered Are “out of the row” fields read when a clustered index is used?
Jan
2
reviewed Approve Count multiple tables as one count
Jan
2
answered Understanding statistics, execution plans, and 'ascending key problem'
Jan
2
comment What is the most efficient method of performing the FIZZBUZZ test in SQL Server?
@MikaelEriksson Interesting. I deliberately chose not to use a hash index to avoid the sort. Live and learn.
Jan
2
revised Add a column with Not Null
edited tags
Jan
2
revised Join on dm_db_index_physical_stats very slow
added 3 characters in body; edited tags; edited title
Jan
2
answered Join on dm_db_index_physical_stats very slow
Jan
2
revised Why not rebuild indexes with page count <1000?
added 380 characters in body
Jan
2
reviewed Edit Connection error except with SQLYog
Jan
2
revised Connection error except with SQLYog
Formatting, title, tags, spelling
Jan
2
answered Why not rebuild indexes with page count <1000?