Mar 6, 2012 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008, TSQL
Your SQL Server production database must be available 7×24 but it contains millions of obsolete rows which hurt performance. How do you delete these rows without the lock contention and business impact of a standard delete? In this tip we look at how you can... Nov 11, 2011 | Microsoft Sharepoint, Sharepoint 2010
First off, I should state that there’s really no such thing as a site collection template. What happens when a new site collection is created is that the collection gets created, and then a web template is applied to the root site. This whole process is actually... Sep 21, 2011 | Sharepoint 2010
We typically use the Central Administration Web site to create a site collection in a stand-alone deployment, while creating a new site collection it asks for only two Site collection Administrators (Primary and Secondary) Primary Site Collection Administrator to add... Aug 26, 2011 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008
Please refer to this URL for detailed information about SQL Server builds: http://sqlserverbuilds.blogspot.com/ Thanks, Nabeel Shahid. Aug 22, 2011 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008, TSQL
Here are few important TSQL queries to get the long running transactions and queries in TempDB for monitoring purposes. Long-running transaction: Sometimes transactions may run for long time preventing the shrinking of version store data. The below queries will list... Aug 22, 2011 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008
This article covers SQL Server 2005/2008, and focuses on the most common ways to work with TEMPDB, not including every potential option. What Objects are Stored in TEMPDB? TEMPDB is used to store three different categories of temporary data: I. ... Jul 31, 2011 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008, TSQL
Suppose you want to loop through all indexes and rebuild those which fragmentation exceeds 30 percent, and reorganize those which fragmentation is between 5 and 30 percent. Rebuilding or reorganizing all indexes is not a problem – you can prepare a maintenance plan... Jul 30, 2011 | Microsoft Sharepoint, Sharepoint 2010
The SharePoint Content Database Data Size Limit With the release of SharePoint 2010 SP1 and some new guidance we are changing the supported data size limits for SharePoint content databases. Prior to SP1 the content database limit was 200 GB for collaboration and 1 TB... Jul 21, 2011 | Microsoft Sharepoint, Sharepoint 2010
SharePoint is a Microsoft platform that allows people to build websites. SharePoint 2010 is the fourth version of SharePoint from Microsoft, and it is also known as SharePoint v4 or Microsoft Office SharePoint Server 2010. It is very different from the versions that... 
Recent Comments