(Lizet Pena de Sola) The data-loss scenario I described in the DevX article SQL Server 2005 Bug Alert: Merge Replication Could Mean Data Loss (published November 2, 2007) is mainly due to the difference in SQL Server 2005’s replication behavior when a publication database uses partition groups versu
Other News
Moving data in and out of the partitions in SQL Server 2005
A few days back, we had written an introductory post on table data partitioning in SQL Server 2005. You can read more on that post here. In this post, we will look at the SWITCH operator and see how the data can be moved in and out of the partitions. This will become useful in designing archival sol
Oracle BI EE 10.1.3.3/2 – Achieving Financial Template Layouts using Pivot Tables
(Venkatakrishnan J) I had a couple of emails referring to a particular new features guide here. It has been said in this new features guide that one can achieve highly formatted financial layouts and also an example is given in the form of screenshots. A couple of users wanted to know how to go abou
Recover database
(Bas Klaassen) Monday evening I was told a company needed some help recovering an important database.
SharePoint, SQL on Call Show and More
New SQL on Call Show Posted [Watch Now] Your Questions – the show today is all about answering viewer questions about SQL Server! Interview questions, what are the top 10 SQL Server tasks, working with management and more. Editor’s note: Sorry about the incorrect link to the show yesterday. Featured Article(s) Introducing Windows SharePoint Services Microsoft Windows SharePoint Services presents […]
New SQL on Call Show Posted
New SQL on Call Show Posted [Watch Now] Your Questions – the show today is all about answering viewer questions about SQL Server! Interview questions, what are the top 10 SQL Server tasks, working with management and more. Featured Article(s) Tips for using SQL Server 2005 constraints (Part 1) Here are some helpful tips to performance tune and optimize SQL […]
Rails, REST, and anarchist XML
(Simon St. Laurent) I’m happy to report that Ruby on Rails not only offers a comfortable way to develop web applications, but that a little-noticed feature makes some formerly theoretical open approaches to XML much more immediately practical.
XSLT 2.0 Q&A: Linking elements in different documents
(Jeni Tennison) The first of what will probably become a series of posts where I answer publicly questions that people post me privately (with permission, of course)… How should I model (and store) data for Courses, while being able to pull info about a Course into a particular context (a Semeste
DB2 Autonomic Computing
(Radhesh Kumar) One of the highlights of DB2 Version 9.5 is “Manage your business, not your database”. IBM claims that the DB2 autonomic computing environment is self-configuring, self-healing, self-optimizing and self-protecting. Autonomic computing is not new in Version 9.5. Past several releases
DB2 LUW Performance: Fighting Over Data – LOCKS
(Scott Hayes) Every once in a while I hear a DBA say they are having Lock problems. Since read-only or read-mostly Data Warehouse databases rarely have lock problems, I quickly assume they have an OLTP database. It is my opinion that locks are rarely, if ever, a PROBLEM. Locks are a SYMPTOM of anoth