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

Articles with tag basics Rss

Search for any content tagged basics

<< Newer    Items 21 to 40 of 64    Older >>
 

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,859 reads

Introduction to XQuery in SQL Server 2005

This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features. Non-supported features of XQuery in SQL Server 2005 and workarounds are described in this article. It also presents three scenarios where XQuery is useful.   Read more...
By Additional Articles 2005/06/23 | Source: MSDN Communities | Category: basics
Rating:  Rate this |   Briefcase | 2,532 reads

XML Simplified

Everyone should be aware that XML is supported in SQL Server 2000 and plays an integral part of not only SQL Server 2005, but all of the Windows family. IIS metadata, web services, etc. all involve XML. But do you know what XML is and how to work with it? Author Raj Vasant brings us a basic article on what XML is and how the documents are structured.   Read more...
By Vasant Raj 2005/05/23 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 12,976 reads

XML IN 20 MINUTES!

This article will quickly dive head first right into XML.   Read more...
By Leon Platt 2008/01/04 (first published: 2003/09/26) | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 184,142 reads

SQL Building Blocks and Server Settings

This chapter covers the building blocks available to the database designer and database user to create and modify database objects and data. The SQL Data Types will be covered along with data representation as literals (constants) and expressions.  Read more...
By Additional Articles 2005/03/09 | Source: It Toolbox | Category: basics
Rating:  Rate this |   Briefcase | 2,881 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,684 reads

Setting Matters Straight

Fabian Pascal, famed database author and writer takes his shots at a recent thread on another SQL site. He makes some good points about normalization.  Read more...
By Additional Articles 2005/01/20 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 2,713 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,257 reads

A Survey of Microsoft SQL Server 2000 XML Features

An oldy, but good basic look at XML and how it fits into SQL Server 2000.   Read more...
By Additional Articles 2004/09/23 | Source: MSDN Communities | Category: basics
Rating:  Rate this |   Briefcase | 2,862 reads

Handling Simple XML Using T-SQL

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.   Read more...
By Eli Leiba 2004/09/20 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 12,854 reads

Lookup Table Design

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.   Read more...
By Leo Peysakhovich 2004/07/27 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 22,628 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,947 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,859 reads

XML IN 20 MINUTES!

This article will quickly dive head first right into XML.   Read more...
By Leon Platt 2008/01/04 (first published: 2003/09/26) | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 184,142 reads

Saving Space To Increase Performance

Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.   Read more...
By Neil Boyle 2003/02/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,868 reads

A Lookup Strategy Defined

Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.   Read more...
By David Sumlin 2003/02/20 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 12,477 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,112 reads

Beware of Mixing Collations - Part 1

A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.   Read more...
By Gregory Larsen 2002/12/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,012 reads

Designing a Flexible Task Management Database Part II

In this short article by Jamie Voss, he shows you the data model behind much of his task tracking system and the reasoning behind it.   Read more...
By Jamie Voss 2002/10/17 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 4,631 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,868 reads
<< Newer    Items 21 to 40 of 64    Older >>