Basics

Handling Simple XML Using T-SQL

  • Article

SQL Server 2000 integrates a number of features to work with XML data and SQL Server 2005 should expand upon that. However the SQL Server 2000 extensions for working with XML data in T-SQL are not that mature. New author Eli Leiba looks at how he can traverse an XML file using T-SQL code.

5 (1)

2004-09-20

12,913 reads

Lookup Table Design

  • Article

Designing a SQL Server database is a challenging task. Making decisions about how to build tables, their relations, etc. can be a full time job for any DBA helping to build an application. Lookup tables are a part of just about every application that you work with or build a back end for. Leo Peysakhovich brings us an article on database design that deals specifically with lookup tables.

3 (4)

2004-07-27

23,799 reads

Designing a Database with Microsoft Visio 2000

  • Article

An extremely useful tool to reverse engineer a database is Visio 2000. It also has the ability to generate a database. This generation takes place after Visio has been used to draw the tables and relationships. This process can be a huge time saver. If a database needs to be tweaked and reworked it can be done in Visio and then regenerated. This article is intended to provide a nice introduction to using Visio 2000 to generate a database.

2002-07-22

8,984 reads

Blogs

Who needs data access? Not You!

By

With a little planning and care, we can find various ways to fulfill user...

Azure Synapse Analytics & Power BI performance

By

With two new relational database features (Result-set caching and Materialized Views) just GA’d in...

Session Evaluations from “SQL Server Security from the Ground Up”

By

I was recently given the opportunity to speak at Pass Summit. As always (this...

Read the latest Blogs

Forums

Session timeout vs Execution timeout difference

By sqlfriend

I am using report service 2017.  Trying to figure out how to set the...

Moving a Default Schema

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving a Default Schema

Using the Lightweight Tools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using the Lightweight Tools, which...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers