I am designing a website that queries an SQL database when opened, providing a list of bills for the given user. I am using a custom SQL query with a Data Source/Data View and in the Command & ...
I have a Sharepoint list that is a Linked List with MS Access (2010). It has just under 5,000 items (4,864), thus meaning it avoids the reduction in functionality lists of greater than 5,000 items ...
SharePoint 2010 has the fancy new developer dashboard where you can view the SQL queries made and how long they took to determine bottlenecks etc. I am not a SQL Sysadmin so I cannot use SQL profiler ...
Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?