Sunday, December 23, 2012
Wednesday, November 28, 2012
How does the "Commit pending changes" action work and when is it best used?
http://connect.nintex.com/forums/thread/7827.aspx
Thursday, November 15, 2012
Limitations of External Lists
Wednesday, November 14, 2012
Wednesday, November 7, 2012
Monday, September 24, 2012
Learning SSRS
http://smallbusiness.chron.com/displaying-ssrs-report-sharepoint-35384.html
http://fendy-huang.blogspot.de/2011/02/create-ssrs-report-with-sharepoint-2010.html
http://intellisoft.wordpress.com/2012/02/20/working-with-reporting-services-in-sharepoint-2010/
http://www.codeproject.com/Articles/88285/Integrating-Sharepoint-2010-and-SQL-Reporting-Serv
Architecture: http://www.accelebrate.com/sql_training/ssrs_tutorial.htm
Videos: http://www.youtube.com/user/bilessons?feature=results_main
http://fendy-huang.blogspot.de/2011/02/create-ssrs-report-with-sharepoint-2010.html
http://intellisoft.wordpress.com/2012/02/20/working-with-reporting-services-in-sharepoint-2010/
http://www.codeproject.com/Articles/88285/Integrating-Sharepoint-2010-and-SQL-Reporting-Serv
Architecture: http://www.accelebrate.com/sql_training/ssrs_tutorial.htm
Videos: http://www.youtube.com/user/bilessons?feature=results_main
Wednesday, June 13, 2012
Overview of using fine-grained permissions
Item Level Permissions and Performance:
http://anilmukka.wordpress.com/2011/05/05/overview-of-using-fine-grained-permissions/
http://e-junkie-chronicles.blogspot.de/2011/03/sharepoint-2010-performance-with-item.html
http://e-junkie-chronicles.blogspot.de/2011/03/sharepoint-2010-performance-with-item_23.html
http://anilmukka.wordpress.com/2011/05/05/overview-of-using-fine-grained-permissions/
http://e-junkie-chronicles.blogspot.de/2011/03/sharepoint-2010-performance-with-item.html
http://e-junkie-chronicles.blogspot.de/2011/03/sharepoint-2010-performance-with-item_23.html
Query to fetch list item counts from Content DB
Returns the count of items in all lists in a web application:
select [***].[dbo].[AllWebs].Title,[***l].[dbo].[AllWebs].FullUrl, tp_Title,tp_ServerTemplate,UserDataCount,DocsCount
from [***].[dbo].[AllLists] left outer join
(select tp_ListId, COUNT(*) as UserDataCount from [***].[dbo].[AllUserData]
group by tp_ListId ) E On E.tp_ListId = AllLists.tp_ID
left outer join
(select ListId, COUNT(*) as DocsCount from [***].[dbo].[AllDocs]
group by ListId ) P ON AllLists.tp_ID = P.ListId
left outer join [***].[dbo].[AllWebs] ON AllLists.tp_WebId = [***].[dbo].[AllWebs].Id
order by DocsCount desc
select [***].[dbo].[AllWebs].Title,[***l].[dbo].[AllWebs].FullUrl, tp_Title,tp_ServerTemplate,UserDataCount,DocsCount
from [***].[dbo].[AllLists] left outer join
(select tp_ListId, COUNT(*) as UserDataCount from [***].[dbo].[AllUserData]
group by tp_ListId ) E On E.tp_ListId = AllLists.tp_ID
left outer join
(select ListId, COUNT(*) as DocsCount from [***].[dbo].[AllDocs]
group by ListId ) P ON AllLists.tp_ID = P.ListId
left outer join [***].[dbo].[AllWebs] ON AllLists.tp_WebId = [***].[dbo].[AllWebs].Id
order by DocsCount desc
Tuesday, June 12, 2012
Sunday, May 20, 2012
Friday, May 4, 2012
Monday, February 20, 2012
Tuesday, February 14, 2012
Subscribe to:
Posts (Atom)