Hi All! while updating service packs or patch for OS and Sql Server. what is the process we need to follow. before doing that any precautions we need to take...
Take you back up all the database including system datrabase. shyam koti <shyam.koti@...> wrote: Hi All! while updating service packs or patch for OS...
Hi Shyam, In Microsoft products service packs, Hotfixes and Security Patches are very common. Generally , it is issued when a major enhancement or debugging is...
Dear all, We are using DTS import/Export tool for export data between the databases (data is exported from one database and imported to another db in the same...
Can any one suggest any good books on SQL server 2005 admin.my Library people are asking me dilip ... Find out what India is talking about on - Yahoo!...
Can any one suggest any good books on SQL server 2005 admin.my Library people are asking me ? dilip ... Find out what India is talking about on - Yahoo!...
Inside SQL Server 2005 Programming - Itzik Ben Gan Inside SQL Server 2005 Querying - Itzik Ben Gan Inside SQL Server 2005 Storage Engine - Kalen Delany Pro SQL...
One more SQL Server 2005 T-SQL Recipes - A Problem-Solution Approach - J.Sack - Apress Aneesh R. SQL Server MVP, Expert Exchange.com Genius SQL server ...
Hi Sunil, I have faced the same few days back. Make sure that no one is accessing your destination tables or source tables, You can check for the SPid in ...
Hi Birumanand, There is no locking happing i checked that and more over the select statment which i am using in the export is with "nolock" so there is no...
Can any one suggest any good books on SQL server 2005 admin.my Library asking me ? dilip ... Find out what India is talking about on - Yahoo! Answers India ...
Will DTS packages helps in this case....??? Still stuck with same issue ... query ... ran ... files ... Standard ... - ... CARD0003') ... mst_batchno ... - ......
Raj can you try using BCP rather than DTS for this ... ________________________________
From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On...
is there any huge inserts happened recently on the source tables? I uspect the fragmentation, is the source table is under have regular index maintenenace...
Dear Kalyan, Thanks for the reply, there is no huge insert happened recently to the source table. This is the scenario: we have a set of table which is used...
Hi all, I need some in-depth clarifications related to DBCC SHOWCONTIG and FillFactor. when I issue a command dbcc showcontig(<tableName>) DBCC SHOWCONTIG...
Sunil, I think I am not clear to you. Just tell me how frequently you are rebuilding your index on source tables? Even though the tables have indexes, you may...
Dear Kalyan, Here is the output of the DBCC. please guide me with ur findings. DBCC SHOWCONTIG scanning 'MOQueues' table... Table: 'MOQueues' (82099333); index...
Sunil, The indexes on this table is highly fragmented. Run this statment soe time on off-peak hours, this can improve performance. DBCC DBREINDEX(MOQueues) ...
Hi Kalyan, I checked with different tables in different database in same instance, all have the same problem :( . So the problem is not with the table, but...
Looks strange what is the result of dbcc showcontig after running dbcc dbreindex?? How much free space is there on the drive where the db files exists? what is...
Hi Sunil, Post the Server Box configuration and the full scenario.. No of users accessing the Server etc...It depends on many thing.. When you have many...
Dear Madhu, We have sql server 2000 installed on windows 2003 server. sql server is kept as default settings. there is only one instance running on this...
Hi Veer, Tried out with DTS package, it's working and the process is under monitoring. The DTS package has consumed 80-85% system memory and not releasing the...
Dear paddy, We have enough physical storage space. i don't know what is the issue thatz what i need help from u all. please guide me. Best Regards Sunil John ...
Hi Veer, Tried out with DTS package, it's working and the process is under monitoring. The DTS package has consumed 80-85% system memory and not releasing the...
Hi Raju, I had asked to try BCP rather than DTS ...? Did you try that one ...? Regards Veer Ji Wangoo
ITIL, MCDBA , Certified PMP Microsoft MVP SQL Server , ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
