September 2008 - Posts

• Reading DTS and SSIS packages programmatically

  Reading a DTS/SSIS programmatically helps a lot in doing impact analysis. Consider a scenario in which all the packages containing a particular table or stored procedure need to identified. Let me give another usage scenario for this. The sql native clinet Read More... Posted Monday, September 29, 2008 1:33 PM by Ramoji | 1 Comments

• Moving indexes from one filegroup to another in SQL Server

  This is a pretty simple task but I would like to provide a generic method for doing this. It will help if the requirement is one (or all) of the folowing. I have only considered non-clustered indexes along with the Inclued columns and filtered indexes. Read More... Posted Friday, September 26, 2008 12:53 PM by Ramoji | 7 Comments

• Creating new tables and loading data in SQL server by reading an Xml file

  This kind of requirement may come if VSTS is used for test automation and the test results have to be loaded to a Database. Since the output of test automation is an xml file, let us look at how we can create tables and load them with data by reading Read More... Posted Thursday, September 18, 2008 10:25 AM by Ramoji | 2 Comments

• How to get missing values from an Identity column?

  Let us assume that there is an Employee table with EmployeeId as the Identity column in which some values are missing. The following batch will show all the missing values in that Identity column. The logic I preferred is to create another table with Read More... Posted Wednesday, September 17, 2008 10:56 AM by Ramoji | 1 Comments