Viewing 15 posts - 676 through 690 (of 2,064 total)
Congratulations on passing the STIg audit
May 6, 2015 at 2:11 am
It will be hard to find drivers that connect to Oracle 8i.
Perhaps you could export the database and import it into Oracle 12 and use that as a source for...
May 5, 2015 at 4:09 am
The databases were fully backupped once?
Databases are in full/bulk logging mode?
Perhaps there are long running transactions/replications going on
You could convert the maintance plan to a normal job to see what's...
May 5, 2015 at 4:06 am
How are you quering Oracle through SSRS?
Using SQLServer as a datasource and using the LINKEDSERVER..SCHEMA.TABLE / OPENQUERY notation
Or Using Oracle as a datasource?
Is it possible to post the query?
April 29, 2015 at 9:37 am
Waittypes of the queries (IO/NETWORK/CXPACKET/...)
Can be done with sp_Whoisactive or the dynamic management views.
April 29, 2015 at 9:21 am
MS SQL Server max memory does not include reporting services.
Total memory-MS SQL Server max memory= memory for OS, SSRS, SSAS, SQL Agent, SSIS, other applications
March 12, 2015 at 7:45 am
Thanks for the build list.
I'm relying on sqlserverbuilds.blogspot.be[/url] as it has the builds up to SQL 7.
February 23, 2015 at 3:26 am
Did you try casting p.TriggerDate >= '06-Nov-2014'
to a date-variable? (instead of relying on strings)
->where p.TriggerDate>=TO_DATE('2014-11-06','YYYY-MM-DD')
February 4, 2015 at 6:16 pm
Whilst there are people who can soak knowlegde, actually applying certainly helps.
Can't forget about maintaining it, so your brain doesn't purge it.
January 27, 2015 at 4:30 am
Oracle Client and the use of OracleOleDB?
MSOra is probably the old deprecated oracle driver
January 20, 2015 at 8:40 am
Congratulations Koen, keep writing!
January 14, 2015 at 7:30 am
Glad you keep the thread awake
January 12, 2015 at 12:09 pm
Happy Holidays and a fun New Year.
December 29, 2014 at 7:26 am
Viewing 15 posts - 676 through 690 (of 2,064 total)