SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tags Indexing, T-SQL Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 7, 2000 (6)     DTS (2)     User-Defined functions (2)     OpenXML (1)    
Miscellaneous (5)     Installation (2)     XML (2)     Programming (1)    
Administering (4)     Performance Tuning and Scaling (2)     Distributed Queries (1)     Replication (1)    
Configuring (4)     Security (2)     DM_DB_Index_Physical_Stats (1)     SQL Server 2005 (1)    
Performance Tuning (4)     Stored Procedures (2)     English Query (1)     UpdateGrams (1)    
Backup and Recovery (3)     Strategies (2)     Monitoring (1)     XSL (1)    
Basic Querying (2)     Triggers (2)    
   Items 1 to 9 of 9   
 

XML Index

Checking XML indexs with a sample.  Read more...
By Abhijit . 2008/09/19 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 6 reads

Index Fragmentation

This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.  Read more...
By Sergio Govoni 2008/07/09 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: |  Discuss |  Briefcase | 902 reads

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first posted: 2002/04/11) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 29,093 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: (not yet rated) |  Discuss |  Briefcase | 17,207 reads

Cluster That Index!

Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.   Read more...
By Christoffer Hedgate 2003/03/30 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 14,008 reads

Analyzing and Optimizing T-SQL Query Performance on SQL Server

This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexes  Read more...
By Additional Articles 2003/03/14 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 710 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: Installation
Rating: (not yet rated) |  Discuss |  Briefcase | 6,273 reads

SQL Maintenance Plans - Under the Covers!

In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!   Read more...
By Andy Warren 2002/05/21 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 7,723 reads

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first posted: 2002/04/11) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 29,093 reads
   Items 1 to 9 of 9