(Serdar Yegulalp) SQL Server table indexes have a kind of voodoo to them that can be alienating. The bigger the table and the more commonly it’s accessed, the greater the need for a properly tuned index.
Other News
WPF: Sorting Grouped Data in a ListBox
(Ged Mead) I’ve written a few blogs recently that look at various ways of handling XML data in a WPF application. Certainly more than I set out to do! But, that’s the way it goes, isn’t it? As son as you crack one problem, you think of something else you’d like or need to do to improve it. And s
IBM Optim Performance Manager for DB2 for Linux, UNIX, and Windows
(Whei-Jen Chen, Ute Baumbach, Robert Borovsky, Sonali Kenge, Marcia Miskimen and Ling Xu) Optim Performance Manager Extended Edition, a follow-on to DB2 Performance Expert, is one of the key product of the IBM Optim Solution. Optim Performance Manager Extended Edition provides a comprehensive, proac
Users and Database Authorization for Oracle Database XE
(W. Jason Gilmore and Bob Bryla) Changing the characteristics of a user is accomplished by using the ALTER USER command. The syntax for ALTER USER is nearly identical to that ofCREATE USER, except thatALTER USERallows you to assign roles as well as grant rights to a middle-tier application to perfor
Exploration of New Methods in Crystal Reports WPF Viewer
(Eric Landes) This article delves into the new methods exposed in Crystal Reports new WPF Viewer. These methods include the ReportDocument.BeforeFormatPage Event, the ReportRequestStatus.NumberOfPages, and more.
WPF DataGrid Style
(Nipun Tomar) The DataGrid control provides a flexible way to display a collection of data in rows and columns. The DataGrid includes built-in column types and a template column for hosting custom content. The built-in row type includes a drop-down details section that you can use to display additio
SOA Basics
(Kerrie Holley and Ali Arsanjani) This chapter from 100 SOA Questions answers the questions, what is SOA, is SOA an architectural style, what are fundamental constructs (the DNA) of SOA, what is the difference between a Web Service and an SOA service and what makes a project an SOA implementation?
Script Task and Event Logging in SSIS
(Marcin Policht) SSIS offers extensive logging capabilities, allowing you to record predefined events raised by packages and their components. These same configuration settings can be leveraged in Script Task, but you also have the option of triggering and tracking events in a considerably more cust
IBM Informix Dynamic Server Enterprise Replication templates
(Pravin Kedia) Learn how to use the new templates in Informix Dynamic Server, Version 10.0, to administer a large number of Enterprise Replication nodes and tables. Introducing IBM Informix Dynamic Server, Version 10.0, Enterprise Replication templates. Learn how to use templates to administer a lar
Using INSERT / OUTPUT in a SQL Server Transaction
(Tim Ford) Frequently I find myself in situations where I need to insert records into a table in a set-based operation wrapped inside of a transaction where secondarily, and within the same transaction, I spawn-off subsequent inserts into related tables where I need to pass-in key values that were t