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 13, 2012 | Microsoft SQL Server, SQL Server 2012, TSQL
SQL Server 2012 introduces two new analytical functions FIRST_VALUE and LAST_VALUE. FIRST_VALUE returns the first value in an ordered set of values and LAST_VALUE returns the last value in an ordered set of values The syntax for these functions are: FIRST_VALUE... 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... 
Recent Comments