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

Content with tags Miscellaneous, Basics Rss

   Items 1 to 13 of 13   
 

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,916 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,916 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,798 reads

Methods for Parsing XML files

Jon shows you several ways you can parse XML.   Read more...
By Jon Winer 2004/10/01 (first published: 2002/06/20) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,278 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,949 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,916 reads

Methods for Parsing XML files

Jon shows you several ways you can parse XML.   Read more...
By Jon Winer 2004/10/01 (first published: 2002/06/20) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,278 reads

Review of Debugging the Development Process

Andy read this book recently and gave it a great review. Even though it's not a SQL book! Seriously, take a look at the review. It's a good book that is fun to read.   Read more...
By Andy Warren 2002/02/26 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 3,254 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,798 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,235 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,292 reads

Simple OLE DB Provider for XML

The OLE DB Simple provider for XML (XML OSP) can be used to load the hierarchical data that is in an XML document into a read-only ADO recordset. The data can then be read and accessed by using the standard methods of the ADO Recordset object. The XML OSP can be used to provide a different method for working with data that is contained in XML documents.   Read more...
By Additional Articles 2001/12/10 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,180 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,960 reads
   Items 1 to 13 of 13   
 
Tags
xml (6)    
t-sql (5)    
database design (4)    
programming (4)    
sql server 7 (4)    
openxml (2)    
performance tuning (2)    
updategrams (2)    
visual basic 6 (2)    
administration (1)    
ado (1)    
advanced (1)    
book reviews (1)    
configuring (1)    
indexing (1)    
installation (1)    
news (1)    
reviews (1)    
schemas/dtds (1)    
stored procedures (1)    
xsl (1)