Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Basics Rss

   Items 1 to 11 of 11   
 

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,794 reads

Reducing Round Trips Part 4

The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!   Read more...
By Andy Warren 2004/04/23 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,948 reads

A Normalization Primer

For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.   Read more...
By Brian Kelley 2003/01/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,134 reads

Querying XML files using SQL 2000

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!   Read more...
By David Poole 2002/10/11 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 11,870 reads

Querying Responses

Binary data can be stored as integers in a table. This article explains how to query an integer field to return the bits represented by the integer.   Read more...
By Bruce Szabo 2002/06/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,421 reads

Storing Checkbox Responses as Integers

This article demonstrates how to store checkbox results as integers in a database...perfect for surveys!   Read more...
By Bruce Szabo 2002/06/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,172 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,794 reads

Reducing Round Trips - Part 2

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!   Read more...
By Andy Warren 2002/02/06 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,234 reads

BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.   Read more...
By Additional Articles 2002/01/28 | Source: Microsoft MSDN | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,277 reads

XML Data Solutions

This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.   Read more...
By Additional Articles 2002/01/18 | Source: Microsoft MSDN | Category: updategrams
Rating:  Rate this |   Briefcase | 2,425 reads

SQLXML 2.0 (XML for SQL Server 2000)

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.   Read more...
By Additional Articles 2001/10/29 | Source: Microsoft MSDN | Category: news
Rating:  Rate this |   Briefcase | 5,934 reads
   Items 1 to 11 of 11   
 
Tags
xml (6)    
database design (5)    
miscellaneous (5)    
openxml (3)    
programming (3)    
sql server 7 (3)    
updategrams (3)    
visual basic 6 (3)    
ado (2)    
performance tuning (2)    
administration (1)    
advanced querying (1)    
configuring (1)    
installation (1)    
news (1)    
schemas/dtds (1)    
stored procedures (1)    
xsl (1)