Category Archives: SQL Server

Performance tips

One pretty cool new feature of Oracle 11g that DBAs may not be aware of is the client result cache. This stores the result sets of queries hinted with /*+ result_cache */ locally in-memory on the client. It’s much better … Continue reading

Posted in Oracle, SQL Server | 2 Comments

Porting stored procedures

(Based on a Stack Exchange post) In SQL Server, a common pattern is to wrap some processing in a stored procedure that returns a standard result set, using a local temporary table, which is to say a table defined within … Continue reading

Posted in Oracle, SQL Server | Leave a comment