Getting prompted for verification code but where do I put it in? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Should an RSS feed of hot network questions feed any chat room(s) here?No input field for Apple ID Verification CodeApple Two Factor Authentication: why verification code popup don't display?Changing the Apple ID on a 1st generation iPadiCloud keychain authorisation sends sms to old numberiOS 8.2 iPad mini iCloud login stuck at “Verifying”Can't connect to iCloud or iTunes on my iPadHow do I access Find My Friends from iCloud.com?Apple ID and iCloudWhy isn't my iPad Retina iCloud Drive login verification code not showing up on my iPhone or Mac?How to view photos captured in HEIF on older devices with iCloud?Resetting an AppleID password when you don't have access to an IOS deviceCan't sign into iCloud on my Mac and Mac App Store, but have no trouble signing in using browsersApple's 2FA and the notion of “trusted device” and “trusted browser”

Multi tool use
Multi tool use

How does the math work when buying airline miles?

How do living politicians protect their readily obtainable signatures from misuse?

How would a mousetrap for use in space work?

How often does castling occur in grandmaster games?

The Nth Gryphon Number

How to compare two different files line by line in unix?

An adverb for when you're not exaggerating

Putting class ranking in CV, but against dept guidelines

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

Does the Mueller report show a conspiracy between Russia and the Trump Campaign?

What does this say in Elvish?

Strange behavior of Object.defineProperty() in JavaScript

Sentence with dass with three Verbs (One modal and two connected with zu)

Is there hard evidence that the grant peer review system performs significantly better than random?

Did any compiler fully use 80-bit floating point?

How to identify unknown coordinate type and convert to lat/lon?

Flash light on something

Why weren't discrete x86 CPUs ever used in game hardware?

How did Fremen produce and carry enough thumpers to use Sandworms as de facto Ubers?

How many time has Arya actually used Needle?

Crossing US/Canada Border for less than 24 hours

Does "shooting for effect" have contradictory meanings in different areas?

One-one communication

Can the Flaming Sphere spell be rammed into multiple Tiny creatures that are in the same 5-foot square?



Getting prompted for verification code but where do I put it in?



Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Should an RSS feed of hot network questions feed any chat room(s) here?No input field for Apple ID Verification CodeApple Two Factor Authentication: why verification code popup don't display?Changing the Apple ID on a 1st generation iPadiCloud keychain authorisation sends sms to old numberiOS 8.2 iPad mini iCloud login stuck at “Verifying”Can't connect to iCloud or iTunes on my iPadHow do I access Find My Friends from iCloud.com?Apple ID and iCloudWhy isn't my iPad Retina iCloud Drive login verification code not showing up on my iPhone or Mac?How to view photos captured in HEIF on older devices with iCloud?Resetting an AppleID password when you don't have access to an IOS deviceCan't sign into iCloud on my Mac and Mac App Store, but have no trouble signing in using browsersApple's 2FA and the notion of “trusted device” and “trusted browser”



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








3















I am using an old iPad -- it's an iPad 2 model MC990LL/A
-- running iOS 9.3.5
I noticed when I go to settings --> iCloud and tap the top part where my name and ID is, I get this:




Account Details Unavailable



If you are signing in to iCloud on another device or at iCloud.com, you can get a verification code while offline.




I tap "Get verification code" and it sends one -- but where do I put it in? I saw the answers that said to tack it onto the end of your password but there's no password prompt!



I wanted to add my iPad to my list of trusted devices (my phone and computer are there) but there does not seem to be a way to do it.



Any help appreciated.



ETA: The help offere by bmike was great; as it happened turning it off and on again a couple of times did the trick after I reset the settings. (Not a full restore). But dang, the back compatibility is starting to go...










share|improve this question



















  • 1





    I wonder if you could temp. disable MFA to get past this? - discussions.apple.com/thread/7312213.

    – slm
    2 hours ago






  • 1





    @slm Given what we now know from my answer and comments, your suggestion here might be the best way to safely get iCloud re-attached to this device. I wonder if Jesse agreed to migrate his iCloud account to the newest format and have inadvertently left this old iPad forever left off iCloud for their account.

    – bmike
    2 hours ago











  • @bmike - yeah I'm out of ideas to try here except that one, without doing one of the more drastic choices that we don't want to do.

    – slm
    2 hours ago











  • I wonder if Jesse has TFA or TSA - two factor is different than two step and it’s really confusing to even people who try to be experts and pay attention. I always have to read through the KB several times and check my work on accounts to figure which is which. support.apple.com/en-us/HT204152

    – bmike
    2 hours ago

















3















I am using an old iPad -- it's an iPad 2 model MC990LL/A
-- running iOS 9.3.5
I noticed when I go to settings --> iCloud and tap the top part where my name and ID is, I get this:




Account Details Unavailable



If you are signing in to iCloud on another device or at iCloud.com, you can get a verification code while offline.




I tap "Get verification code" and it sends one -- but where do I put it in? I saw the answers that said to tack it onto the end of your password but there's no password prompt!



I wanted to add my iPad to my list of trusted devices (my phone and computer are there) but there does not seem to be a way to do it.



Any help appreciated.



ETA: The help offere by bmike was great; as it happened turning it off and on again a couple of times did the trick after I reset the settings. (Not a full restore). But dang, the back compatibility is starting to go...










share|improve this question



















  • 1





    I wonder if you could temp. disable MFA to get past this? - discussions.apple.com/thread/7312213.

    – slm
    2 hours ago






  • 1





    @slm Given what we now know from my answer and comments, your suggestion here might be the best way to safely get iCloud re-attached to this device. I wonder if Jesse agreed to migrate his iCloud account to the newest format and have inadvertently left this old iPad forever left off iCloud for their account.

    – bmike
    2 hours ago











  • @bmike - yeah I'm out of ideas to try here except that one, without doing one of the more drastic choices that we don't want to do.

    – slm
    2 hours ago











  • I wonder if Jesse has TFA or TSA - two factor is different than two step and it’s really confusing to even people who try to be experts and pay attention. I always have to read through the KB several times and check my work on accounts to figure which is which. support.apple.com/en-us/HT204152

    – bmike
    2 hours ago













3












3








3








I am using an old iPad -- it's an iPad 2 model MC990LL/A
-- running iOS 9.3.5
I noticed when I go to settings --> iCloud and tap the top part where my name and ID is, I get this:




Account Details Unavailable



If you are signing in to iCloud on another device or at iCloud.com, you can get a verification code while offline.




I tap "Get verification code" and it sends one -- but where do I put it in? I saw the answers that said to tack it onto the end of your password but there's no password prompt!



I wanted to add my iPad to my list of trusted devices (my phone and computer are there) but there does not seem to be a way to do it.



Any help appreciated.



ETA: The help offere by bmike was great; as it happened turning it off and on again a couple of times did the trick after I reset the settings. (Not a full restore). But dang, the back compatibility is starting to go...










share|improve this question
















I am using an old iPad -- it's an iPad 2 model MC990LL/A
-- running iOS 9.3.5
I noticed when I go to settings --> iCloud and tap the top part where my name and ID is, I get this:




Account Details Unavailable



If you are signing in to iCloud on another device or at iCloud.com, you can get a verification code while offline.




I tap "Get verification code" and it sends one -- but where do I put it in? I saw the answers that said to tack it onto the end of your password but there's no password prompt!



I wanted to add my iPad to my list of trusted devices (my phone and computer are there) but there does not seem to be a way to do it.



Any help appreciated.



ETA: The help offere by bmike was great; as it happened turning it off and on again a couple of times did the trick after I reset the settings. (Not a full restore). But dang, the back compatibility is starting to go...







ios ipad icloud apple-id






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 1 hour ago







Jesse

















asked 3 hours ago









JesseJesse

1215




1215







  • 1





    I wonder if you could temp. disable MFA to get past this? - discussions.apple.com/thread/7312213.

    – slm
    2 hours ago






  • 1





    @slm Given what we now know from my answer and comments, your suggestion here might be the best way to safely get iCloud re-attached to this device. I wonder if Jesse agreed to migrate his iCloud account to the newest format and have inadvertently left this old iPad forever left off iCloud for their account.

    – bmike
    2 hours ago











  • @bmike - yeah I'm out of ideas to try here except that one, without doing one of the more drastic choices that we don't want to do.

    – slm
    2 hours ago











  • I wonder if Jesse has TFA or TSA - two factor is different than two step and it’s really confusing to even people who try to be experts and pay attention. I always have to read through the KB several times and check my work on accounts to figure which is which. support.apple.com/en-us/HT204152

    – bmike
    2 hours ago












  • 1





    I wonder if you could temp. disable MFA to get past this? - discussions.apple.com/thread/7312213.

    – slm
    2 hours ago






  • 1





    @slm Given what we now know from my answer and comments, your suggestion here might be the best way to safely get iCloud re-attached to this device. I wonder if Jesse agreed to migrate his iCloud account to the newest format and have inadvertently left this old iPad forever left off iCloud for their account.

    – bmike
    2 hours ago











  • @bmike - yeah I'm out of ideas to try here except that one, without doing one of the more drastic choices that we don't want to do.

    – slm
    2 hours ago











  • I wonder if Jesse has TFA or TSA - two factor is different than two step and it’s really confusing to even people who try to be experts and pay attention. I always have to read through the KB several times and check my work on accounts to figure which is which. support.apple.com/en-us/HT204152

    – bmike
    2 hours ago







1




1





I wonder if you could temp. disable MFA to get past this? - discussions.apple.com/thread/7312213.

– slm
2 hours ago





I wonder if you could temp. disable MFA to get past this? - discussions.apple.com/thread/7312213.

– slm
2 hours ago




1




1





@slm Given what we now know from my answer and comments, your suggestion here might be the best way to safely get iCloud re-attached to this device. I wonder if Jesse agreed to migrate his iCloud account to the newest format and have inadvertently left this old iPad forever left off iCloud for their account.

– bmike
2 hours ago





@slm Given what we now know from my answer and comments, your suggestion here might be the best way to safely get iCloud re-attached to this device. I wonder if Jesse agreed to migrate his iCloud account to the newest format and have inadvertently left this old iPad forever left off iCloud for their account.

– bmike
2 hours ago













@bmike - yeah I'm out of ideas to try here except that one, without doing one of the more drastic choices that we don't want to do.

– slm
2 hours ago





@bmike - yeah I'm out of ideas to try here except that one, without doing one of the more drastic choices that we don't want to do.

– slm
2 hours ago













I wonder if Jesse has TFA or TSA - two factor is different than two step and it’s really confusing to even people who try to be experts and pay attention. I always have to read through the KB several times and check my work on accounts to figure which is which. support.apple.com/en-us/HT204152

– bmike
2 hours ago





I wonder if Jesse has TFA or TSA - two factor is different than two step and it’s really confusing to even people who try to be experts and pay attention. I always have to read through the KB several times and check my work on accounts to figure which is which. support.apple.com/en-us/HT204152

– bmike
2 hours ago










1 Answer
1






active

oldest

votes


















3














Tack the numbers on the end of the password if you don’t get a pop up to enter the code.



That’s what happens on older os in general.



  • Changing the Apple ID on a 1st generation iPad

  • No input field for Apple ID Verification Code

To be clear, if your password were thirteen-odd-variations and your second factor (iMessage) were 330000, then enter thirteen-odd-variations330000 as your password instead of what you usually enter.



If you don’t see a password prompt at all, you’ll want to make sure you have a backup of your device and then sign out of iCloud / App Store / wherever you wish to sign in so that you get the account / password dialog.



  • I’ve seen this happen when the certificate has expired and you need to sign out to release the old pairing from the keychain and then request a new session from iCloud

If you can’t ever get that dialog, you will want to restore the device from a computer or reset all content and settings - this erases everything, so be sure you have a backup or can afford to learn that the device has failed before doing the erase.






share|improve this answer

























  • BUT WHERE DO I ENTER THE PASSWORD? It never prompts me. Do I sign out and sign in again? (There's a note at the bottom in red that says to sign out but I am afraid to do so)

    – Jesse
    3 hours ago












  • So I should sign out and sign in again, yes? (I don't want to sound obtuse, but everything else about iOS is relatively intuitive)

    – Jesse
    2 hours ago






  • 2





    Yes - you would need to sign out and back in, Jesse. That should prompt you if it deletes things. Thanks for helping us help you, @Jesse Nothing is obtuse when we can’t see what you’re seeing and words are hard to be precise for several people to all agree what exactly things are. We all read into things based on our expectations. slm / grg / me are well acquainted how hard it is to be clear in every case.

    – bmike
    2 hours ago







  • 1





    I just tried signing out and it told me that iCloud notes would be deleted. Then it says it will delete my icloud account(!) so I stopped as I was afraid to say yes.

    – Jesse
    2 hours ago






  • 1





    Yikes! Glad you stopped. I would take stock of backups and maybe check the time sync / be sure you can’t get it to prompt for password tomorrow by turning on some other part of iCloud (rather than turning it off)

    – bmike
    2 hours ago


















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









3














Tack the numbers on the end of the password if you don’t get a pop up to enter the code.



That’s what happens on older os in general.



  • Changing the Apple ID on a 1st generation iPad

  • No input field for Apple ID Verification Code

To be clear, if your password were thirteen-odd-variations and your second factor (iMessage) were 330000, then enter thirteen-odd-variations330000 as your password instead of what you usually enter.



If you don’t see a password prompt at all, you’ll want to make sure you have a backup of your device and then sign out of iCloud / App Store / wherever you wish to sign in so that you get the account / password dialog.



  • I’ve seen this happen when the certificate has expired and you need to sign out to release the old pairing from the keychain and then request a new session from iCloud

If you can’t ever get that dialog, you will want to restore the device from a computer or reset all content and settings - this erases everything, so be sure you have a backup or can afford to learn that the device has failed before doing the erase.






share|improve this answer

























  • BUT WHERE DO I ENTER THE PASSWORD? It never prompts me. Do I sign out and sign in again? (There's a note at the bottom in red that says to sign out but I am afraid to do so)

    – Jesse
    3 hours ago












  • So I should sign out and sign in again, yes? (I don't want to sound obtuse, but everything else about iOS is relatively intuitive)

    – Jesse
    2 hours ago






  • 2





    Yes - you would need to sign out and back in, Jesse. That should prompt you if it deletes things. Thanks for helping us help you, @Jesse Nothing is obtuse when we can’t see what you’re seeing and words are hard to be precise for several people to all agree what exactly things are. We all read into things based on our expectations. slm / grg / me are well acquainted how hard it is to be clear in every case.

    – bmike
    2 hours ago







  • 1





    I just tried signing out and it told me that iCloud notes would be deleted. Then it says it will delete my icloud account(!) so I stopped as I was afraid to say yes.

    – Jesse
    2 hours ago






  • 1





    Yikes! Glad you stopped. I would take stock of backups and maybe check the time sync / be sure you can’t get it to prompt for password tomorrow by turning on some other part of iCloud (rather than turning it off)

    – bmike
    2 hours ago















3














Tack the numbers on the end of the password if you don’t get a pop up to enter the code.



That’s what happens on older os in general.



  • Changing the Apple ID on a 1st generation iPad

  • No input field for Apple ID Verification Code

To be clear, if your password were thirteen-odd-variations and your second factor (iMessage) were 330000, then enter thirteen-odd-variations330000 as your password instead of what you usually enter.



If you don’t see a password prompt at all, you’ll want to make sure you have a backup of your device and then sign out of iCloud / App Store / wherever you wish to sign in so that you get the account / password dialog.



  • I’ve seen this happen when the certificate has expired and you need to sign out to release the old pairing from the keychain and then request a new session from iCloud

If you can’t ever get that dialog, you will want to restore the device from a computer or reset all content and settings - this erases everything, so be sure you have a backup or can afford to learn that the device has failed before doing the erase.






share|improve this answer

























  • BUT WHERE DO I ENTER THE PASSWORD? It never prompts me. Do I sign out and sign in again? (There's a note at the bottom in red that says to sign out but I am afraid to do so)

    – Jesse
    3 hours ago












  • So I should sign out and sign in again, yes? (I don't want to sound obtuse, but everything else about iOS is relatively intuitive)

    – Jesse
    2 hours ago






  • 2





    Yes - you would need to sign out and back in, Jesse. That should prompt you if it deletes things. Thanks for helping us help you, @Jesse Nothing is obtuse when we can’t see what you’re seeing and words are hard to be precise for several people to all agree what exactly things are. We all read into things based on our expectations. slm / grg / me are well acquainted how hard it is to be clear in every case.

    – bmike
    2 hours ago







  • 1





    I just tried signing out and it told me that iCloud notes would be deleted. Then it says it will delete my icloud account(!) so I stopped as I was afraid to say yes.

    – Jesse
    2 hours ago






  • 1





    Yikes! Glad you stopped. I would take stock of backups and maybe check the time sync / be sure you can’t get it to prompt for password tomorrow by turning on some other part of iCloud (rather than turning it off)

    – bmike
    2 hours ago













3












3








3







Tack the numbers on the end of the password if you don’t get a pop up to enter the code.



That’s what happens on older os in general.



  • Changing the Apple ID on a 1st generation iPad

  • No input field for Apple ID Verification Code

To be clear, if your password were thirteen-odd-variations and your second factor (iMessage) were 330000, then enter thirteen-odd-variations330000 as your password instead of what you usually enter.



If you don’t see a password prompt at all, you’ll want to make sure you have a backup of your device and then sign out of iCloud / App Store / wherever you wish to sign in so that you get the account / password dialog.



  • I’ve seen this happen when the certificate has expired and you need to sign out to release the old pairing from the keychain and then request a new session from iCloud

If you can’t ever get that dialog, you will want to restore the device from a computer or reset all content and settings - this erases everything, so be sure you have a backup or can afford to learn that the device has failed before doing the erase.






share|improve this answer















Tack the numbers on the end of the password if you don’t get a pop up to enter the code.



That’s what happens on older os in general.



  • Changing the Apple ID on a 1st generation iPad

  • No input field for Apple ID Verification Code

To be clear, if your password were thirteen-odd-variations and your second factor (iMessage) were 330000, then enter thirteen-odd-variations330000 as your password instead of what you usually enter.



If you don’t see a password prompt at all, you’ll want to make sure you have a backup of your device and then sign out of iCloud / App Store / wherever you wish to sign in so that you get the account / password dialog.



  • I’ve seen this happen when the certificate has expired and you need to sign out to release the old pairing from the keychain and then request a new session from iCloud

If you can’t ever get that dialog, you will want to restore the device from a computer or reset all content and settings - this erases everything, so be sure you have a backup or can afford to learn that the device has failed before doing the erase.







share|improve this answer














share|improve this answer



share|improve this answer








edited 2 hours ago

























answered 3 hours ago









bmikebmike

162k46292633




162k46292633












  • BUT WHERE DO I ENTER THE PASSWORD? It never prompts me. Do I sign out and sign in again? (There's a note at the bottom in red that says to sign out but I am afraid to do so)

    – Jesse
    3 hours ago












  • So I should sign out and sign in again, yes? (I don't want to sound obtuse, but everything else about iOS is relatively intuitive)

    – Jesse
    2 hours ago






  • 2





    Yes - you would need to sign out and back in, Jesse. That should prompt you if it deletes things. Thanks for helping us help you, @Jesse Nothing is obtuse when we can’t see what you’re seeing and words are hard to be precise for several people to all agree what exactly things are. We all read into things based on our expectations. slm / grg / me are well acquainted how hard it is to be clear in every case.

    – bmike
    2 hours ago







  • 1





    I just tried signing out and it told me that iCloud notes would be deleted. Then it says it will delete my icloud account(!) so I stopped as I was afraid to say yes.

    – Jesse
    2 hours ago






  • 1





    Yikes! Glad you stopped. I would take stock of backups and maybe check the time sync / be sure you can’t get it to prompt for password tomorrow by turning on some other part of iCloud (rather than turning it off)

    – bmike
    2 hours ago

















  • BUT WHERE DO I ENTER THE PASSWORD? It never prompts me. Do I sign out and sign in again? (There's a note at the bottom in red that says to sign out but I am afraid to do so)

    – Jesse
    3 hours ago












  • So I should sign out and sign in again, yes? (I don't want to sound obtuse, but everything else about iOS is relatively intuitive)

    – Jesse
    2 hours ago






  • 2





    Yes - you would need to sign out and back in, Jesse. That should prompt you if it deletes things. Thanks for helping us help you, @Jesse Nothing is obtuse when we can’t see what you’re seeing and words are hard to be precise for several people to all agree what exactly things are. We all read into things based on our expectations. slm / grg / me are well acquainted how hard it is to be clear in every case.

    – bmike
    2 hours ago







  • 1





    I just tried signing out and it told me that iCloud notes would be deleted. Then it says it will delete my icloud account(!) so I stopped as I was afraid to say yes.

    – Jesse
    2 hours ago






  • 1





    Yikes! Glad you stopped. I would take stock of backups and maybe check the time sync / be sure you can’t get it to prompt for password tomorrow by turning on some other part of iCloud (rather than turning it off)

    – bmike
    2 hours ago
















BUT WHERE DO I ENTER THE PASSWORD? It never prompts me. Do I sign out and sign in again? (There's a note at the bottom in red that says to sign out but I am afraid to do so)

– Jesse
3 hours ago






BUT WHERE DO I ENTER THE PASSWORD? It never prompts me. Do I sign out and sign in again? (There's a note at the bottom in red that says to sign out but I am afraid to do so)

– Jesse
3 hours ago














So I should sign out and sign in again, yes? (I don't want to sound obtuse, but everything else about iOS is relatively intuitive)

– Jesse
2 hours ago





So I should sign out and sign in again, yes? (I don't want to sound obtuse, but everything else about iOS is relatively intuitive)

– Jesse
2 hours ago




2




2





Yes - you would need to sign out and back in, Jesse. That should prompt you if it deletes things. Thanks for helping us help you, @Jesse Nothing is obtuse when we can’t see what you’re seeing and words are hard to be precise for several people to all agree what exactly things are. We all read into things based on our expectations. slm / grg / me are well acquainted how hard it is to be clear in every case.

– bmike
2 hours ago






Yes - you would need to sign out and back in, Jesse. That should prompt you if it deletes things. Thanks for helping us help you, @Jesse Nothing is obtuse when we can’t see what you’re seeing and words are hard to be precise for several people to all agree what exactly things are. We all read into things based on our expectations. slm / grg / me are well acquainted how hard it is to be clear in every case.

– bmike
2 hours ago





1




1





I just tried signing out and it told me that iCloud notes would be deleted. Then it says it will delete my icloud account(!) so I stopped as I was afraid to say yes.

– Jesse
2 hours ago





I just tried signing out and it told me that iCloud notes would be deleted. Then it says it will delete my icloud account(!) so I stopped as I was afraid to say yes.

– Jesse
2 hours ago




1




1





Yikes! Glad you stopped. I would take stock of backups and maybe check the time sync / be sure you can’t get it to prompt for password tomorrow by turning on some other part of iCloud (rather than turning it off)

– bmike
2 hours ago





Yikes! Glad you stopped. I would take stock of backups and maybe check the time sync / be sure you can’t get it to prompt for password tomorrow by turning on some other part of iCloud (rather than turning it off)

– bmike
2 hours ago



efbx gd8hZnKpLQ jouwp9 GT aSov7qy55 66LSdH,Kk4hz aa13,7 5cx3vU3iv7,i1cet1,KDCej7GtbHadW
nmDhh nyzQN uSsS D5eiPSj,GXlmtkZzUSl2U5daD0IqexMJIky3JTq aAJt8Dp2jWgqZDR01nvOfbdp

Popular posts from this blog

What is the result of assigning to std::vector::begin()? The Next CEO of Stack OverflowWhat are the differences between a pointer variable and a reference variable in C++?What does the explicit keyword mean?Concatenating two std::vectorsHow to find out if an item is present in a std::vector?Why is “using namespace std” considered bad practice?What is the “-->” operator in C++?What is the easiest way to initialize a std::vector with hardcoded elements?What is The Rule of Three?What are the basic rules and idioms for operator overloading?Why are std::begin and std::end “not memory safe”?

Creating centerline of river in QGIS? The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Finding centrelines from polygons in QGIS?Splitting line into two lines with GRASS GIS?Centroid of the equator and a pointpostgis: problems creating flow direction polyline; not all needed connections are drawnhow to make decent sense from scattered river depth measurementsQGIS Interpolation on Curved Grid (River DEMs)How to create automatic parking baysShortest path creation between two linesclipping layer using query builder in QGISFinding which side of closest polyline point lies on in QGIS?Create centerline from multi-digitized roadway lines Qgis 2.18Getting bathymetric contours confined only within river banks using QGIS?

SQL Server 2016 - excessive memory grant warning on poor performing query The Next CEO of Stack OverflowFix for slow SQL_INLINE_TABLE_VALUED_FUNCTIONLarge memory grant requestsPoor performing Query -Tsql execution plan - estimated number of rows =1 Paste the PlanMSSQL - Query had to wait for memory grantRow estimates always too lowBad performance using “NOT IN”Warning about memory “Excessive Grant” in the query plan - how to find out what is causing it?Optimizing table valued function SQL ServerWhen does SQL Server warn about an Excessive Memory Grant?Warning in Execution Plan