Please provide some clue..
In Oracle, control files are mainly playing the role for database consistency. Let me draw a scenario.
When we are committing any transaction,...
You have given all the answers of my questions.
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...
Thanks a bunch...
From your post, it is very much clear the steps to save the execution plan in xml format but it is not telling the process of binding...
Hi All,Let me explain the scenario more in details. I have two boxes (Integration and Production), both are in sync as per as hardware, software,...
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...
Thanks a bunch..
I have gone though all your points and it is too much informative but it is not explaining my query. My question was if my select...
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...
I have already tried it out in different posts in this blag. Give me another few hours, I will come back to with the updates.
Thanks Satya, could you please assist me to find out first 2 points?
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...
Thanks Ranjit!! Actually I was looking this think in a single query.. Thanks anyway..
After going through your explanation, I think you want to change the schema on run time but changing schema means changing the login. Under dbo all...
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.