(Baya Pavliashvili) Appropriate indexes can make a world of difference in performance. SQL Server supports only two index types for most data types — clustered and non-clustered. SQL Server also supports full-text indexes and XML indexes, but those are relevant only for specific data types. (R)
Other News
DB2 DBA: News from the Client Side
(Robert Catterall) A few years ago, my friend Cathy visited my home in suburban Atlanta, Ga. I introduced her to my son, who was four years old at the time, and told him that Cathy had a farm in Pennsylvania. “Really?” asked Zachary. “Do you have horses?” “Yes,” said Cathy, “we have horses.”
What Is Your SQL Server Day All About?
Featured Article(s) Understanding the SDLC phases of a Software Project [Part II] In the earlier part in this series we have had a look at the basics related to this topic and a few phases of SDLC. In this part we will discuss some other phases of SDLC in the sections that follow. RSS To Get SQL Server Results? Yes. […]
Using XMLSocket for Server Push in Flex
(Jason Weiss) Adobe’s LifeCycle Data Services ES offers developers powerful capabilities. Some of this software’s capabilities, specifically server push, can be developed with relative ease using a utility class that has been around in the Flash APIs for a great while, and without having to pay lice
Product Review: HyperBac for Oracle
(Jim Czuprynski) Oracle 10g Release 2 (10gR2) offers significant enhancements to database backup and recovery with Recovery Manager (RMAN), including the ability to compress backup sets and encrypt backups for increased security. A relatively new product called HyperBac provides an excellent alterna
MySQL Proxy: more R/W splitting
(Jan Kneschke) In http://jan.kneschke.de/2007/8/1/mysql-proxy-learns-r-w-splitting we did a first implementation on idea of sending non-transactional reads to the slaves and writes and transactions to the master.
High performance inserts using JDBC Type 4 in a constrained environment
(Bob Calio and Izzy Bendrihem) Learn how to handle mass inserts of data using Java and IBM DB2 Universal Driver Type 4 connection only, an efficient alternative for situations where the application code does not have access to a DB2 client, or where the use of import/load utilities do not apply. The
Let users pick a file to open via OpenFileDialog in VB.NET
(Irina Medvinskaya) Whenever you need to allow a user to open a particular file without forcing the user to type the full path and file name, you can use the OpenFileDialog class. OpenFileDialog has a number of properties and methods that make it a flexible way to get users to pick a file. In this t
Performance Impact: Finding the Most Optimal Batch Size
(Linchi Shea) In my previous posts (1, 2, 3), I focused on the performance behavior of setting the checkpoints and transaction commit sizes to once every 16 inserts and once every 100,000 inserts. A question remains: what is the most optimal size?
Template Messages Using XSL Transformations and XML Serialization
(Cvetomir Todorov) This article is going to explain how to write templated messages. This, for instance, can be an email. The solution is very general and is applicable in any situation in which you convert your .NET object serialized in XML to plain text, HTML and other XML, too. This article is no