Hi, In Oracle, control files are mainly playing the role for database consistency. Let me draw a scenario. When we are committing any transaction,...
Hi All, As per my understanding: Clustered indexes sort and store the data rows in the table based on their key values. Because the data rows are...
Hi All, I am not sure whether this is a right question or not!! Is there any process to export the execution plan from one server (Development) to...
Hi, Since I haven't worked much in SQL Server 2005, I need a quick help from your end. I am clear about the table partitioning concept but let me...
Hi, Presently I am working with a project to migrate the total DB from Oracle to SQL Server and I am facing few issues related to this. I am trying...
Another silly question!I can define a savepoint inside a transaction and rollback it through the name and also I can do the same through nested...
What is the difference between sp_addserver and sp_addlinkedserver? Please guide me..
Please refer the below mentioned link from MSDN first! http://msdn.microsoft.com/en-us/library/ms191156.aspx In this article there a is paragraph...
create table H ( child int, parent int ) insert into H values (1,null) insert into H values (2,1) insert into H values (3,1) insert into H values...
Separate names with a comma.
