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

Content with tag Basics Rss

   Items 1 to 20 of 65    Older >>
 

Developing with SQL Server – What must a beginner know?

Lowering the bar for entry does not mean lowering the bar for quality. New to SQL Server? Find out where to start.  Read more...
By Gary Varga 2014/06/03 | Source: SQLServerCentral.com | Category: learning
Rating: (not yet rated) |  Discuss |   Briefcase | 325 reads

SQL Server Indexed Views: The Basics

Views are a valuable tool for the SQL Server Developer, because they hide complexity and allow for a readable style of SQL expression. They aren't there for reasons of performance, and so indexed views are designed to remedy this shortcoming. They're great in certain circumstances but they represent a trade-off, and they come with considerable 'small print'. Jes Borland explains.  Read more...
By Additional Articles 2014/02/26 | Source: SimpleTalk | Category: indexed views
Rating: (not yet rated)  Rate this |   Briefcase | 3,548 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,876 reads

Views and Horizontal Partitioning

Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.   Read more...
By Jambu Krishnamurthy 2007/04/12 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 9,836 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,167 reads

ASP.NET 2.0: Retrieving XML Data with XmlDataSource Control

This article shows how to retrieve both remote and local XML data and display it in a data Web control.  Read more...
By Additional Articles 2007/09/10 | Source: 4 Guys From Rolla | Category: basics
Rating:  Rate this |   Briefcase | 3,308 reads

XML Workshop V - Reading Values from XML Columns

Continuing on with his series on XML in SQL Server 2005, Jacob Sebastian brings us more examples on how to delve into the values of XML data.   Read more...
By Jacob Sebastian 2007/08/22 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 9,397 reads

A Relational Model of Data for Large Shared Data Banks

The classic paper from Dr. Codd.  Read more...
By Additional Articles 2007/06/25 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 3,137 reads

Views and Horizontal Partitioning

Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.   Read more...
By Jambu Krishnamurthy 2007/04/12 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 9,836 reads

Retrieving Data as XML from SQL Server

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.  Read more...
By Additional Articles 2007/02/23 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 3,316 reads

Some Usages for XML

While SQL Server 2005 has greatly expanded the XML capabilities of the platform, many DBAs are still not familiar with or comfortable with using XML in their coding. Yousef Ekhtiari brings us a new article that looks at a basic use of XML in inserting data into a table.   Read more...
By Yousef Ekhtiari 2007/02/22 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 7,203 reads

Techniques for Uniquely Identifying Database Records

When designing and creating a data model for a data-driven application, the records in tables must each be uniquely identifiable. By having a unique value associated with each record, individual records can be selected, updated, or deleted. Being able to uniquely identify records is so important and standard in a database system that databases allow those designing a database table to specify what column (or columns) make up the primary key.  Read more...
By Additional Articles 2006/12/22 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 2,888 reads

Our Very Own SQL Server Data Compression

Data space can be a concern in many situations as more and more data is being stored in your systems. Designing your schema to take this into account is important for a DBA and Steve Jones takes a look at how design decisions can be used to solve a business problem.   Read more...
By Steve Jones 2006/11/23 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 5,652 reads

Designing relational tables with subtypes

Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables.  Read more...
By Additional Articles 2006/11/13 | Source: Builder.com | Category: basics
Rating:  Rate this |   Briefcase | 3,485 reads

SQL Server 2005 – DML Usage on an untyped XML column

Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.  Read more...
By Additional Articles 2006/09/18 | Source: Database Journal | Category: basics
Rating:  Rate this |   Briefcase | 1,601 reads

Making Sense of the XML DataType in SQL Server 2005

n SQL Server 2005, XML becomes a first-class data type. Developers can make minor remote modifications to stored XML documents easily, taking advantage of new support for XML schema-based strong typing, and server-based XML data validation.   Read more...
By Additional Articles 2006/07/10 | Source: DevX | Category: basics
Rating:  Rate this |   Briefcase | 2,711 reads

Using XQuery to Manage XML with SQL Server 2005

XML is now becoming more widely used as wireless devices are becoming more secure, and new technologies such as XQuery for SQL Server 2005 are making it much easier to handle XML more efficiently at the server level. Jesse Smith gives you a crash course on XQuery methods and how you can use them in certain situations to retrieve and update XML data stored in your SQL Server 2005 database.  Read more...
By Additional Articles 2006/05/18 | Source: InformIT | Category: basics
Rating:  Rate this |   Briefcase | 2,814 reads

Using XQuery, New Large DataTypes, and More

SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification with XQuery, and the new XML datatype.  Read more...
By Additional Articles 2006/05/08 | Source: MSDN Communities | Category: basics
Rating:  Rate this |   Briefcase | 2,331 reads

Constructing XML Using FOR XML

A SELECT query returns results as a rowset. You can optionally retrieve formal results of a SQL query as XML by specifying the FOR XML clause in the query.  Read more...
By Additional Articles 2006/04/19 | Source: MSDN Communities | Category: basics
Rating:  Rate this |   Briefcase | 2,929 reads

A surrogate key architecture to perform powerful database operations

The alternative to surrogate keys is natural data keys. In order to understand the many substantial benefits of surrogate keys it's necessary to discuss some background on the issues involved.  Read more...
By Additional Articles 2006/01/10 | Source: Other | Category: basics
Rating:  Rate this |   Briefcase | 4,008 reads
   Items 1 to 20 of 65    Older >>
 
Tags
database design (29)    
xml (28)    
sql server 7 (12)    
t-sql (10)    
miscellaneous (9)    
programming (9)    
administration (4)    
ado (4)    
performance tuning (4)    
visual basic 6 (4)    
news (3)    
openxml (3)    
strategies (3)    
updategrams (3)    
asp (2)    
configuring (2)    
indexing (2)    
naming standards (2)    
reviews (2)    
advanced (1)    
advanced querying (1)    
beginner (1)    
book reviews (1)    
data types (1)    
data warehousing (1)    
design and theory (1)    
editorial (1)    
indexed views (1)    
installation (1)    
learning (1)    
monitoring (1)    
other (1)    
product reviews (1)    
rants (1)    
schemas/dtds (1)    
sql server 6.5 (1)    
stored procedures (1)    
system development life cycle (1)    
xsl (1)