(Chris Eaton) DB2 has what are called “monitor switches”. These are settings that instruct DB2 to gather more specific information if a given switch is turned on. There is however a wealth of information that can be obtained without having to turn any switches on.
Other News
Query data faster using sorted hash clusters
(Scott Stephens) When data is stored in a normal table, the rows are physically stored in allocated blocks in the order in which you insert them into the database. For example, if you have a table of information about employees, the employees’ names would typically be stored in the table in the orde
ATG White Paper: Understanding Web Content Management Systems
As the complexity of Web applications has increased, so have the tools required to manage them. Over the years, Web content management has evolved dramatically from the days of flat files and FTP. (pdf)
Business Intelligence Goes Back to the Future
(Rick Sherman) It is said if we fail to learn from history we are destined to repeat it. This sentiment rings true in the IT industry where it appears that a new generation of people – IT, consultants and vendors – and projects emerge every three to four years with everyone thinking that their appro
SQL Server normalization rules you must follow
(Greg Robidoux) In this tip we will take a look at database normalization and the advantages and disadvantages of normalization for SQL Server databases. (R)
Exploring the various uses of SQL’s CASE keyword
(Arthur Fuller) The CASE keyword may be one of the most underused keywords in SQL. While you’ve probably used it to create a column, it has many more uses. For example, you can use CASE in a WHERE clause.
Working with ADO.NET
(Anand Narayanaswamy) This article, part one of a series, discusses the workings of ADO.NET. With the help of an example application, you will learn to manipulate data in a Microsoft Access database, including how to insert, search, and navigate records.
DB2 UDB security, Part 1: Understand how user and group accounts interact with DB2 UDB
(Ted J. Wasserman and Raul F. Chong) Granting database access, authorities, and privileges to users and groups is one of the primary means of ensuring the security of your data. This article describes the different user and group accounts that are needed to install and work with IBM DB2 Universal Da
FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000
When you use a SELECT statement to fetch information from a view, and the SELECT statement returns an error message in Microsoft SQL Server 2000, the error message may contain user data. The user data is not returned in the final result if the SELECT statement successfully fetches data from a view.
A Lesson in Interactive Marketing
(David Baum) Customer relationship management (CRM) has made significant inroads at commercial firms, where companies use the software to help acquire, nurture, and retain loyal customers. Just as for-profit business ventures and other organizations intent on gaining market share value customer rete