Follow this DELETE statement example to write parameterized SQL queries in EJB 3.0.

Using EXISTS can improve the performance of your SQL queries.

Discover the flexibility and power of using ANSI SQL to reshape and transform hierarchical structures.

This example shows how to use the findByExample method in Hibernate in conjunction with the SQL AND operator to find and log in a user given an email address and password.

Although Android ships with several useful content providers, you can easily extend it and build your own.

Although adding multiprocessing capabilities to applications is labor-intensive and error-prone, adding multicore capability to SQL query processing can be automatic, benefiting huge numbers of applications with little developer effort.

Determining which queries will provide the best performance for a given application often comes down to a simple question: Does Query X perform better than Query Y? Learn the tools and methods that can help you compare query response times in Oracle.

You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.

Yahoo! has released a base platform that opens up Yahoo! user data via web standard APIs and also provides a framework for how developers, publishers, and advertisers can build applications on and off Yahoo!.

SQL does not support direct operations on matrices, but it does allow easy manipulations with matrices. Learn a few SQL techniques for performing some basic operations on matrices.

Although current databases limit XML processing to linear XPath or XQuery queries, existing hierarchical database techniques enable far more complex queries using standard SQL.

In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute.

To improve query speed, use the UNION ALL statement.

This following code shows you how to extract an image from a database using the getBinaryStream method.

The SQL GRANT command is used to grant access privileges to database objects and role authorizations.

Tracking the activities of a system and its users is too often not considered until the application is already deployed. Learn how to demonstrate an (almost) no hassle persistent bean pool that you can use to track the activities of an already developed system for later review.

Learn how to build robust Matrix-style reports in SQL Server Reporting Services. These advanced reporting techniques make it easier to build a fully-functional report.

In this article, David Leibowitz compares the performance of the prerelease of Microsoft's SQL Server 2008 Reporting Services to SSRS 2005. While it is clear performance improvements have been made for report automation, developers might have differing opinions on the new Report Designer.

Use the script shown in this tip to select a particular number of rows after a certain row in MySQL.

Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.