Sign In
Ramoji Ryali's Fundas
The interesting things I experimented with SQl Server.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
No tags have been created or used yet.
Archive
Archives
January 2011
(1)
July 2010
(1)
June 2010
(1)
May 2010
(1)
January 2010
(1)
December 2009
(1)
November 2009
(2)
August 2009
(2)
July 2009
(1)
March 2009
(1)
December 2008
(2)
October 2008
(1)
September 2008
(4)
September, 2008
MSDN Blogs
>
Ramoji Ryali's Fundas
>
September, 2008
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Ramoji Ryali's Fundas
Reading DTS and SSIS packages programmatically
Posted
over 4 years ago
by
Ramoji
3
Comments
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...
Ramoji Ryali's Fundas
Moving indexes from one filegroup to another in SQL Server
Posted
over 4 years ago
by
Ramoji
9
Comments
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...
Ramoji Ryali's Fundas
Creating new tables and loading data in SQL server by reading an Xml file
Posted
over 4 years ago
by
Ramoji
2
Comments
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...
Ramoji Ryali's Fundas
How to get missing values from an Identity column?
Posted
over 4 years ago
by
Ramoji
1
Comments
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...
Page 1 of 1 (4 items)