﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Content tagged Indexing</title><link>http://www.sqlservercentral.com/</link><description>Content tagged Indexing posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>SQL Server Column Considerations and Column Placement</title><description><![CDATA[Determining which columns to select for your indexes is critical. Having a little knowledge of how your application is using your database columns and how SQL Server processes indexes helps you make good decisions when you create your indexes.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69812/</guid><pubDate>2010/03/12</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69812/</link></item><item><title>Clustered Index Analyser</title><description><![CDATA[Analysing clustered indexes on user tables by looking at the columns that comprise them<!-- Too many SQL Servers to keep up with? -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Response/offers/too_many_servers.htm?utm_source=ssc&utm_medium=rss&utm_content=toomany200912&utm_campaign=sqlresponse"><img alt="SQL Response" height="68" src="http://www.red-gate.com/images/marketing/SSC/response_ico.gif" width="68" border="0"/></a></td>
  <td><strong>Too many SQL Servers to keep up with?</strong><br /><a href="http://www.red-gate.com/products/SQL_Response/offers/too_many_servers.htm?utm_source=ssc&utm_medium=rss&utm_content=toomany200912&utm_campaign=sqlresponse">Download a free trial</a> of SQL Response to monitor your <br>SQL Servers in just one intuitive interface."The monitoring<br>in SQL Response is excellent." Mike Towery. </a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/Indexing/69669/</guid><pubDate>2010/03/11</pubDate><link>http://www.sqlservercentral.com/scripts/Indexing/69669/</link></item><item><title>Primary Keys</title><description><![CDATA[]]></description><guid>http://www.sqlservercentral.com/questions/Indexing/69474/</guid><pubDate>2010/03/10</pubDate><link>http://www.sqlservercentral.com/questions/Indexing/69474/</link></item><item><title>Index Seeks, Scans, and Lookups</title><description><![CDATA[This script may help identify tables impacted by frequently-occurring scans.<!-- Free trial of SQL Backup™ -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup"><img alt="SQL Backup" height="68" src="http://www.red-gate.com/images/sql_server_central/backup3d_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>Free trial of SQL Backup™</strong><br />“SQL Backup was able to cut down my backup time <br>significantly AND achieved a 90% compression at <br>the same time!” Joe Cheng. <a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup">Download a free trial now.</a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/scripts/Indexing/69526/</guid><pubDate>2010/03/01</pubDate><link>http://www.sqlservercentral.com/scripts/Indexing/69526/</link></item><item><title>PASS AppDev Presents: SQL Server Indexing</title><description><![CDATA[While indexing traditionally has been the concern of the DBA, it's important for developers to understand both the usefulness and the impact of indexes in your relational database.  With the right indexes your application will perform like a Formula One racer, without them performance will better resemble a Model T.  This presentation will explain how indexes work, what options are available to you in SQL Server 2008, and how to tune your application and your database for the best performance.By Allen White,  2/9/2010, 1:00EST]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69483/</guid><pubDate>2010/02/02</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69483/</link></item><item><title>Database Indexing Development Lifecycle...Say What?</title><description><![CDATA[Creating good indexes on your database doesn't happen by mistake--you need to have a plan. Greg Larsen shows you how, beginning with a discussion on the indexing development lifecycle.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69193/</guid><pubDate>2010/01/15</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69193/</link></item><item><title>Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)</title><description><![CDATA[Even after you have applied proper indexing along with re-factoring your TSQLs with best practices, some data access routines might still be there, which would be expensive, in terms of their execution time. There must have been some smart ways to deal with these. Yes there are. SQL server offers you some rich indexing techniques that you might have not used earlier. These could surprise you with the performance benefits they possibly offer. Let us start implementing those advanced indexing techniques:]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69034/</guid><pubDate>2010/01/08</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69034/</link></item><item><title>Data searches that leverage existing indexes</title><description><![CDATA[Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on data searches, which leverage existing indexes, taking into account such features as noise words and thesaurus files.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69191/</guid><pubDate>2010/01/07</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69191/</link></item><item><title>Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)</title><description><![CDATA[’ll focus on the issues that you need to follow to make sure that you have done everything that you could do to optimize the data access codes you have written or you are going to write in future. The Database Administrators (DBA) also has great roles to play in optimizing and tuning the database performance. But, optimization scopes that fall into a DBA’s area are out of scope for these articles.<!-- SQL Server monitoring made easy -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse"><img alt="SQL Response" height="68" src="http://www.red-gate.com/images/marketing/SSC/response_ico.gif" width="68" border="0"/></a></td>
  <td><strong>SQL Server monitoring made easy </strong><br />"Keeping an eye on our many SQL Server instances<br> is much easier  with SQL Response." Mike Lile.<br><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse">Download a free trial of SQL Response now. </a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69032/</guid><pubDate>2009/12/29</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69032/</link></item><item><title>Full Text Index Management in SQL Server 2005 Express Edition </title><description><![CDATA[Recent installments of our series dedicated to the most important features of SQL Server 2005 Express Edition have focused on its Full Text Indexing capabilities. This article covers other full text indexing management methods.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69025/</guid><pubDate>2009/12/21</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69025/</link></item><item><title>Clustered Index Internals</title><description><![CDATA[]]></description><guid>http://www.sqlservercentral.com/questions/Indexing/68412/</guid><pubDate>2009/12/09</pubDate><link>http://www.sqlservercentral.com/questions/Indexing/68412/</link></item><item><title>Introduction to Indexes: Part 3 – The nonclustered index</title><description><![CDATA[Part 3 of a great series on the basics of indexes. This time MVP Gail Shaw examines the non-clustered index. Learn the structure, definition, and how to examine the use of these indexes in your queries.]]></description><guid>http://www.sqlservercentral.com/articles/Indexing/68636/</guid><pubDate>2009/11/18</pubDate><link>http://www.sqlservercentral.com/articles/Indexing/68636/</link></item><item><title>Introduction to Indexes: Part 2 – The clustered index</title><description><![CDATA[In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.]]></description><guid>http://www.sqlservercentral.com/articles/Indexing/68563/</guid><pubDate>2009/11/11</pubDate><link>http://www.sqlservercentral.com/articles/Indexing/68563/</link></item><item><title>An Un-indexed Foreign Key Gotcha</title><description><![CDATA[Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.]]></description><guid>http://www.sqlservercentral.com/articles/T-SQL/68337/</guid><pubDate>2009/11/09</pubDate><link>http://www.sqlservercentral.com/articles/T-SQL/68337/</link></item><item><title>Introduction to Indexes</title><description><![CDATA[Indexes are critical to good performance. However many people don't understand how indexes well. MVP Gail Shaw provides us with an introductory article on the basics of indexing.]]></description><guid>http://www.sqlservercentral.com/articles/Indexing/68439/</guid><pubDate>2009/10/26</pubDate><link>http://www.sqlservercentral.com/articles/Indexing/68439/</link></item><item><title>Index Management</title><description><![CDATA[This article demonstrates an Index Management strategy to tackle day to day performance issues due to improper indexes.]]></description><guid>http://www.sqlservercentral.com/articles/Indexing/68079/</guid><pubDate>2009/10/20</pubDate><link>http://www.sqlservercentral.com/articles/Indexing/68079/</link></item><item><title>SQL Server 2005 Index Best Practices</title><description><![CDATA[In continuing with our series of tips on Best Practices for SQL Server I'm turning my sights on Maintenance.  Specifically in this tip we will be discussing Index maintenance: when, if, why, and how are questions that will be addressed.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68422/</guid><pubDate>2009/10/09</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68422/</link></item><item><title>Keep Your SQL Server Indexes Fragmentation Free</title><description><![CDATA[Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68170/</guid><pubDate>2009/09/22</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68170/</link></item><item><title>Indexes</title><description><![CDATA[<!-- Join 35,000+ -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_customers_2.htm?utm_source=ssc&utm_medium=rss&utm_content=35000custs_201003&utm_campaign=sqlbackup"><img alt="SQL Backup" height="68" src="http://www.red-gate.com/images/sql_server_central/backup3d_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>Join SQL Backup’s 35,000+ customers to  compress<br>
and strengthen your backups
</strong><br>"SQL Backup will be a REAL boost to any DBA lucky enough <br>
to use it." Jonathan Allen.  <br>
  <a href="http://www.red-gate.com/products/SQL_Backup/offers/backup_customers_2.htm?utm_source=ssc&utm_medium=rss&utm_content=35000custs_201003&utm_campaign=sqlbackup">Download a free trial now.</a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/questions/Performance+Tuning/66196/</guid><pubDate>2009/09/07</pubDate><link>http://www.sqlservercentral.com/questions/Performance+Tuning/66196/</link></item><item><title>Defragmenting and rebuilding indexes</title><description><![CDATA[Following code snippet will selectively rebuild indexes that have been thrashed after a big indert]]></description><guid>http://www.sqlservercentral.com/scripts/Rebuilding+indexes/67791/</guid><pubDate>2009/08/26</pubDate><link>http://www.sqlservercentral.com/scripts/Rebuilding+indexes/67791/</link></item><item><title>Back to basics: Optimizing SQL Server indexes</title><description><![CDATA[When created and maintained correctly, indexes help SQL Server retrieve data quickly. See how to ensure your SQL Server environment is running up to speed.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67878/</guid><pubDate>2009/08/21</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67878/</link></item><item><title>Unique constraints</title><description><![CDATA[]]></description><guid>http://www.sqlservercentral.com/questions/Indexing/66611/</guid><pubDate>2009/07/29</pubDate><link>http://www.sqlservercentral.com/questions/Indexing/66611/</link></item><item><title>Retaining historical index usage statistics for SQL Server - Part 3</title><description><![CDATA[In this, the third of the four part series on persisting the rowset results from the indexing Dynamic Management Views cached in temporary internal SQL Server structures we will explore what is required to store the missing index-related metadata.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67506/</guid><pubDate>2009/07/20</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67506/</link></item><item><title>Partitioned Table and Index Strategies Using SQL Server 2008</title><description><![CDATA[The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66760/</guid><pubDate>2009/07/10</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66760/</link></item><item><title>Using Indexes to Reduce Blocking in Concurrent Transactions</title><description><![CDATA[New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.]]></description><guid>http://www.sqlservercentral.com/articles/Performance+Tuning/67134/</guid><pubDate>2009/07/07</pubDate><link>http://www.sqlservercentral.com/articles/Performance+Tuning/67134/</link></item><item><title>view, index and schemabinding!</title><description><![CDATA[<!-- SQL Server monitoring made easy -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse"><img alt="SQL Response" height="68" src="http://www.red-gate.com/images/marketing/SSC/response_ico.gif" width="68" border="0"/></a></td>
  <td><strong>SQL Server monitoring made easy </strong><br />"Keeping an eye on our many SQL Server instances<br> is much easier  with SQL Response." Mike Lile.<br><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse">Download a free trial of SQL Response now. </a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/questions/T-SQL/66448/</guid><pubDate>2009/06/29</pubDate><link>http://www.sqlservercentral.com/questions/T-SQL/66448/</link></item><item><title>Disabling Indexes</title><description><![CDATA[]]></description><guid>http://www.sqlservercentral.com/questions/Indexing/66449/</guid><pubDate>2009/06/23</pubDate><link>http://www.sqlservercentral.com/questions/Indexing/66449/</link></item><item><title>The Ultimate Dupe Finder &amp; Performance Test Parameter Set Researcher</title><description><![CDATA[Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!]]></description><guid>http://www.sqlservercentral.com/scripts/Administration/66847/</guid><pubDate>2009/05/29</pubDate><link>http://www.sqlservercentral.com/scripts/Administration/66847/</link></item><item><title>Retaining historical index usage statistics for SQL Server</title><description><![CDATA[In this three-part series I'll look at what you can do to persist this data so you don't find yourself waiting for usage stats to compile over a reasonable period of time just so you can harness the power of the indexing DMOs in your performance tuning process. ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66973/</guid><pubDate>2009/05/26</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66973/</link></item><item><title>Reindex SQL Tables</title><description><![CDATA[This stored procedure will reindex indexes based on the fragmentation lever.]]></description><guid>http://www.sqlservercentral.com/scripts/Indexing/66529/</guid><pubDate>2009/05/14</pubDate><link>http://www.sqlservercentral.com/scripts/Indexing/66529/</link></item></channel></rss>