When you run a full-text query in SQL Server 2000 while a catalog merge operation also occurs, the result set may not return quickly. When this delay occurs, the SQL Server User Mode Scheduler (UMS) may stop responding. Additionally, you may experience stalled worker request behavior.
Author: SSWUG Research
How to Add a Gradient Background to a Win Form with VB.NET & VB2005
(Mike McIntyre) This article and two downloadable Visual Studio Visual Basic solutions provide code that overrides the Form OnPaint event to create beautiful gradient backgrounds for a Windows Form. Also included is code that optimizes form drawing.
Design and Documentation: Introducing the Visio 2007 PivotDiagram
(William Pearson) Among several new applications and server-side tools that make their debut in Microsoft Office 2007, many of the tools upon which we, as developers and architects, have relied in the past have also been enhanced in numerous ways. One of the key types of enhancement that continues t
Capture the reporting benefits of database snapshots in SQL Server 2005
(Tim Chapman) Database snapshots are yet another great new feature in SQL Server 2005. A database snapshot is a read-only copy of a database that reflects all database data up to the point in time for which the snapshot is taken.
Apache Geronimo and the Spring Framework, Part 5: Spring MVC
(Arun Chhatpar) Spring Model-View-Controller (MVC) is the most widely used module in the Spring Framework. It’s based on a clean design and provides many classes you can use right out of the box. In this tutorial, the fifth installment of a six-part series, you’ll get a detailed introduction to Spri
Dealing with Attributes and Elements in XPath with XSLT using ASP.NET 2.0
(Jagadish Chaterjee) This is the second article in a series focusing on XPath with XSLT using ASP.NET 2.0. The first article in this series focused on working elements. In this article, I will be focusing on working with attributes, attributes together with elements and searching for elements at var
Specializing xi:include
(Eliot Kimber) I’ve posted before about how useful it is to specialize the XInclude include element–it makes authoring easier, it lets you define constraints on what can be referenced, etc.
Oracle Applications Password Decryption
Most Oracle Applications 11i implementations are vulnerable to a significant security weakness in the encryption of passwords within the application where an insider may be able to circumvent all application controls by accessing any application account or obtain the APPS database account password.
Getting real life query speeds with MySQL
(Peter Zaitsev) To check for query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query and see if there is any significant improvement.
SQL to View Registry Variables
(Chris Eaton) In DB2, registry variables can be used to modify the behavior of the data server. Registry variables are set and viewed using the db2set command. There are a number of registry variables and they are described in the Information Center.