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...
4643
radhye
Nov 1, 2006 6:28 pm
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...
4644
Madhu K Nair
madhuotp
Nov 2, 2006 4:37 am
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...
4645
sunil john
suniljk7
Nov 2, 2006 6:31 am
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...
4646
dilip kumar
dilipkumar_a...
Nov 2, 2006 7:32 am
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!...
4647
dilip kumar
dilipkumar_a...
Nov 2, 2006 7:39 am
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!...
4648
Roji P Thomas
roji_pt
Nov 2, 2006 7:50 am
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...
4649
aneesh
aneeshattingal
Nov 2, 2006 8:32 am
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 ...
4650
sunil john
suniljk7
Nov 2, 2006 9:07 am
Dear all, Please relpy to this mail... am waiting for your answers :) Best Regards Sunil John ... From: sunil john <suniljk7@...> To: SQL...
4651
biruma nandan
birumanand
Nov 2, 2006 9:25 am
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 ...
4652
sunil john
suniljk7
Nov 2, 2006 9:42 am
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...
4653
dilip kumar
dilipkumar_a...
Nov 2, 2006 11:52 am
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 ...
4654
Rajinder Raina
raina_raj77
Nov 2, 2006 1:38 pm
Will DTS packages helps in this case....??? Still stuck with same issue ... query ... ran ... files ... Standard ... - ... CARD0003') ... mst_batchno ... - ......
4655
Veer Ji Wangoo
vwangoo
Nov 2, 2006 2:24 pm
Raj can you try using BCP rather than DTS for this ... ________________________________
From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On...
4656
smart chip
knowledge_chip
Nov 2, 2006 5:26 pm
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...
4657
sunil john
suniljk7
Nov 3, 2006 8:14 am
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...
4658
shyam koti
shyam_k25
Nov 3, 2006 8:30 am
Hi all, I need some in-depth clarifications related to DBCC SHOWCONTIG and FillFactor. when I issue a command dbcc showcontig(<tableName>) DBCC SHOWCONTIG...
4659
smart chip
knowledge_chip
Nov 3, 2006 4:35 pm
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...
4660
sunil john
suniljk7
Nov 4, 2006 5:55 am
Dear Kalyan, Here is the output of the DBCC. please guide me with ur findings. DBCC SHOWCONTIG scanning 'MOQueues' table... Table: 'MOQueues' (82099333); index...
4661
smart chip
knowledge_chip
Nov 4, 2006 6:47 am
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) ...
4662
sunil john
suniljk7
Nov 4, 2006 11:12 am
hi kalyan, Still now its not working :( its taking huge time. plase guide me with some other way? Best Regards Sunil John ... From: smart chip...
4663
sunil john
suniljk7
Nov 4, 2006 11:52 am
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...
4664
smart chip
knowledge_chip
Nov 4, 2006 3:20 pm
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...
4665
Madhu K Nair
madhuotp
Nov 4, 2006 3:43 pm
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...
4666
sunil john
suniljk7
Nov 5, 2006 7:55 am
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...
4667
PRASHANT PADMANNAVAR
paddyprash
Nov 5, 2006 2:40 pm
Hello Sunil, Please explain the Physical data storage of files and are you finding any I/O performance issues? Thanks, paddy ... From: sunil john...
4668
Rajinder Raina
raina_raj77
Nov 6, 2006 5:38 am
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...
4669
sunil john
suniljk7
Nov 6, 2006 5:44 am
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 ...
4670
Rajinder Raina
raina_raj77
Nov 6, 2006 5:44 am
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...
4671
Veer Ji Wangoo
vwangoo
Nov 6, 2006 8:04 am
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 , ...
