Search: nonclustered

More Results

Sort by: Relevance | Date

  • Database index design and optimization: Some guidelines

    Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response... Tip   |   SearchSQLServer.com

  • xVelocity Columnstore Indexes in SQL Server 2012

    With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in the SQL Server database engine. It is based on VertiPaq in-memory data compression technology. The xVelocity... Tip   |   SearchSQLServer.com

  • Designing SQL Server non-clustered indexes for query optimization

    Non-clustered indexes improve SQL Server query performance by focusing queries on a subset of data. In this tip, you'll find guidelines for designing non-clustered indexes, including choosing index fields, when a... Tip   |   SearchSQLServer.com

  • Adding non-clustered indexes to SQL Server columns

    Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server databases. Ask the Expert   |   SearchSQLServer.com

  • Clustered and non-clustered indexes in SQL Server

    Rules for using a clustered index vs. a non-clustered index are tough to decipher. In this tip, you'll see the fundamentals to consider when making your choice, along with some best practice techniques. Get an overview of tradeoffs... Tip   |   SearchSQLServer.com

  • Scalability, capacity skew colossal in SQL Server 2012

    Because issues of scale often arise in large data sets, most of the new features for scalability and... Tip   |   SearchSQLServer.com

  • Clustered index vs. non-clustered index

    This expert response examins clustered indexes vs. non-clustered indexes. Ask the Expert   |   SearchSQLServer.com

  • Cluster index vs. non-cluster index

    When should I use cluster index and when should I use a non-cluster index?
    Indexing is a going to be a topic for a future tip. In the mean time, I want to recommend the following resources:
    • Ask the Expert   |   SearchSQLServer.com

    • Quick steps: Creating a nonclustered index in code

      Learn to create a nonclustered index in code using Query Analyzer in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation. Book Excerpt   |   SearchSQLServer.com

    • How to speed up a composite nonclustered index-based query

      Here's the situation: A composite nonclustered index is created with XYZ table with the columns ordered, seqno,del_date to improve the query below:

      SELECT * FROM XYZ WHERE del_date BETWEEN @datefrom AND @dateto AND... Ask the Expert   |   SearchSQLServer.com

    Search Again: