In Oracle, control files are mainly playing the role for database consistency. Let me draw a scenario.
When we are committing any transaction,...
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...
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...
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!
In this article there a is paragraph...
create table H
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.