(Parvesh Garg) This is always mentioned that InnoDB is slower in giving results for COUNT(*) as compared to MyISAM. But as Peter points out in his blog that this fact only applies to COUNT(*) queries without WHERE clause. This text is from Peter’s blog only – “If you have query like SELECT COUNT(*)
Other News
SQL Server Upgrade Plans, Day 30 as DBA Webcast Today
Webcast Today – register now Day 30 as DBA This follow-on to the Day 1 as DBA show will go into the things you can do now that you’re semi-established in your routines. Daily maintenance, auditing, security checks, best practices and more. There is a lot to consider and think about when you’re putting a good foundation in place for […]
U.N. Site Hacked with SQL Server Injection…
Webcast Tomorrow – Register Now Day 30 as DBA This follow-on to the Day 1 as DBA show will go into the things you can do now that you’re semi-established in your routines. Daily maintenance, auditing, security checks, best practices and more. There is a lot to consider and think about when you’re putting a good foundation in place for […]
Moving from VBA to Open XML Part I of V
(Mick Lohan) First of all I have to be straight and OUT myself as a dyed in the wool VB6 developer. Using VB6 , SQL 2000 and Office 2003 [VBA] as basic ingredients – I was able to produce a 15000 line program that interpreted pure XML files and reacted according to their contents. Word produces all
Enterprise Faxing as Easy as XML
(Steve Adams) Back in the 1980s, faxes became the technology of choice for conducting business in what we all thought then was a fast-paced world. (Little did we know!) No longer did we have to wait days for the U.S. Postal Service to deliver purchase orders from our customers or invoices to them. S
Altering LONG VARCHAR [DB2 9 for z/OS]
(Craig Mullins) Just a short entry today to discuss a feature that will be useful for organizations having tables containing long text strings which are stored as VARCHARs. It involves altering the data type of a column from LONG VARCHAR to a compatible data type.
Finally! Bring native XML data into your relational database using DB2 Express-C
(Eric Long) Learn how to use the new features of DB2 Express-C to store, query, and manipulate native XML documents using SQL/XML and XQuery. Previously, XML documents had to be “shredded,” or turned into a CLOB/BLOB/LOB (large object), to be stored in a relational database. This tutorial explains h
XForms extensions to XPath
(Elliotte Rusty Harold) XForms uses XML Path Language (XPath) as its basic function and evaluation language. This is the same XPath used in Extensible Stylesheet Language Transformations (XSLT). In addition to familiar functions like count and substring, XForms introduces a number of useful extensio
New ROLLFORWARD option
(Chris Eaton) Some of the new features in DB2 Viper 2 will probably never get much press attention or even be in a presentation at a conference because they are pretty small. But they can sure help make your life easier. This is one example of such a feature.
Practice using Oracle’s Remote Diagnostic Agent before you need it
(Bob Watkins) Although the DBA can resolve most problems that arise with Oracle databases, there are times when you need to file a Service Request (SR) with Oracle Support. (The old term Technical Assistance Request, or TAR, is still used by many DBAs to refer to SRs). Once an engineer has been assi