Dec 22, 2014 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2012
The purpose of this article is to enlist recommended items that needs to be excluded from AntiVirus or AntiMalware scanning software’s on server machine where Microsoft SQL Server is installed. This can also help improve the overall SQL Server performance, these... 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, 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... 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