Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Why isn't my subquery updateable?
- The best of intentions often fail when writing a subquery. If you can't update your data via a subquery, there's an alternative. by Susan Harkins
- Tags: Query, Susan Harkins
- Blog posts 2008-07-18
- XML Schema: Understanding Datatypes
- The W3C XML Schema Datatype Specification defines numerous datatypes for validating the element content and the attribute value. These datatypes can be used to validate only the scalar content of elements, and not the non-scalar or mixed content. The text enclosed between the and element tags, and the value of...
- Tags: XML Schema, W3C XML Schema Datatype Specification, XML, Software/Web Development, Web Development
- White papers
- WSQ image library (for fingerprints) (zip)
- Reads and converts WSQ (FBI's Wavelet Scalar Quantization) and 31 other formats. Supports: WSQ, BMP, TIFF, PNG, JPEG, RGB, TGA, GIF, CEL, PSD, IFF, PCX, etc. For fingerprint images WSQ Wavelet Scalar Quantization is superior to other lossy compression methods, such as JPEG, and was chosen by FBI (U.S. Federal...
- Tags: FBI, JPEG, Federal Government, Government
- Software downloads 2006-07-21
- Mini-Tip #8 - Extending XMLType to Access Scalar XPath Functions
- For some reason, the XMLType XPath implementation does not allow scalar results. According to the documentation:EXTRACTXML is similar to the EXISTSNODE function. It applies a VARCHAR2XPath string and returns an XMLType instance containing an XML fragment.Extractwill only return an XMLType. A scalar value would be a function thatreturns a...
- Tags: Extending XMLType, Microsoft Access, XMLType XPath, XPath
- Blog posts 2006-09-22
- Working with nested subqueries in SQL Server
- Example: Bad! Subqueries: WORSE!Firstly, the example given here is an extremely poor one because Using IN creates a temp table for every item in the IN list. If each of these subqueries only returns 10 records, this query will create 1000 temp tables. Very inefficient. SQL is not designed to...
- Tags: subquery, Jeff_D_Programmer, sql scripting, software, programming, queries, sql, sql query, query, join, Microsoft SQL Server, server
- Discussion threads 2007-01-30
- Working with nested subqueries in SQL Server
- Arthur Fuller provides an example that demonstrates the power of nested subqueries. He notes that nested subqueries can help you find the answers you need when the pieces are scattered across a number of tables. Many SQL Server programmers are confused about the use of subqueries, especially nested subqueries...
- Tags: Microsoft SQL Server, Arthur Fuller, Databases, server, subquery, nested subquery, SQL Server Newsletter, TechRepublic Inc., Table, Enterprise Software, Software, Data Management
- Technical articles 2007-01-29
- Tape Consolidation With the Sun Storagetek L1400 Tape Library - Achieving Midrange Storage Efficiencies: An Overview and Comparison With the Quantum Scalar i2000
- This paper introduces general tape consolidation concepts and describes the Sun StorageTek L1400 tape library features that support consolidation. Consolidation benefits fall into three key areas: improved IT productivity, the ability to respond quickly to changing business priorities, and lowered TCO through increased asset utilization. In support of these areas,...
- Tags: Consolidation, Tape Library, Sun Microsystems Inc., StorageTek, Quantum Corp., Backups, Roi/Tco, Storage Management, Storage, Finance, Managerial Accounting, Hardware
- White papers 2007-09-01
- Optimize SQL Server queries with these advanced tuning techniques
- More good inputThanks again Tim. I've been following this line of posts because the topic has been speed. Thanks for pointing out the STATISTICS IO option. This is one of those "nuggets" that I always look forward to discovering and now that I know about it, I...
- Tags: thisisfutile, technique, advanced tuning technique, Optimize SQL Server, subquery, server
- Discussion threads 2007-09-18
- Adaptive Multi-Valued Volume Data Visualization Using Data-Dependent Error Metrics
- Adaptive, and especially view-dependent, volume visualization is used to display large volume data at interactive frame rates preserving high visual quality in specified or implied regions of importance. In typical approaches, the error metrics and refinement oracles used for view-dependent rendering are based on viewing parameters only. The approach presented...
- Tags: Data Visualization, Error Metric, Databases, Enterprise Software, Software, Data Management
- White papers 2008-01-01
- IBM supercomputing goes retro
- Never is a Long Time...Perhaps "soon to Famous" Last Words, from Cray engineer: Steve Scott, an X1 chief architect. "Trying to hook multiple scalar processors into a vector processor is never going to be as effective as a real vector processor."This remark may sound like Bill Gates' remark in the...
- Tags: Dilbert-Tom, IBM Corp., IBM supercomputing, processor, retro, supercomputing
- Discussion threads 2004-10-26
- Understand when to use user-defined functions in SQL Server
- Thank Tim.Good information.You said, "I usually discourage using scalar-valued UDFs in a WHERE criteria statement" and that's exactly some of the things a developing database manager, like myself, needs to know. It's one of those things I find myself wondering about, but I just can't make the time to...
- Tags: Databases, user-defined function, Microsoft SQL Server, thisisfutile, server, UDF
- Discussion threads 2007-09-04
- Oracle Tip: Understand how NULLs affect IN and EXISTS
- On the surface, it may appear that the SQLclauses IN and EXISTS are interchangeable. However, they're quitedifferent in how they handle NULL values and may give differentresults. The problem comes from the fact that, in an Oracledatabase, a NULL value means unknown, so any comparison oroperation against a NULL value...
- Tags: Databases, Oracle Corp., IS NULL, clause
- Technical articles 2004-08-22
- I need a help with sql nested sub query please.
- Hi,I can create this view;CREATE VIEW view1 ASSELECT p.bedno, p.refno, p.surenameFROM patient pWHERE p.bedno = (SELECT bednoFROM bed WHERE bedstatus = 'USED');But when I "SELECT * FROM view1", I get this error message it says " ERROR at line 2: ORA-01427: single-row subquery returns more than one row".I need count...
- Tags: alan.sarchnar@..., SQL
- Discussion threads 2007-03-21
- Incorporate SQL Server UDFs in your .NET applications
- Database interaction is a standard feature of most .NETapplications, with SQL Server as the popular choice for the data tier.Consequently, .NET developers often find themselves developing T-SQL codewithin their applications or stored procedures on the database server.Developers often overlook a number of the features in theT-SQL language. For instance, when...
- Tags: Database interaction, Microsoft .NET, Microsoft SQL Server, Microsoft SQL Server Transact-SQL, Tony Patton, User Defined Function
- Technical articles 2005-10-18
- On the Behavior of Optimal Scheduling Algorithms Under TCP Sources
- This paper focuses on the dynamical interaction between regulated Additive Increase Multiplicative Decrease AIMD traffic sources and the max-scalar scheduling policy, which has been proved to be optimal in terms of throughput in case of stationary unregulated traffic sources. It describes the average dynamics of both sources and queues dynamics...
- Tags: Algorithm, TCP, Dynamics, Source, Tcp/Ip, Engineering, Networking
- White papers 2007-03-19
- Compute the percentage of a total with Oracle's RATIO_TO_REPORT
- Many reports include a percentage of the report total on each line, in addition to the detail data being reported. For example, what percentage does each customer contribute to all of the orders placed in a month, or what percentage does each sales rep contribute to the total sales?The traditional...
- Tags: oracle, databases
- Blog posts 2007-07-17
- CardioViz3D (exe)
- CardioViz3D is a free software, dedicated to the visualization and processing of dynamic medical data. A large range of image format is supported (DICOM, Analyze, VTK, NIFTI), as well as mesh files VTK format. Image/mesh dynamic sequences can be imported or constructed. Dynamic scalar field on meshes can be displayed....
- Tags: Inria, CardioViz3D, Productivity, Tools & Techniques, Management
- Software downloads 2008-05-08
- Linear Algebra (zip)
- Linear Algebra performs computations associated with matrices, including solutions of linear systems of equations even over-determined or inconsistent systems and solution by LU factors. The program also performs matrix operations (add, subtract, or multiply), finds determinant, trace, inverse, adjoint, QR or LU factors, eigenvalues, eigenvectors, establishes the definiteness of a...
- Tags: Linear Algebra
- Software downloads 2004-11-17
- Using a PL/SQL Table in SQL
- A friend of mine called a fewdays ago with a question. He wanted to populate a PL/SQL table and useit to compare to some other data via a NOT IN subquery. He was having aproblem getting the data into the nested table and wasn't sure how toaccess it from SQL...
- Tags: PL/SQL, PL/SQL Table, SQL
- Blog posts 2006-08-10
- << Previous
- page 1 of 1
- Next >>
