InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 16:23:29 GMT20http://www.sqlservercentral.com/Forums/Topic1428927-391-1.aspx[quote]Configuration storage and IOPS....Transaction logs for the Configuration database can be large, therefore we recommend that you change the recovery model for the database from full to simple. [/quote]School project?Mon, 11 Mar 2013 21:53:51 GMTSergiyhttp://www.sqlservercentral.com/Forums/Topic1428927-391-1.aspx[quote][b]Lynn Pettis (3/11/2013)[/b][hr][quote][b]GilaMonster (3/11/2013)[/b][hr]Communication? What a novel idea!The sharepoint DB needs a complete redesign first, and to be honest, that's not going to happen.[/quote]Same could be said ot their CRM product as well.[/quote]Wasn't that bought rather than developed inhouse?Mon, 11 Mar 2013 16:34:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1428927-391-1.aspx[quote][b]GilaMonster (3/11/2013)[/b][hr]Communication? What a novel idea!The sharepoint DB needs a complete redesign first, and to be honest, that's not going to happen.[/quote]Same could be said ot their CRM product as well.Mon, 11 Mar 2013 16:13:25 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1428927-391-1.aspxCommunication? What a novel idea!The sharepoint DB needs a complete redesign first, and to be honest, that's not going to happen.Mon, 11 Mar 2013 16:10:11 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1428927-391-1.aspxMicrosoft SharePoint team needs to communicate with SQL Server team, vice versus. Parallelism is a good feature to use, not to surppess.Mon, 11 Mar 2013 14:24:02 GMTjswong05http://www.sqlservercentral.com/Forums/Topic1428927-391-1.aspxThe sharepoint database design is pretty bad (very bad), and about the only way to make the queries work acceptably is to force maxdop 1.Sat, 09 Mar 2013 15:29:36 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1428927-391-1.aspxwith microsoft products that use SQL server as a backend they often don't follow their own best practices :-)the code as written must work better if parallelism is suppressed, seems a shame and I don't know why, one can only hope they have thoroughly tested and proved it.Sat, 09 Mar 2013 14:45:10 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1428927-391-1.aspxhttp://technet.microsoft.com/en-us/library/cc298801.aspx•To ensure optimal performance, we strongly recommend that you set max degree of parallelism (MAXDOP) to 1 SQL Server instances that host SharePoint Server 2010 databases? can someone explain why sharepoint team put this document with the above line? Sharepoint surpresses all parallelism?Sat, 09 Mar 2013 13:24:25 GMTjswong05