(Simon Sabin) The next post in the series on iFTS (Integrated Full Text Search) covers a thesaurus files. A feature introduced in SQL 2005.
Other News
SQL Server Data Services Announced
New Approach to Backup Acronis has been working hard to address some traditional issues with backup and recovery approaches for SQL Server. While it’s possible to do the whole database and transaction log dump and restore cycle to recover a system, Acronis has gone a step farther. They’ve created tools that help you recover to the point of failure – […]
SQL Server 2008 Launch Event
Featured Article(s) Troubleshooting Linked Servers in SQL Server 2005 In this article, Alexander Chigrik explains some problems with SQL Server 2005 linked servers. He also tells how you can resolve these problems. Importing Data? Cool Blog Posting Our friends at DataDefractor have a blog that talks about all sorts of tips for importing and massaging data for your system. I’ve […]
SQL Tips & Techniques- String Aggregation(Contd.)
(Radhesh Kumar) In my last post, I showed two ways to perform string aggregation. Both of them used recursive SQL. I also mentioned that a built-in function to perform string aggregation would be preferred. Though, I have not found a direct function for string aggregation, one of the comments on my
Cooking XML with OOP
(Hasin Hayder) XML (Extensible Markup Language) is a very important format for storing multi‑purpose data. It is also known as universal data format, as you can represent anything and visualize the data properly with the help of a renderer. One of the biggest advantages of XML is that it can b
Displaying XML in a Swing JTree
(Rob Lybarger) It seems obvious enough: You have an XML document or fragment. XML is hierarchical. A Swing JTree displays hierarchical data. How do you make a JTree display your XML fragment?
APAR Friday: This time the post is actually on Friday
(Willie Favero) I’m late on Friday, but at least it’s still Friday. I just arrived home from SHARE a few hours ago and it took until now to sort things out enough so I could post this today. BTW, I thought it’s supposed to warm in Florida? Orlando was freezing the last few days.
Fixing That Annoying MinValue Problem
(Jim Mischel) Special cases make code fragile, and the special case handling of Int128.MinValue in the ToString is also annoying. But with the current infrastructure, it’s the best solution I had.
First Look at Using Expression Blend with Silverlight 2
(Scott Guthrie) Last week I did a First Look at Silverlight 2 post that talked about the upcoming Silverlight 2 Beta1 release. In the post I linked to some end-to-end tutorials I’ve written that walk through some of the fundamental programming concepts behind Silverlight and WPF, and demonstrate ho
EXPLAIN PLAN, V$SQL_PLAN and DBMS_XPLAN
In some of our previous posts, we have talked about DBMS_XPLAN package in Oracle and have demonstrated it’s usage. One of the recent questions from our readers was: “What is the difference between using “EXPLAIN PLAN command” vs using the dictionary view: V$SQL_PLAN? And can you elaborate a bit on t