Viewing 15 posts - 1,456 through 1,470 (of 2,387 total)
What are your issues on time-out? Maybe due to block in tempdb?
July 18, 2003 at 9:00 am
Try BCP.exe from SQL Server. See BOL for details.
Edited by - Allen_Cui on 07/18/2003 09:54:19 AM
July 18, 2003 at 8:52 am
You don't have to dbcc checkdb to tempdb. It stored only temporary data.
Form BOL.
"tempdb holds all temporary tables and temporary stored procedures. It also fills any other temporary storage needs...
July 18, 2003 at 8:49 am
Make a complete backup to all your databases before moving on.
July 18, 2003 at 8:21 am
Create a temp table with same columns as your original table and additional identity column. Use insert into #temptable select column1, column2 ... from originaltable and query the temp table.
...
July 18, 2003 at 8:17 am
quote:
Actually, we are using sql server 7.0 and we restored an access 97 databse on to it.
July 18, 2003 at 8:13 am
There is no ROWNUM (Oracle) in SQL Server. You may add addtional 'Identity' column to table as row number.
July 18, 2003 at 7:51 am
It depends. How large your table is? Do you have separate I/O and raid set for each filegroup? Is this table more on read or read-write heavily? Are the indexes...
July 18, 2003 at 7:46 am
quote:
Right? All log backups are appended to the same file.
That is the reason...
July 18, 2003 at 7:12 am
quote:
I have a requirement to migrate two version 6.5 and six version 7 servers and databases to one sql2k server.
July 18, 2003 at 7:04 am
quote:
We collect all of the upgrade scripts and merge them into one large upgrade script when we actually deploy.
July 18, 2003 at 6:51 am
quote:
RESTORE LOG test_1cFROM disk='D:\ONEC\ONEC.TLF'
WITH RECOVERY
-- restore failed:
The problem comes from last restore log...
July 18, 2003 at 6:45 am
Do both SQL Srever have same version and service pack?
July 17, 2003 at 2:12 pm
I guess you need post the execution plan for both of queries.
July 17, 2003 at 2:08 pm
Viewing 15 posts - 1,456 through 1,470 (of 2,387 total)