Viewing 15 posts - 706 through 720 (of 1,155 total)
Try to use Fully Qualified domain names for the TNS Entry like and then try to do TNSPing to the Oracle Box
ServerName.DomainName.Com =
(DESCRIPTION =
(ADDRESS_LIST...
January 11, 2011 at 3:18 pm
Add the Oracle Server to the TNSNamesOra file and then use the Oracle Provider for OLEDB Provider and then create a connection manager to the Oracle Server...
January 11, 2011 at 2:32 pm
Using Oracle SQL Developer is the best way to migrate to Oracle.
If you want to use SSIS then you need to do the data type conversion between SQL...
January 11, 2011 at 12:38 pm
Please execute the following query and check the results
select name,is_name_reserved from sys.database_files
If is_name_reserved =1 , then it indicates that it is waiting for a Log Backup to happen. Once...
January 11, 2011 at 12:19 pm
As Grant mentioned it's better to use Michelle Ufford's scripts or Ola hallengren scripts for the index rebuilds.
I don't think there is any straight forward way to do the parallel...
January 11, 2011 at 12:07 pm
Geoff and Carlton gave very good recommendations. I'd go with Idera SQL Diagnostic Manager.
...
January 11, 2011 at 11:46 am
Pls Check this Script
http://adventuresinsql.com/2010/04/script-to-create-a-tempdb-file-per-processor/
Thank You,
Best Regards,
SQLBuddy
January 11, 2011 at 11:32 am
As Grant and Elliott have mentioned, Processor Affinity should be use with Caution. Please let us know if there is any special reason to do so.
...
January 11, 2011 at 11:28 am
1. Check if the Windows Server or the SQL Server you are trying to connect is down
2. Check if the SQL Server has been configured to use static port, if...
January 11, 2011 at 11:18 am
Please check the SQL Server Error Log's and Event viewer's System Log enteries around that time to find the root cause of the issues.
This could be due to a unexpected...
January 11, 2011 at 11:15 am
That's correct and Gail gave a good explanation as always.
...
January 10, 2011 at 11:26 am
As the Grant, Steve and GSquared have mentioned you can enable parallelism at Server Level or at query level.
MAX Degree of Parallelism is not recommended for OLTP Systems until and...
January 10, 2011 at 11:16 am
Try to use anonymous authentication for your SMTP Server.
Thank You,
Best Regards,
SQLBuddy
January 10, 2011 at 10:38 am
Craig made a good explanation. Also please check the following articles too
http://www.mssqltips.com/tip.asp?tip=1708
Scipts to do Index maintenance
http://sqlfool.com/2009/03/automated-index-defrag-script/
...
January 8, 2011 at 11:18 am
I think the problem could be with the index fragmentation and missing indexes and also may be the disk fragmentation too.
Disk Metrics for K drive look pretty bad. Full scans...
January 7, 2011 at 5:30 pm
Viewing 15 posts - 706 through 720 (of 1,155 total)