Database News
Features
Scripts
MySQL
MS SQL
Oracle
MS Access
DB2
PostgreSQL
SAP
PHP
Forums
Search
Facebook
Linkedin
Twitter
looking for something?
Search
Database News
Features
Scripts
MySQL
MS SQL
Oracle
MS Access
DB2
PostgreSQL
SAP
PHP
Forums
26 articles written
Rob Garrison
Rob Garrison is a database architect at Fiserv in Portland, Oregon specializing in OLTP design and development. He has over twenty years of IT experience, with over ten years in database development and architecture.
Popular Articles from Author
MySQL
Eliminating Duplicate Rows from MySQL Result Sets
Robert Gravelle
-
November 12, 2010
0
The go to solution for removing duplicate rows from...
MySQL
Top Common MySQL Queries
Kelsey Perkins
-
April 5, 2022
0
MySQL queries are usually written once and then wrapped...
Oracle
Generating random numbers and strings in Oracle
Amar Kumar Padhi
-
May 25, 2004
0
Do you know how to auto generate random numbers...
Explore Author Articles
MS SQL
Performance Testing SQL 2008’s Transparent Data Encryption
Rob Garrison
-
April 20, 2009
MS SQL
Exploring SQL Server 2008’s Filtered Indexes
Rob Garrison
-
March 27, 2009
MS SQL
Performance Testing SQL Server 2008’s Change Data Capture functionality
Rob Garrison
-
February 27, 2009
MS SQL
SQL Server 2008’s Change Data Capture – Tracking the Moving Parts
Rob Garrison
-
January 23, 2009
MS SQL
Performance Testing – SQL Server 2008 versus SQL Server 2005
Rob Garrison
-
December 26, 2008
MS SQL
Exploring SQL Server’s Index INCLUDEs
Rob Garrison
-
November 28, 2008
MS SQL
Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()
Rob Garrison
-
October 24, 2008
MS SQL
SqlCredit – Part 19: Exploring SQL 2005’s Ranking Functions – RANK() and DENSE_RANK()
Rob Garrison
-
September 26, 2008
MS SQL
SqlCredit, Part 18: Exploring the Performance of SQL 2005’s OUTPUT Clause
Rob Garrison
-
August 21, 2008
MS SQL
SqlCredit – Part 17: Exploring SQL 2005’s OUTPUT Clause
Rob Garrison
-
July 25, 2008
MS SQL
SqlCredit – Part 16: The Cost of Bloat
Rob Garrison
-
May 23, 2008
MS SQL
SqlCredit – Part 15: The Cost of Distribution
Rob Garrison
-
April 25, 2008
Latest Articles
SQL SORT BY Statement
Ronnie Payne
-
March 21, 2023
Working with NULL Values in SQL
Ronnie Payne
-
March 9, 2023
Working with SQL AND, OR, and NOT Operators
Ronnie Payne
-
February 21, 2023
How to Use Databases With Python
technologyadv
-
February 10, 2023