Self Test Software is Oracle’s only authorized practice test provider, and their practice tests map to the real exams, guaranteeing students complete coverage of the Oracle objectives as they prepare.
Author: SSWUG Research
Using TABLE Variables
Table variables are just plain cool. If you’re using temporary tables and don’t need transactions on those tables and want better performance I’d strongly consider using table variables instead. Table variables were introduced in SQL Server 2000. You create a table variable the same way you c
The Data Is Job One
By Michael Otey – Solving problems, learning about new technology, or writing stored procedures to address user requests might be more fun, but ensuring database consistency and recoverability comes first.
Learn how to restore databases in Microsoft SQL Server
MCSE and MCDBA Steven Warren demonstrates how to restore a SQL Server database backup to working order. From completing a full restore or restoring using T-SQL to performing a differential database restore or transaction-log restore, Warren’s got it covered in these step-by-step illustrated instruct
XML and the IETF: Making the case for RELAX NG
In a message to the ietf-xml-use mailing list, James Clark makes a detailed case for giving RELAX NG at least "equal billing" with the W3C XML schema language as a recommended formalism in IETF protocols using XML.
Introdution to XQuery (Part 2 of 4)
by Srinivas Pandrangi and Alex Cheng, et al. – Part 2 of this article builds on the XQuery language introduced in Part I of this series, digging more deeply into the XQuery data model. You'll see how to use XQuery's simple typed values, nodes, sequences, constants and variables, and operator
RDF Site Summary 1.0 Modules: Service Status
This module extends RSS to include elements which allow the description of the status and current availability of services and servers. Some data, such as whether a server is up or not, would normally be generated automatically, whilst other data, such as explanatory text for humans, might be
SQL Server & XML integration
By Jonathan Lurie & Timothy Stockstill – Microsoft was initially slow to develop an Internet product. I recently read a quote from a ranking Microsoft employee who said, “If you cut us, we bleed XML.” While this may seem a little dramatic, it happens to be true: XML seems to be everywhere in Microso
Log-File Growth and DBCC DBREINDEX
From SQLMag – I have a 30GB database, and I use the Full recovery model. Whenever I use Database Consistency Checker (DBCC) DBREINDEX to periodically reindex certain large tables, I change the recovery model to Bulk_Logged, then return it to Full after the reindexing is complete. I expected that thi
Quick Dynamic SQL
by Bhagwan Mer – Description: I created these small snippets of dynamic PL/SQL programs for easy reference. I hope they are helpful.