The below visual captures ideas on SharePoint table data storage and when to use what. Rows and columns of data are common. Choosing the best hosting technology provides ease of support, quick time to market, performance, and scale for data growth.
SQL Server has good use cases, but comes with trade-offs including higher upfront setup effort and fewer end user controls (audit, search, version history). Can improve performance and reporting if those trade-offs are correctly addressed.
Recently I resolved an on-premise search issue where typing an ID number into the list view “Find an item” bar gave zero results. The list definitely had matching data and search full crawl was completed.
The fix was to update “ListitemID” to be searchable on the Search Service Application (SSA), click “Re-Index” button under List Settings, and wait for the next incremental crawl. Cheers!
Application for the SharePoint Admin Center early preview program
Important (10/18/2017): The current early preview program for the new SharePoint Admin Center that was presented at Ignite 2017 is now closed. You can still use this form to apply for future early preview opportunities. We will contact you via email and invite you to our private Yammer group when we start enrolling people again in the future.
1. Tenant URL (Example: contoso.sharepoint.com)
This is the tenant you will want to receive the early SharePoint Admin Center preview on. Please provide one form entry per tenant.
Enter your answer
2. Contact email (Example: Bob.Smith@contoso.com)
This contact email will be invited to our private Yammer group once you’ve been accepted in the program. For multiple emails, please separate with “;”