(Alejandro Gervasio) In this database programming tutorial, you will be using the REPLACE statement and the UNIQUE clause to avoid duplicate records.
Other News
Best practices: Query optimization in a data warehouse
(Gregor Meyer, Detlev Kuntze, Toni Bollinger and Sascha Laudien) In large data warehouse systems, it is critical to optimize query workloads to maximize system utilization and minimize processing times. This article describes techniques for the optimization of data warehouse query workloads.
LINQ Is It the New SQL?
LINQ – Is It the New SQL? I have been using LINQ for Objects a lot recently. It allows me to leverage my set based skills when processing Dot Net IEnumerable objects. This seems to be something I have to do a lot lately. About the same time, I started looking at NHibernate again. I find it interesting that LINQ […]
Developer Skills Reader Comments
Developer Skills Reader Comments Time to close out this topic with a few more comments from our readers. Writing about this topic, and reading the comments from many readers has confirmed to me that it is not just a specific toolset that makes you valuable. It is more important how you use the tools you have. Seek those tools that […]
XML Schema vs. DTD
XML means Extensible markup language. The XML 1.0 specification developed by W3C (World Wide Web Consortium), gives its definition, which is developed by the. XML provides a simple and standard way which encodes data as text content can be exchanged through the hardware drivers, operating systems an
Reactive Extensions: Just What the Doctor Ordered (Part 3)
(Eric Vogel) In Part 1 of the series I went over the basics of Reactive Extensions (Rx). In Part 2 I went over how to compose observable sequences and how to observe asynchronous methods. For this final installment we will go over how to put all of the pieces together to create a full reactive appli
Top 10 JavaScript Libraries, Frameworks and Tools for Web Developers
(Jason Gilmore) Despite their names, the Java and JavaScript programming languages share little if anything in common. They have however both experienced rather similar renaissances thanks to the strong open source ecosystems which have grown to surround the languages in recent years.
50 LINQ Examples, Tips and How To’s
(Suprotim Agarwal) I have been writing some LINQ tutorials on www.devcurry.com and most of these posts contain short snippets that can be used in your projects or demonstrate how to use LINQ effectively. I wanted to share them with my readers over here. These short examples demonstrate how to use a
Replacing a damaged Hard Disk on Exadata Cells
(Uwe Hesse) A task that you will most likely encounter during the administration of Exadata is the replacement of a damaged Hard Disk on the storage servers. Fortunately, this is quite easy, because almost everything is done by the system itself.
Bitmap Indexes & Minimize Records_Per_Block (Little Wonder)
(Richard Foote) As mentioned in my first post regarding the use of Bitmap Indexes to service Not Equal predicates, an index entry in a Bitmap Index consists of the indexed value and a pair of rowids that determine the range of potential rows spanned by the corresponding bitmap sequence.