(Jatin Kumar Shah) This script creates a report of all user owned tables and their columns with data types and nullability information.
Community
Index Optimization Tips
In this article, Alexander Chigrik shows you how you can improve the speed of your queries by choosing the proper indexes, what kinds of indexes MS SQL Server supports and what is the advantage and disadvantage of using indexes in a particular situation.
New Onyx CRM Suite Supports Oracle Database
By Erika Morphy – Because the Onyx architecture separates the application, database and hardware, the company is positioned to offer additional database support without a lot of work.
Growing RDF mindshare reflected in XML Web Services One keynote
The halls and meeting rooms at the XML Web Services One conference in San Jose were abuzz with discussion of RDF technology, and the keynote presentation by Willaim Ruh, Sr. VP of Professional Services at Software AG, focused on the importance of semantic Web technologies to the future of Web servic
Advanced UI Design Using XML and XSL – Part 7: Relational Folder Tree Lines
By Joe Slovinski – Welcome to Advanced UI Design Using XML and XSL. Each article in my series will demonstrate the creation of a specific user interface (UI) component using eXtensible Markup Language (XML) and eXtensible Stylesheet Language (XSL). This article expands on a previous article in this
Tip: Using pull-based DOMs
By Uche Ogbuji – XML application developers usually have to contend with the complexities of SAX or the inefficiencies of DOM. This tip shows how a pull approach to DOM can effectively bridge the gap between the two by offering simple, efficient parsing.
Enlighten
By Alan Joch – Take the next step beyond business intelligence. Tight integration of core BI technologies in the Oracle database kernel and Oracle9iAS gives you true business insight, in real time, from one place: the database.
Oracle and Open Source Technologies and Applications
Sean Hull has compiled this extensive collection of open source tools that can be used with Oracle databases. Sean is a coauthor of Oracle & Open Source.
Fun with Numbers in Transact-SQL Queries
by Vyas Kondreddi – Recently, someone asked in a Microsoft public SQL Server newsgroup how can you sort characters within a string? For example, a string contains ‘CBA’, and he wanted to sort the characters within the string and make it ‘ABC’. Instead of going for a procedural solution, just for fun
INF: SQL Server 2000 Full-Text Search Deployment White Paper (Q323739)
The SQLFulltextsearch.exe file contains the SQL Server 2000 Full-Text Search Deployment white paper.