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, 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... 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.
Recent Comments