August 4, 2015 at 2:54 pm
So it seems like we have an option between 'dirty' data (NOLOCK) and incomplete data (READPAST). I never knew about READPAST until today.
August 4, 2015 at 2:58 pm
Brian.Klinect (8/4/2015)
So it seems like we have an option between 'dirty' data (NOLOCK) and incomplete data (READPAST). I never knew about READPAST until today.
Except that NOLOCK can also be incomplete data if is doesn't return all the rows.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 5, 2015 at 5:22 am
Sean Lange (8/4/2015)
Brian.Klinect (8/4/2015)
So it seems like we have an option between 'dirty' data (NOLOCK) and incomplete data (READPAST). I never knew about READPAST until today.Except that NOLOCK can also be incomplete data if is doesn't return all the rows.
If someone learned something from the QOTD, then I'd say it did its job. 😉
August 5, 2015 at 6:36 am
Thanks for your question.
August 5, 2015 at 7:12 am
Ed Wagner (8/5/2015)
Sean Lange (8/4/2015)
Brian.Klinect (8/4/2015)
So it seems like we have an option between 'dirty' data (NOLOCK) and incomplete data (READPAST). I never knew about READPAST until today.Except that NOLOCK can also be incomplete data if is doesn't return all the rows.
If someone learned something from the QOTD, then I'd say it did its job. 😉
Yes indeed!!! 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 5, 2015 at 7:14 am
Sean Lange (8/5/2015)
Ed Wagner (8/5/2015)
Sean Lange (8/4/2015)
Brian.Klinect (8/4/2015)
So it seems like we have an option between 'dirty' data (NOLOCK) and incomplete data (READPAST). I never knew about READPAST until today.Except that NOLOCK can also be incomplete data if is doesn't return all the rows.
If someone learned something from the QOTD, then I'd say it did its job. 😉
Yes indeed!!! 😀
I completely agree! I've learned a lot over the past year from the QotD alone!
August 6, 2015 at 3:03 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 17, 2015 at 5:53 am
Simple One 🙂
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply