(Flavio Casetta) I just noticed that view USER_TS_QUOTAS, giving the list of tablespace quotas on the granted tablespaces, in version 10GR2 comes with an additional column called “DROPPED”, containing a YES/NO flag.
Other News
Mini-Tip #11: Synonyms
(Lewis Cunningham) Today I am going to talk about synonyms and what you should NOT do with them. Since this is a MINI tip, it will be short and sweet. I will not cover every aspect of synonyms.
Boosting DB2 9 for z/OS Performance
(David Beulke) DB2 9 for z/OS has many new features that give database and application designers greater flexibility to solve business problems. I recently helped a client with an application design review and saw first hand how implementing many of these features can immediately and dramatically im
Comparing Tables Organized with Clustered Indexes versus Heaps
(Burzin Patel and Sanjay Mishra) In SQL Server 2005, any table can have either clustered indexes or be organized as a heap (without a clustered index.) This white paper summarizes the advantages and disadvantages, the difference in performance characteristics, and other behaviors of tables that are
Five months with MySQL Cluster
(Brian Moon) So, the whole world changed at dealnews when Yahoo! linked us. We realized that our current infrastructure was not scaling very well. We had to make a change.
XML and the DataSet
With ADO.NET you can fill a DataSet from an XML stream or document. You can use the XML stream or document to supply to the DataSet either data, schema information, or both. The information supplied from the XML stream or document can be combined with existing data or schema information already pres
Performance analysis tools for SQL Server
(Serdar Yegulalp) It’s something of a truism that a complex SQL Server setup needs to be tuned to run properly. The good news is that most of the SQL Server tools you can pick up to accomplish that job are either already available in your backyard, or can be downloaded for nothing. What’s required m
Data Warehousing: Ensuring Data Integrity with End-to-End and Statistical Process Controls
(Cindy Maurer) Data warehousing holds much promise to provide competitive advantage through derived business intelligence, but the promise cannot be realized unless you ensure the integrity of your data. To ensure data integrity you must have end-to-end controls and the ability to identify data anom
Changing Hostnames in Oracle RAC
(Alex Gorbachev) Sometime there is a desperate need to change hostnames for one or all nodes of an Oracle RAC cluster. However, this operation is not officially supported.
Top 10 Reasons To Deploy DB2 9 For z/OS Now!
This exciting ninety minute webinar will examine the top 10 most compelling reasons that will convince managers, database administrators (DBAs), and application developers to install and deploy DB2 9 for z/OS as quickly as they possibly can! (R)