with Robert Catterall – We have a segmented tablespace growing over the 2G dataset limit that’s now in the second 2G dataset. But we don’t have the proper operations window to convert the tablespace into a partitioned tablespace. What is the maximum limit (in GBs) for a segmented tablespace?
Other News
Oracle Tackles Licensing
By Lisa Vaas – Oracle Corp. on Tuesday tackled licensing, an issue that has long bedeviled users and that experts say could trip up customer acceptance of the company’s recently unveiled 10g grid technology.On Tuesday, the Redwood Shores, Calif., company held the first of a series of pricing
IBM Stumping for WebSphere on Windows
As more enterprises find themselves adding Windows machines amongst Unix, Linux, and mainframes, IBM concentrates on communicating competitive advantages in security and scalability—even in a platform polyglot.
DB2 Data Bound ASP.NET Form Using VS.NET
This tutorial from Visual Studio .NET expert Abdul Al-Azzawe demonstrates how to use the DB2 Development Add-In for VS .NET to build a rich ASP.NET WebForm in C# using design-time and run-time data binding.
Can’t Anyone Write Good SQL These Days?
by Jack Herrington – There are many up-and-coming database access protocols, but exactly what do we need them for? Is it possible that those who would like to replace SQL for being slow should learn to write better SQL?
SQL Server Profiler and Parameterized Statements
Since upgrading to SQL Server 2000, I have encountered a problem in SQL Profiler: I am unable to capture parameterized Transact-SQL statements. Instead of the parameter @p1, I want the actual value used in the query execution. How can I place the substitution without referencing other lines in the t
A Conversation with Jim Gray
Gray, head of Microsoft’s Bay Area Research Center, sits down with Queue and tells us what type of a voracious appetite for data could require such extreme measures. A recent winner of the ACM Turing Award, Gray is a giant in the world of database and transaction-processing computer systems. Before
Track and Make SQL Server Database Schema Changes with AdeptSQL DIFF
by Brad M. McGehee – You are one of a team of developers working on a new internal application that uses SQL Server as its backend. Two of the team members, including yourself, have been assigned the task of database design and maintenance, while four others have been assigned the task of writing th
How to Identify Real Versus Automatically-Created Indexes
I’ve noticed a lot of entries in the sysindexes table for indexes that I didn’t create. I heard that they’re not real indexes but statistics that the SQL Server query optimizer has automatically created. How can I tell if an index is “real” or one automatically created by SQL Server?
IBM patching DB2 vulnerability
By Paul Roberts – IBM released a software patch for a serious security vulnerability in some versions of its DB2 Database, according to the security company that discovered the problems.