Mar 10, 2012 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008
There are 3 steps involved for Configuring the Transactional Replication: 1.Configuring the Distribution Database. A database which contains all the Replication commands. Whenever any DML or DDL schema changes are performed on the publisher, the corresponding commands... 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... 
Recent Comments