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
Subscribe to:
Posts (Atom)