Search Results | SQL Server Performance Forums

URGENT ! DTS Package backup!

Thread by: manu_dba, Jun 27, 2007, 6 replies, in forum: SQL Server DTS-Related Questions

hi sql gurus..... I need your guidance please.... actually by mistake i have deleted three very critical DTS packages.... can you guide me how I...

turn off transaction log

Thread by: manu_dba, Jun 27, 2007, 4 replies, in forum: General DBA Questions

I have a quick question plz. can we turn off the transaction log in sql 2000 for some query or for some time so that it should not log that...

scirpt to shrink log file

Thread by: manu_dba, Jun 4, 2007, 3 replies, in forum: General DBA Questions

sql gurus, can anyone please guide me how i can write a script to shrink the log file automatically to a fixed size mentioned in stored procedure...

connecting server with different port number

Thread by: manu_dba, May 1, 2007, 1 replies, in forum: General DBA Questions

hi sql gurus can you guide me that how I can connect to other sql server 2000 from my machine listen at different port number. actually i am having...

about sql 2005

Thread by: manu_dba, Apr 16, 2007, 6 replies, in forum: Getting Started

before i ask this question , I would like to say sorry as i do not know which is the right section where maximum people can see and guide me for...

query response time in tbls with millions recs

Thread by: manu_dba, Apr 13, 2007, 4 replies, in forum: General DBA Questions

hi sql gurus i have a question regarding the performance issue . Situation: Actually I am dealing with the reporting server and one of the...

moving databases ,jobs and dts pckgs

Thread by: manu_dba, Apr 11, 2007, 11 replies, in forum: SQL Server 2005 General DBA Questions

i have installed new sql 2005 enterprise edition. now i have to move four-five very large databases of nearly 400 gb each from sql 2000 to sql...

full, Translog backup very large databases

Thread by: manu_dba, Apr 10, 2007, 16 replies, in forum: General DBA Questions

hi sql gurus, IT IS IMPORTANT AND URGENT PLEASE -------------------------------- i am facing a challenge to backup 5-10 very large databases and...

how to delete old trasaction log backup files

Thread by: manu_dba, Mar 27, 2007, 2 replies, in forum: General DBA Questions

hey sql gurus.... i have created a stored procedure for transaction log backup that take transaction backup every night. now the file is too big....

rename database

Thread by: manu_dba, Mar 22, 2007, 4 replies, in forum: General DBA Questions

hey sql gurus.... can you please suggest the best and secured way to rename the database having 30 gb of critical data. if you can please mention...

UNIQUE INDEX WITH IGNORE_DUP_KEY gives error

Thread by: manu_dba, Mar 16, 2007, 5 replies, in forum: General DBA Questions

hi sql gurus, i am facing a challenge in one of my tables and stored procedures. actually i created UNIQUE INDEX TestTable ON TestTable (name ,...

DTS from Oracle 9i reporting server to sql 2000

Thread by: manu_dba, Mar 12, 2007, 1 replies, in forum: General DBA Questions

hi, i need to import data from oracle 9i on daily basis . the tables in the oracle are very large table between 15-20 million records and some...

Update records with cursor

Thread by: manu_dba, Mar 8, 2007, 4 replies, in forum: General DBA Questions

hey sql guru's can anyone please correct the stored procedure written below: i have to tables ATable and BTable both joins on visitid but Btable...

DTS Error for buffer size

Thread by: manu_dba, Mar 5, 2007, 7 replies, in forum: General DBA Questions

I am trying to import data from excel file to sql 2000 database table. one of the column number 12 is url string the datatype i have define already...

comparison of dates and deleting data

Thread by: manu_dba, Feb 22, 2007, 1 replies, in forum: General DBA Questions

PLEASE CONSIDER THIS LITTLE URGENT AND IF YOU KNOW AND CAN GUIDE I WILL BE APPRECIATE FOR HSARING YOUR KNOWLEDGE IN THIS I have Table BTTable_A and...

insert data in table after comparing datetime

Thread by: manu_dba, Feb 21, 2007, 9 replies, in forum: General DBA Questions

hi sqlgurus... i am trying to write a query actually i am having two tables A and B i have to insert all data everyday from A to B but before...

Use of Update with IF ..Else

Thread by: manu_dba, Feb 15, 2007, 6 replies, in forum: General DBA Questions

hi sql gurus.... I am trying to write a stored procedure for Update with if...else condition situation is very simple... there are two table A and...

Transfer XML to SQL 2000

Thread by: manu_dba, Feb 7, 2007, 3 replies, in forum: General DBA Questions

hi, i am having data in xml files. I need to transfer in to a database in sql 2000. I never tried this before.Can you please suggest or let me know...

can we run query against oracle 9i from sql 2000

Thread by: manu_dba, Feb 6, 2007, 5 replies, in forum: General DBA Questions

hi sql gurus,<br /><br />i would like to request you to guide me in the following case:<br /><br />situation:I have to grab data on daily basis from...

stored procedure to sync two table

Thread by: manu_dba, Jan 26, 2007, 5 replies, in forum: General DBA Questions

hi sql gurus.. can anyone please guide me that how i can write a stored procedure to sycn two tables ... suppose i have two tables a and b both in...