Auto Update Statistics and Auto Create Statistics – ON or OFF for SharePoint 2010 Databases?

Update: CTS complained that some customers turned ON auto-create statistics on content databases because of this post. If you think you should turn on this option on content databases after reading this post, please let me know by leaving a comment below. The key message in this post is, in most of cases you don’t need…

6

Details about how Document ID Service is activated

You may have found that Document ID Service is a very interesting feature. Sometimes you activate it and it just works as expected. But sometimes you activate it and it doesn’t work immediately. A typical example is to activate it on a team site and a publishing portal site. On the team site, it works…

7

Interesting Facts About Patching of SharePoint 2010

With the release of the SharePoint 2010 SP1, we had an interesting discussion about the way we should follow to patch SharePoint 2010. And I just learned several things that I didn’t exactly know before. Let me just share them here. According to the SharePoint team blog, SP1 should be installed in the following order:…


Enabling ECB menu on a custom column in SharePoint 2010 (Part 2)

OK. In Part 1, I’ve explained the problem of “Edit in undefined” when you enable the ECB menu on a field in the document library. To workaround this problem, we have to go back to the way we used for MOSS. In MOSS, when we want to enable the ECB menu on a field, we…

12

Enabling ECB menu on a custom column in SharePoint 2010 (Part 1)

If you have ever tried to enable the ECB menu on a column other than Name or Title in MOSS 2007, you will love a new feature of SharePoint 2010, Show List Item Menu, like the screenshot below. This feature allows us to enable the ECB menu on almost all columns. In SharePoint Designer, if…

7

Rendering a Field with the Custom XSLT Stylesheet

In MOSS 2007, how a field is rendered in a list view relies on its <RenderPattern> element which defines the actual CAML that SharePoint can use to render the field. However in SharePoint 2010, the list view rendering system has been changed significantly to rely on the XSLT stylesheets. To understand how different are the…

4

Accessing Databases in a Sandboxed Solution

Sandboxed Solution is a cool feature of SharePoint 2010, but as all of us know, not everything can be done with the Sandboxed Solution. For security consideration, Sandboxed Solution has its own CAS to restrict the call to some SharePoint APIs as well as some sensitive resources like network connections, local disk IOs etc. Of…

5

Creating an External Content Type based on SQL Azure

One thing I am interested in Windows Azure Platform is what this Cloud platform means to SharePoint. I know BPOS is there, and as one part of it, SharePoint Online, provides an option to users who wants to get the SharePoint capability in the public cloud. But what if users want to host a SharePoint…