Friday
Feb252011

Optimize Oracle with CLUSTER's and Index Organized Tables

We have a few nightly processes and day-end reports that are causing contention in the database and all around performing badly.  Look at my latest post under the Oracle heading to the right, under "Oracle - performance tuning" for how I solved these issues using Oracle CLUSTER's.

 

Cheers!

Thursday
Dec162010

How are they getting access?

I had to chase down a SQL Server permissions issue the other day.  In the mess of Windows Integrated Security its sometimes difficult to unwind the tangle of permissions threads to see who actually has rights to the database.

Check out the post under SQL > Security for common queries to determine who has access to what.

Cheers

Thursday
Dec022010

Reducing SQL transaction logs - revisited

My previous post was incomplete.  I've updated the post to accommodate shrinking of those large .ldf files - all without taking the databases down.

Sunday
Nov212010

Part two: E-mail Oracle query results

This time in a spreadsheet attachment which end users can conceivably manipulate using Excel.  Not as elegant as it could be, but still quite useful.

Check out the posts under the Oracle heading.

Cheers

Saturday
Oct162010

E-mail Oracle Query Results

Had an occasion to e-mail Oracle query results to internal customers.  Check out my "Oracle" section on the right for an easy way to send query results in the body of an e-mail message.

Cheers!

Page 1 ... 2 3 4 5 6 ... 8 Next 5 Entries ยป