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

Content with tags XML, Indexing Rss

   Items 1 to 5 of 5   
 

Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012

Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1 introduced selective XML indexes. These transform the practicality of querying large amounts of XML data. Seth Delconte demonstrates how and why this feature makes all the difference.   Read more...
By Additional Articles 2013/02/06 | Source: SimpleTalk | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 1,993 reads

XML index

By Ravi Kumar SV 2012/07/17 | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 2,031 reads

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,238 reads

XML Index

Checking XML indexs with a sample.  Read more...
By abmore 2008/09/19 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,345 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads
   Items 1 to 5 of 5   
 
Tags
t-sql (3)    
administration (1)    
backup / restore (1)    
check constraint (1)    
configuring (1)    
create (1)    
database design (1)    
distributed queries (1)    
dts (1)    
english query (1)    
execute (1)    
foreign keys (fk) (1)    
installation (1)    
miscellaneous (1)    
monitoring (1)    
openxml (1)    
performance tuning (1)    
primary key (pk) (1)    
replication (1)    
security (1)    
sql server 7 (1)    
stored procedures (1)    
table (1)    
triggers (1)    
unique (1)    
updategrams (1)    
user defined function (udf) (1)    
xsl (1)