Sql Statement
46 Stories
Turbocharge SQL with advanced Oracle9i indexing
Insight This article explores the internals of Oracle9i indexing; reviews the standard b-tree index, index-only tables, and how these indexes may increase the speed of Oracle SQL queries.
Create connection-sensitive combo boxes in Access
Insight Many Microsoft Access database applications that work well on a local system will choke on a greater number of users. Here's a simple procedure to keep the Access database combo box controls responsive, whether you have 10 items or 50,000 in a list.
Find blocking processes using recursion in SQL Server 2005
Techguide When SQL Server 2005 algorithms find blocking incidents, they can stop one process so another can finish its work.
Tags: Microsoft Server 2003
The Bobby Tables guide to SQL injection
Techguide Avoiding SQL injection vulnerabilities is much easier than you might think. XKCD inspired a simple tutorial.
Tags: Network security, Security Management, Security implementation/standards, Data security, Allaire ColdFusion, SQL statement, Vulnerability, CompTIA, SQL, content management system
10+ tips for working smarter with SQL
Techguide The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started.
Tags: Protocols and platforms, Column, Clause, Table, Value, Statement, Record, SQL, Goto, Microsoft VBA
Quickly return to the location of the last edit
Techguide When you need to review the last edit made to a very large document, you don't need to scroll and read through the entire document to find it. Word automatically remembers the last three locations where you've entered or modified text.
Format EXPLAIN PLAN results easily with Oracle's DBMS_XPLAN
Techguide When you need to troubleshoot inefficient SQL, one of the most important diagnostics tools at your disposal is the output of the EXPLAIN PLAN command. Find out how Oracle's DBMS_XPLAN functions can help you tune your SQL statements.
Generate dynamic SQL statements in SQL Server
Techguide Learn to generate on the fly SQL statements, which can be used to solve tricky database problems.
Tags: Database management, Databases, Servers
Use the advisory framework for indexing advice
Techguide Oracle 10g Release 2 adds a QUICK_TUNE procedure to DBMS_ADVISOR that streamlines the process of getting advice on your SQL statements.
Use Oracle's Expression Filters to build a Business Rule Management System
Techguide Expression Filters, which were introduced with Oracle 10g, allow you to create a column that contains the conditions that must be met for a single row. Here's the code you need to use Expression Filters to build an extremely simple Business Rule Management System.
Position your Word tables attractively on a page
Techguide When working in Word, it's easy to align your tables to the surrounding text without dragging them there. Follow these steps for a streamlined look.
Check the efficiency of Oracle's caching with this report
Techguide It is useful to know the contents of Oracle's data buffers and you can use this report to check up on your database's caching effectiveness.
Tags: Software, Business applications, Databases
Java Database Connectivity revisited
Techguide In this week's Java tech tip, Lee Chuk-Munn looks at JDBC which has been around since JDK 1.1.
Make the migration from ISAM to relational databases smoother
Insight Fundamental considerations for migrating to a relational database.
Playing with user-defined functions
Insight Most developers would list table variables and UDF calls from a SELECT statement as UDFs’ main claim to fame. But there’s much more: They increase functionality with less effort.
