Search Results | SQL Server Performance Forums

Deletion Problem

Thread by: pallavi, Mar 17, 2006, 9 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, I want to delete recrods from the tables which are linked with foreign key constraint, I have already used "On Delete Cascade ". When i...

Creating log for a package

Thread by: pallavi, Mar 9, 2006, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I am creating a package which transfers the data from paradox tables to a SQL server 2005 database and then from this databse it will transfer...

SQL Server registration problem

Thread by: pallavi, Mar 3, 2006, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I have 2 instances of SQL server 2005, one is with name comp40 and another is Comp35. When I try to register either of the server on other...

performance

Post by: pallavi, Mar 1, 2006 in forum: General Developer Questions

The order of join doesn't matter, but if you use the columns which are indexed in where clause it improves the performance. Warm Regards! Pallavi

Dubugging the Procedure

Post by: pallavi, Mar 1, 2006 in forum: General Developer Questions

Thanks for the reply. Warm Regards! Pallavi

Dubugging the Procedure

Thread by: pallavi, Mar 1, 2006, 3 replies, in forum: General Developer Questions

Hi All, Does anyone know how to debug a stored procedure in SQL 2000. I have a procedure which adds recrods in a table and I want to check the...

Using Golbal variable in Activex scripts.

Post by: pallavi, Feb 27, 2006 in forum: SQL Server 2005 Integration Services

Hi All, The problem was with some other code, DTSGlobalVariables works fine. Sorry for inconvenience Warm Regards! Pallavi

Using Golbal variable in Activex scripts.

Thread by: pallavi, Feb 27, 2006, 1 replies, in forum: SQL Server 2005 Integration Services

Hi All I am creating a package to transfer the data from approx 200 Excel files to a Table, all these files are on d:Excelfiles. This path is...

Changing the SQL Server instance name

Thread by: pallavi, Feb 27, 2006, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I have SQL Server 2005 installed on my PC, When I installed it, i was having SQL 2000 , so the instance name for 2005 was given as Comp50....

2005 BOL

Post by: pallavi, Feb 26, 2006 in forum: SQL Server 2005 General DBA Questions

Thanks Satya Warm Regards! Pallavi

Error Converting DT_Date to DT_DBTimeStamp

Post by: pallavi, Feb 25, 2006 in forum: SQL Server 2005 Integration Services

Hi to all, I got the way to do this, I followed the following steps between the source and destination I've added a data conversion . In the data...

Importing Paradox tables

Post by: pallavi, Feb 24, 2006 in forum: SQL Server 2005 General DBA Questions

Hi all Sorry for not sharing this earlier For creating the Paradox 5.x connction 1 create OLEDB Connection Manager 2 Select the Mocridoft Jet...

Error Converting DT_Date to DT_DBTimeStamp

Thread by: pallavi, Feb 23, 2006, 1 replies, in forum: SQL Server 2005 Integration Services

Hi All, I am creating a package which imports the data from Paradox (.db) tables to SQL server 2005 databse . The source tables which do not have...

Importing Paradox tables

Post by: pallavi, Feb 23, 2006 in forum: SQL Server 2005 General DBA Questions

Hi I got the way to do this, Best Regards! Pallavi

Importing Paradox tables

Thread by: pallavi, Feb 23, 2006, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi, In my application i want to import the tables and data from the paradox .db tables to SQL server 2005. I have done this in SQL 2000 using the...

Deletion of recrods

Post by: pallavi, Feb 20, 2006 in forum: General Developer Questions

Hi Thanks for the solution, Can you give me the link for this article. Best Regards! Pallavi

Deletion of recrods

Thread by: pallavi, Feb 17, 2006, 5 replies, in forum: General Developer Questions

Hi there, I have around 90 tables, and Company table is the main table which is related to almost 70 tables in the databased(directely or...

Performance of Dynamic sql query

Post by: pallavi, Feb 17, 2006 in forum: General Developer Questions

Thanks Adriaan and Madhivanan thanks for the suggestions. I will definatedly try the same Thanks again Best regards Pallavi

Performance of Dynamic sql query

Thread by: pallavi, Feb 16, 2006, 4 replies, in forum: General Developer Questions

Hello everyone, I want to know which one among the following will be faster. I am using linked server with name 'ReServer' and databse 'Rdb' 1....

Database suspect/offline

Post by: pallavi, Feb 3, 2006 in forum: General DBA Questions

Thanks for the information. and all those useful links. Regards! Pallavi