Timeline for Are explicit transactions needed in this while loop?

Current License: CC BY-SA 3.0

15 events

when toggle format	what		by	license	comment
Jun 7, 2017 at 16:07	comment	added	Solomon Rutzky		@BaconBits Agreed on starting simple. To be fair, these suggestions were not meant to apply to all scenarios. The question is about dealing with a very large (100 million+ rows) table.
Jun 7, 2017 at 15:05	comment	added	Bacon Bits		Your suggestions in #4 might be faster in some cases, but that seems like significant code complexity to add. I'd favor starting simple, and then if that doesn't meet your needs consider alternatives.
Apr 13, 2017 at 12:42	history	edited	CommunityBot		replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
Sep 17, 2015 at 19:33	history	edited	Solomon Rutzky	CC BY-SA 3.0	added info about filtered indexes
Sep 17, 2015 at 15:05	history	edited	Solomon Rutzky	CC BY-SA 3.0	added UPDATE
Sep 16, 2015 at 21:06	history	edited	Solomon Rutzky	CC BY-SA 3.0	added 578 characters in body
Sep 16, 2015 at 20:20	history	edited	Solomon Rutzky	CC BY-SA 3.0	added 921 characters in body
Sep 16, 2015 at 16:59	history	edited	Solomon Rutzky	CC BY-SA 3.0	added 26 characters in body
Sep 16, 2015 at 16:48	history	edited	Solomon Rutzky	CC BY-SA 3.0	added additional advice on how to improve the desired processing
Sep 16, 2015 at 16:11	history	edited	Solomon Rutzky	CC BY-SA 3.0	added 812 characters in body
Sep 16, 2015 at 16:04	history	edited	Solomon Rutzky	CC BY-SA 3.0	added 812 characters in body
Sep 16, 2015 at 15:59	vote	accept	Jonesome Reinstate Monica
Sep 16, 2015 at 15:58	history	edited	Solomon Rutzky	CC BY-SA 3.0	added 812 characters in body
Sep 16, 2015 at 15:19	history	edited	Solomon Rutzky	CC BY-SA 3.0	added 405 characters in body
Sep 16, 2015 at 15:14	history	answered	Solomon Rutzky	CC BY-SA 3.0