(Hazan Ilan) In a case that you copy (INSERT INTO .. SELECT ..) a MyISAM table that have a PRIMARY key, it is much faster to insert the new rows in the primary key order:
Other News
XML Alphabetizer
(PurpleD423) This project will allow the user to alphabetize any XML file without having to translate that file using XSLT or modify it in any way other than ordering nodes based on the names of the nodes themselves or based on an attribute of any node.
SQL SERVER – 2000 – DBCC SQLPERF(waitstats) – Wait Type – Day 24 of 28
(Pinal Dave) I have received many comments, email, suggestions and motivations for my current series of wait types and wait statistics. One of the questions which I keep on receiving almost every other day is whether all of the discussions I have presented so far are also applicable to SQL Server 20
OWB 11gR2 – OMB and File Editing
(David Allan) Here we will see how we can use the IDE for editing OMB scripts. The 11gR2 release is based on the common Oracle platform IDE used also by JDeveloper. It comes with a bunch of standard behavior for editing and rendering code.
Save $100 and refresh your skills with Assess and Save
(Kate Dawson) You asked for it, and now it’s here again! The Assess and Save offer is back!
ColdFusion Application-Specific Mappings Work With CFInclude
(Ben Nadel) Ok, so I know this post is like 3 years too late; but, the other day, I got to thinking about the application-specific mappings introduced in ColdFusion 8 and I wondered if I had ever used them for CFInclude. I know that I use them for createObject() all the time; but, I don’t think I ha
MySQL Data Fragmentation – What, When and How
(Sean Hull) MySQL tables, including MyISAM and InnoDB, two of the most common types, experience fragmentation as data is inserted and deleted randomly. Fragmentation can leave large holes in your table, blocks which must be read when scanning the table. Optimizing your table can therefore make full
Handling Duplicate @XmlRootElement Declarations
(Blaise Doughan) The following post was inspired by an answer I gave to a question on Stack Overflow (feel free to up vote). The problem arose from a JAXBContext being created on classes derived from two schemas that both use the same root element. The solution is to supply type of object to the u
Different SQL Server Management Studio Startup Options
(Ashish Kumar Mehta) One of the developers asked me if there was a way to open Object Explorer and a New Query Window at the same time whenever he opens SQL Server Management Studio. In this tip we will take a look at different SQL Server Management Studio startup options which can benefit you in yo
New Terms for Web-Scale Persistence
New SelecTViews – Not your ordinary web show, Watson! You may have seen him on Jeopardy! – Stephen Baker joins us on the show today talking about what was learned with the project. Stephen Baker wrote the book (literally) on the Watson project and all that it entailed – do not miss this show… [Watch the show here, free] New […]