Mar 9, 2012 | Microsoft SQL Server, TSQL
T-SQL script to refresh all VIEWS in DATABASE. declare c cursor for select name from sysobjects where type = ‘v’ and uid = 1 open c declare @ViewName varchar(500) fetch next from c into @ViewName while @@fetch_status = 0 begin BEGIN TRY exec sp_refreshView... Mar 9, 2012 | Microsoft SQL Server, SQL Server 2005, TSQL
SQL 2005 System Objects for getting information about Transaction Locks sys.dm_tran_locks: Shows us all locks held on all resources for all transaction. We start from this view since we want to get information about locked resources. sys.partitions: Contains... Mar 9, 2012 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008, TSQL
T-SQL script to enable Cross Database Chaining in Microsoft SQL Server through query analyzer: Use [MY_DATABASE_NAME] GO ALTER DATABASE [MY_DATABASE_NAME] SET DB_CHAINING ON GO EXEC sp_grantdbaccess ‘GUEST’ GO Grant CONNECT to GUEST GO Grant SELECT to... 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. ... 
Recent Comments