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

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

Discuss

Dealing With Upper and Lower Case Data

by Additional Articles

Database Journal

Advanced Querying

Gregory Larsen demonstrates several examples of how to deal with different situations related to the case of character strings.

2007-02-16

2,757 reads

Discuss

Logical Functions: IsAncestor(): Conditional Logic within Calculations

by Additional Articles

Database Journal

Use IsAncestor() to support conditional logic within calculations. BI Architect Bill Pearson introduces IsAncestor(), and then leads a hands-on practice session with this valuable MDX function.

2007-02-15

2,480 reads

Discuss

All authors

Additional Articles

Database Design: A Point in Time Architecture

Using BACKUP and RESTORE in SQL Server

Using Plan Guides in SQL Server 2005

Retrieving Data as XML from SQL Server

Turn XML into relational data with OPENXML

SQL Server XML Performance Tips

Shred XML data with XQuery in SQL Server 2005

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

Dealing With Upper and Lower Case Data

Logical Functions: IsAncestor(): Conditional Logic within Calculations

Blogs

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

Adding a Local Model to Ollama through the GUI

Connect resiliently to SQL Server

Forums

Some query values change when query is run but not others. Why?

using different credentials when debugging ssis

AlwaysON health check alerts

Question of the Day

PWDCompare