Muthusamy Anantha Kumar

In SQL Server 2005, you can explicitly or implicitly define the execution context. As we all know, a session starts when a user logs on to SQLServer or a connection to SQLserver is made. All operations in that session use the logon credentials used for connecting to SQL Server. When an EXECUTE AS statement is run, the […]

One of the many command line utilities that came with SQL Server 2005 is the TableDiff utility. Although this utility is primarily designed for comparing replicated tables, we can take advantage of its functionality to compare tables. The objective of this article is to demonstrate the TableDiff utility. Let us assume that we have the […]

Let us assume that your production server resides in New York and your Disaster recovery site is 3000 miles away, say San Francisco. Let us also assume that your backup policy in production server is a nightly full backup and transaction log backup every 15 minutes and you have regular log shipping setup between your […]

When a new version is released or when existing software is upgraded there is always a learning curve and getting used to new ways of doing things. This article demonstrates how to use SQL Server 2005’s catalog views in comparison with using system tables in SQL Server 2000. Catalog views are a storehouse for static […]

Among other enhancements in SQL Server 2005, enhancements were made to the OPENROWSET function. This article illustrates BULK operations of the OPENROWSET function. Let us assume that we have text files Asia.txt and NorthAmerica.txt in C:\Data folder with some data in it as shown below. [Refer Fig 1.0] Asia.txt 1, Mizuho, Fukushima, Tokyo 2, Minika, […]

One of the many new features that have been added to SQL Server 2005 is DDL triggers. We use DML triggers in SQL Server 7.0 and 2000, which executes a bunch of SQL statements or procedures whenever an INSERT, UPDATE or DELETE statement is executed and limited to a table or view object. In SQL […]

In part I of this article, we saw how to generate row numbers and delete a simple single duplicate row. This article walks you through how to delete multiple duplicate rows. This article uses the new feature Row_Number() function, common table expression and the ANSI co-related subquery. Let us assume we have the following table, […]

As we all know, SQL Server 2005 has new features when compared to SQL Server 2000. One of the features that we are going to discuss in this article is the Row_Number() function. SQL Server Database administrators and developers have been longing for this function for a long time–now the wait is over. Traditionally developers […]

b. Make sure the msmdarch.exe file is installed. [Refer Fig 1.0a] c. The account used to run the script should have access to the data folder of the analysis service machine. Step 1 Let us assume the Analysis server VMAnalysis has the following databases that are to be backed up daily. [Refer Fig 1.1] Fig […]

After the release of SQL Server 7.0, SQL Server is not just an RDBMS. It also provides services like Extraction Transformation and Loading, Online Analytical processing etc. This evolution of SQL Server added additional responsibilities to the database administrative tasks. One of the many tasks of the SQL Server Database administrator is to take and […]

b.  Create C:\monitorprocess\ Listremoteprocess2.vbs as shown below. [Refer Fig 1.1]. Please download Listremoteprocess2.vbs_.‘Objective: To Find the CPU usage of each process that are running on a remote machine ‘Created by : MAK ‘Created Date: Nov 2, 2005 ‘Syntax: cscript Listremoteprocess2.vbs machinename ‘Example: cscript Listremoteprocess2.vbs MyMachine Set objArgs = WScript.Arguments strComputer =objArgs(0) Set objWMIService = GetObject(“winmgmts:\\” […]

This article illustrates how to monitor CPU usage on different running process on one machine and on multiple machines. In many organizations, the SQL Server Database administrator and System administrators have the responsibility of trouble shooting and identifying the cause of high CPU usage during certain periods in a day on a machine. This article […]