(Ilya Petrenko) This query finds how many numbers, upper-lower characters, and symbols.
Author: SSWUG Research
FIX: The sp_droparticle stored procedure performs very slowly if the @immediate_sync property is set to TRUE in SQL Server 2000 Service Pack 4
In Microsoft SQL Server 2000 Service Pack 4 (SP4), the sp_droparticle transactional replication stored procedure performs very slowly if the @immediate_sync publication level property is set to TRUE.
Changing masters
(Jay Janssen) MySQL replication is cool. Almost everyone, when asked what they like best about MySQL, will mention replication. There can be no doubt that many web companies, Yahoo included, owes much to MySQL replication. How else can you scale the reading capacity of your database so easily?
JDeveloper 11g – Model based (ViewObject) List of Values and their end-to-end benefit in the web tier
(Lucas Jellema) In JDeveloper 11g, as another example of declarative productivity, we can add a List of Values definition to an attribute in a ViewObject, indicating that typically that attribute whenever included in for example and ADF Faces page should be implemented with a List Binding in a Selec
Oracle RAC Monitoring: Keeping your RAC under control
(Tarry Singh) Our last article was about the Extended RAC–a way to spread out our RAC nodes across the city. Whether your RAC is in the building or outside, a smart and prudent DBA always monitors RAC.
Check for leap years in your VB.NET code with IsLeapYear
(Irina Medvinskaya) When dealing with dates in VB.NET, it’s a good idea not to perform manual checks or calculations, which may be inaccurate depending on the quality of the code. Instead, it’s advisable to rely on the functionality of classes provided by .NET.
Implement Sorting in Reports using Report Viewer
(Mahesh Chand) This article shows how to implement sorting on columns in a report using Report Viewer.
SQL Server 2005 Transactional Replication: Benefit of using SubscriptionStreams for low bandwidth, high latency environments
(Bren Newman) When using Microsoft SQL Server 2005 Transactional Replication, the Log Reader Agent reads the log, constructs SQL statements for published articles and posts it to the Distribution database; the Distribution Agent reads the Distribution database, delivers and applies the “package” to
Asynchronous Device Operations
(Jeffrey Richter) In my last column, I demonstrated how to implement two base classes, AsyncResultNoResult and AsyncResult. Both of these classes implement the IAsyncResult interface, which is at the core of the common language runtime (CLR) Asynchronous Programming Model (APM). In this col
Write better distributed queries for Informix data servers
(Evan C. Lee) Learn how to optimize your queries for the best possible performance when accessing multiple Informix servers. In this article, you’ll learn to read the optimizer’s Explain output and understand how Informix processes distributed queries. You’ll learn to recognize inefficiencies in a q