Additional Articles

Database Design: A Point in Time Architecture

by Additional Articles

SimpleTalk

Advanced

In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller presents a solution to this requirement in the form of a Point-in-Time architecture: a database design which allows a user to recreate an image of the database as it existed at any previous point in time, without destroying the current image.

2007-02-28

3,723 reads

Discuss

Last day of the month

by Additional Articles

SQLServerCentral

Miscellaneous

Get the last date of the month for the given date. Algorithm is:1. Transform given date in “first day of the month” 2. Add a month to result 3. Subtract a day from second result

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-02-27 (first published: 2004-09-30)

231 reads

Discuss

Using BACKUP and RESTORE in SQL Server

by Additional Articles

SQLTeam.com

Administration

This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.

2007-02-27

5,180 reads

Discuss

Using Plan Guides in SQL Server 2005

by Additional Articles

SQL Server Performance

Performance Tuning

In SQL Server 2005, there is a new feature called Plan Guides that can help out in some cases where you discover poorly performing queries that you don't have direct control over. Essentially, a Plan Guide allows you to add or modify query hints to queries on the fly, just before they are executed.

2007-02-26

2,178 reads

Discuss

Retrieving Data as XML from SQL Server

by Additional Articles

Other

Basics

All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically-structured format.

2007-02-23

3,672 reads

Discuss

Turn XML into relational data with OPENXML

by Additional Articles

Builder.com

OpenXML

XML support has been significantly extended for SQL Server 2005. In this article, Tim Chapman takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function.

2007-02-22

4,779 reads

Discuss

SQL Server XML Performance Tips

by Additional Articles

SQL Server Performance

Performance Tuning

A series of tips on optimizing XML in your SQL Server databases.

2007-02-21

3,644 reads

Discuss

Shred XML data with XQuery in SQL Server 2005

by Additional Articles

Builder.com

OpenXML

Tim Chapman discusses new functionality in SQL Server 2005 that allows you to shred XML data into a relational format without the intensive memory operations. He also explains how using XQuery rather than OPENQUERY can lead to performance gains.

2007-02-20

3,813 reads

Discuss

SQL Server 2005 Integration Services - Part 42 - XML Task continued

by Additional Articles

Database Journal

Integration Services (SSIS)

Marcin Policht continues his discussion of various types of actions that can be performed using XML Control Flow task, focusing this month on the operation type called XPATH.

2007-02-19

2,476 reads