Power of Compact & Repair

In this blog we will see, how “Compact and Repair” Command can help to prevent and correct the problems that sometimes affect a database file. Why we use compact and repair command? When we create a database then, it occupies a certain amount of space in the memory. In this image suppose blue circle is the full memory and red part shows the occupied memory by database. When we remove an object from the database then some amount of memory occupied by the database will be free and when...

Continue Reading

What is Guest Link feature in SharePoint Online 2013?

The Guest Link feature of SharePoint 2013 allows you to share individual documents, files and folders with out side users. You can invite people from outside your organization to collaborate and share documents. There are two ways to share documents, with or without creating user account. When you want to share individual document then you don't need to create an account but if you want to share a whole site then creation of account is necessary. Before sharing a document you need to know who...

Continue Reading

How to repair damaged MyISAM tables?

!-- @page { margin: 2cm } P { margin-bottom: 0.21cm } A:link { so-language: zxx } --> MyISAM tables in MySQL becomes corrupted due to various reasons like hardware fault, sudden system shutdown or server crash. Due to corruption you may lose all your hard earned data. So it is important to deal with corruption properly. First consider the symptoms of corrupt table: When MyISAM tables got damaged its queries abort unexpectedly and following errors occur: Can't find table_name....

Continue Reading

How to recover SharePoint database when STSADM MergeContentDBs cause corruption

STSADM MergeContentDBs command allows users to move a site collection from one content database to another. You have to specify the source and destination parameter properly. In some situations, STSADM MergeContentDBs command fails to work properly and cause database corruption. Due to failure of this command both source and destination database may also got damaged. STSADM MergeContentDBs command fails when there is high load on SQL Server or high user traffic. When you run this command on database...

Continue Reading

How to improve SharePoint performance?

MS SharePoint has become the most popular product of Microsoft because so many organizations are adopting it. But the point of concern is that SharePoint performance is not that good because of  heavy use of SQL Server database. There are many reasons behind SharePoint slow performance like incorrect configuration, BLOB storage issue, large media files and many more. Here are some tips on improving SharePoint performance. Use different networks: Since SharePoint require SQL Server for...

Continue Reading