(Buck Woody) More than almost any other component in your SQL Server computer, sizing, configuring and tuning memory use has the highest impact on capabilities and performance. Most database applications are not computationally intense, meaning that the database doesn’t have to do a lot of mathemati
Other News
Secure ASP.NET AJAX Development (Part 2)
(Jason Schmitt) One of the more difficult aspects of implementing AJAX applications is the tremendous amount of JavaScript programming that is usually required. If you refer back to the basic XMLHttpRequest example in Section 1, you see that AJAX in its most basic form is pure JavaScript programmi
Oracle upgrades require careful planning
(Mark Brunelli) One of the biggest challenges facing Oracle technology professionals today is dealing with upgrades, and as companies gear up for the next major upgrade cycle, IT industry experts and Oracle customers say there are some best practices to remember that can ease upgrade pains. (R)
System Administration Certification exam 918 for IBM Informix Dynamic Server 11 prep, Part 6: System activity monitoring
(Deen Murad) Part 6 in a series of eight tutorials to help you prepare for the IDS 11 exam 918 explores IBM Informix Dynamic Server (IDS) database backup and restore concepts and strategies. It also discusses utilities and commands for managing your database backup and restore processes. (R)
You receive an error message when you try to attach a SQL Server 2005 database in SQL Server 2000
When you try to attach a Microsoft SQL Server 2005 database in SQL Server 2000, you receive the following error message: Server: Msg 602, Level 21, State 50, Line 1 Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
IBM Optimization Service Center vs. SAP DB2 CCMS
(Omer Brandis) In this post I’ll review the new performance monitoring tool from IBM called “Optimization Service Center for DB2 on z/os”. I’ll also try to compare it to SAP’s performance monitoring tool (the CCMS for DB2 on Z/OS). I do hope that this will help both development teams to further impr
How Useful Are Those Indexes
(Gregory A. Larsen) Having indexes on your tables provides a method to improve performance of your T-SQL queries. However, indexes also increase the amount of work SQL Server needs to perform when inserting, updating, or deleting rows. As time passes, index performance can slow down as indexes becom
Upgrading to SQL Server 2005: Six migration tips
(Serdar Yegulalp) Upgrading to a new version of SQL Server isn’t like patching a desktop application or even moving to a new version of Microsoft Office. It has broad-reaching consequences and can affect the behavior of other applications that talk to SQL Server: data-driven Web sites, reporting too
MySQL Slow query log in the table
(Peter Zaitsev) As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions.
Less is More, More or Less
(John) Do you fret every time you declare a PL/SQL variable, that you’ve carelessly allocated a few unnecessary bytes, and that this wastage will be replicated thousands of times as your code is called from a bazillion sessions, and that that will be the straw that breaks the camel’s back and makes