Search Results | SQL Server Performance Forums

Control File Equivalent..

Post by: anandchatterjee, Jul 1, 2009 in forum: SQL Server 2008 General DBA Questions

Please provide some clue..

Control File Equivalent..

Thread by: anandchatterjee, Jun 30, 2009, 1 replies, in forum: SQL Server 2008 General DBA Questions

Hi, In Oracle, control files are mainly playing the role for database consistency. Let me draw a scenario. When we are committing any transaction,...

Clustered and Non-Clustered Index

Post by: anandchatterjee, Apr 15, 2009 in forum: Getting Started

Thanks Frank, You have given all the answers of my questions. Thanks Arijit

Clustered and Non-Clustered Index

Thread by: anandchatterjee, Apr 8, 2009, 2 replies, in forum: Getting Started

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...

Exporting Execution Plan..

Post by: anandchatterjee, Sep 1, 2008 in forum: SQL Server 2005 General Developer Questions

Thanks a bunch...

Exporting Execution Plan..

Post by: anandchatterjee, Sep 1, 2008 in forum: SQL Server 2005 General Developer Questions

Thanks Satya, 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...

Exporting Execution Plan..

Post by: anandchatterjee, Aug 30, 2008 in forum: SQL Server 2005 General Developer Questions

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,...

Exporting Execution Plan..

Thread by: anandchatterjee, Aug 29, 2008, 5 replies, in forum: SQL Server 2005 General Developer Questions

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...

Table Partitioning Concept..

Post by: anandchatterjee, Jul 22, 2008 in forum: SQL Server 2005 General Developer Questions

Thanks a bunch..

Table Partitioning Concept..

Post by: anandchatterjee, Jul 22, 2008 in forum: SQL Server 2005 General Developer Questions

Thanks Hassan, 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...

Table Partitioning Concept..

Thread by: anandchatterjee, Jul 21, 2008, 4 replies, in forum: SQL Server 2005 General Developer Questions

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...

Oracle to SQL Server migration..

Post by: anandchatterjee, May 26, 2008 in forum: SQL Server 2005 General Developer Questions

Thanks Satya, 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.

Oracle to SQL Server migration..

Post by: anandchatterjee, May 26, 2008 in forum: SQL Server 2005 General Developer Questions

Thanks Satya, could you please assist me to find out first 2 points?

Oracle to SQL Server migration..

Thread by: anandchatterjee, May 26, 2008, 4 replies, in forum: SQL Server 2005 General Developer Questions

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...

Nested Transaction and Savepoint

Thread by: anandchatterjee, May 25, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

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...

Difference between sp_addserver and sp_addlinkedserver

Thread by: anandchatterjee, May 4, 2008, 1 replies, in forum: Getting Started

What is the difference between sp_addserver and sp_addlinkedserver? Please guide me..

Transact-SQL Distributed Transactions

Thread by: anandchatterjee, May 2, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

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...

All childrens are sub-childrens should display in the resultset!

Post by: anandchatterjee, Dec 20, 2007 in forum: General Developer Questions

Thanks Ranjit!! Actually I was looking this think in a single query.. Thanks anyway..

A difficult question about owner

Post by: anandchatterjee, Dec 19, 2007 in forum: General DBA Questions

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...

All childrens are sub-childrens should display in the resultset!

Thread by: anandchatterjee, Dec 19, 2007, 4 replies, in forum: General Developer Questions

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...