SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag index Rss

Search for any content tagged index

   Items 1 to 3 of 3   

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 742 reads

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.  Read more...
By Additional Articles 2017/02/28 | Source: SQLPerformance.com | Category: index
Rating:  Rate this |   Briefcase | 5,526 reads

Reclaiming Space After Column Data Type Change

A brief overview of how to reclaim storage space after altering the data type of a column.  Read more...
By David Fundakowski 2016/08/09 | Source: SQLServerCentral.com | Category: data type
Rating: |  Discuss |   Briefcase | 1,716 reads
   Items 1 to 3 of 3