(Phil Factor) It should be easy to save a VARCHAR or XML variable to a file. When we use the Scripting.FilesystemObject, it is reasonably easy, but there is the bugbear of the fact that the COM interface was never updated to understand Varchar(MAX) or XML variables. Nevertheless, we already have cod
Other News
Automatic table maintenance in DB2, Part 2: Automatic table and index reorganization in DB2 for Linux, UNIX, and Windows
(Ivan Popivanov, Scott Walkty, Angela Yang and Beck Tang) The autonomic capabilities of IBM DB2 for Linux, UNIX, and Windows lighten the load of the DBA and enable you to maximize performance. This article demonstrates how to enable and configure automatic reorganization, monitor automatic reorganiz
Open-source Technologies for Oracle DBAs and Developers
(Sean Hull) As a DBA, you have lots of software, scripts, and applications, which help you with your day-to-day operations. Some you’ve written yourself, and some may be commercial solutions providing a lot of feature rich assistance to you.
SQL Server password management: Six risky assumptions
(Kevin Beaver) When managing internal SQL Server accounts and passwords, it’s easy to assume that everything is reasonably secure. After all, your SQL Server systems are behind the firewall, you’re forcing Windows authentication and all users are required to have a strong password. Sounds pretty sec
sys.dm_db_partition_stats
(Louis Davidson) For the current database, gives you space oriented statistics for each partition of indexes (even if you only have one partion), like row count, page counts, etc. Resembles the sysindexes in previous versions of SQL Server, with more information.
ADF Faces – Nested Columns
(Lucas Jellema) Recently I ran into a requirement on an ADF project to present columns in an ADF Faces table component in a clustered (nested) fashion. Out of 12 columns, one group of three columns and another group of four columns formed clusters – columns that together had something in common. And
Using partitioning to colocate data for optimal multiple index access paths
(Jeff Moss) I came across a situation the other day where a client was accessing rows from a table via one of several different indexes and getting poor performance on all of them.
3 Tips for Customizing MySQL Enterprise to Achieve Monitoring Best Practices
(Rob Young) During my years as a Developer/DBA hearing the words “customizable” or “extensible” always brought a slight smile to my face, particularly when they were used in conjunction with a software sales pitch or evaluation. In fact, more often than not, while presented as product features, thes
What Would You Ask Other SQL Server Pros?
Last Day to Catch Last Week’s Show > SelectViews: SQL Server Show: Getting Started with Reporting Services Power-Up Your SQL Server by Up To 500% By using some excellent technology to drive your SQL Server better, moving the TempDB file onto a RamDisk and running optimization software. At a fraction of the cost of new servers and peripherals, you can […]
Get to Know Your Data
Featured Article(s) Tips for using SQL Server 2005 Snapshot Replication (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 Snapshot Replication. Watch Now: Using SQL Agent to Automate Tasks with SQL Server Find out how to use the SQL Server Agent to run jobs automatically on your system. From maintenance to pulling information to […]