Bind Variables Archives - Steve Stedman

How much Procedure Cache memory does one SQL Statement take up?

by SteveStedman
September 17, 2008November 25, 2011
1 Comment
DBA

I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning… Read More »How much Procedure Cache memory does one SQL Statement take up?

A Comparison of Oracle and MySQL

by SteveStedman
June 1, 2007March 7, 2012
Steve

MySQL is to Oracle as Linux is to Windows. Limiting Result Sets Oracle supports ROWNUM to limit the result Sets SELECT * FROM tablename WHERE… Read More »A Comparison of Oracle and MySQL